HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

How to transfer files at remote location using sql server job?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
serversqlfilesusinghowremotejobtransferlocation

Problem

I have a job configured in which it transfers the file at remote location.

My command is running absolutely fine from the command prompt but when I configured it in sql server job it gives log on failure unknown user name or bad password.

I am not able to find out the exact reason that why this file is not being transferred.

If there is an error in my code then it should give the same error from the command prompt.
Can anyone help me understand why I am getting the error?

Solution

that's probably because the user trying to move the files is the user that is running the job (probably the user that SQL Server agent is configured to run). Try giving read permission to this user on the folder you are reading the files from and write on the folder you are writing the files.

Context

StackExchange Database Administrators Q#20430, answer score: 2

Revisions (0)

No revisions yet.