I have a SQL Server Agent job that backs up a database on a remote server to a network drive. Linked Server, I believe is set up correctly but I get the following error:
Msg 3013, Sev 16, State 1, Line 35
BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000]
Msg 3201, Sev 16, State 1, Line 35
Cannot open backup device. Operating system error 1326
(failed to retrieve text for this error. Reason: 1815). [SQLSTATE 42000]
I have used SQL Server Configuration Manager to change the Log On to "This Account", selected the domain account and supplied the right password.
Then, on the Linked Server Properties, I mapped the Local Login to the domain account and ticked "Impersonate" The security on the network drive folder is set to "everyone" and full permission is given. And yet still getting this error and cannot backup the database as a result.
What can I do?