snippetsqlMinor
How to transfer files at remote location using sql server job?
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?
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.