September 5, 2014 at 3:32 pm
I just was handed off another Server.
The backups were failing I believe The Network Service does not have permissions to the D:\Backups\Full directory.
I tried creating a new Job and I got error message Login does not have permissions.
I have a Domain Account which I use for the SQL Server Service account which I use on my Servers.
Is that why it is failing?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 12, 2014 at 4:17 am
Not sure if you're still watching this post but I would check that the SQL Server Agent account has permissions to the directory.
As you're running the backup as a job it will run with that account's permissions.
September 12, 2014 at 9:15 am
It was the Database Engine Service Account.
I changed it last night and it worked.
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply