Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Network backup issue Expand / Collapse
Author
Message
Posted Wednesday, June 25, 2014 12:54 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 4:26 PM
Points: 21, Visits: 58
SQL server backup issue

When backing up databases on SQLSever2012 to a backup server I am receiving the following error:

failed with the following error: "xp_create_subdir() returned error 5, 'Access is denied.'"
." failed with the following error: "Cannot open backup device


I was able to backup databases to the same location on both SQLServer2008 and 2005 without error so I don't know why I can't backup to the same location on SQLServer2012 as they're setup the same.

When connecting to the server and opening Windows Explorer I'm able navigate to the backup location by entering the network location e.g \\backupdatabase\backup and I can view the folder and create files in this location but when trying to backup to this location I still receive "Access denied" as above.


The account used to login to the server has sysadmin permission and full access to the backup servers folders

The account used to login to The "SQL Server Agent" within services is running under a domain account and has sysadmin permission and full access to the backup folder.

If both the SQLServerAgent account and the account used to login to the server have sysadmin permissions and full permissions to the backup folders then why would access be denied? Please let me know if im missing another step.
Post #1585765
Posted Wednesday, June 25, 2014 4:04 AM This worked for the OP Answer marked as solution


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:22 AM
Points: 14,205, Visits: 28,534
I'd double check the security for the account that's running SQL Server. The error you're getting is a security error. It doesn't sound like that account has the correct privileges.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1585801
Posted Wednesday, June 25, 2014 6:26 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 4:26 PM
Points: 21, Visits: 58
The SQL Service is running under a Windows NT account and therefore doesn't have access to the backup location.

My understanding is that backup jobs run under the SQLAgentService login though and not the SQLService login so as long as the SQLAgent account is a domain account and has access to the backup folder it should be working.

Is this correct? Or do backups in fact run under the SQLService login and that login will need permissions to the backup folder and not the SQLAgent account?

If so I will need to change the SQLService login to a domain account so that I can provide it access to the backup folder that's on another server which i was hesitant on doing unless required as I'm trying to avoid restarting the server.
Post #1585857
Posted Wednesday, June 25, 2014 6:38 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:22 AM
Points: 14,205, Visits: 28,534
Nope, the Agent doesn't do the backups, the SQL Server executable and service does. That needs the permissions.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1585864
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse