I have a server running SQL Server 2008 R2 that runs a monthly job to import data into an existing database.
The backup to be imported is located on another share.
When the job runs, it fails with the following error:
Executing the query "RESTORE DATABASE [DB_00] FROM DISK = N'\\SERVER..." failed with the following error: "Cannot open backup device '\\SERVER\DB_00.bak'. Operating system error 1326(Logon failure: unknown user name or bad password.). RESTORE DATABASE is terminating abnormally."
For troubleshooting purposes, I set the SQL agent to run as domain administrator and it shows in the log:
Executed as user: DOMAIN\Administrator
I copied the path from the error message and pasted it into a window and the directory opens fine.
Does anyone see what I'm missing here?