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?