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.