SQL Server 2008 permission issues on Windows Server 2008 R2, help please.
Posted on 2010-11-08
I recently installed a new server on our VM Network, SQL Server 2008 SP1 on Windows Server 2008 R2 Enterprise (both 64bit).
I am having some strange issues though, I setup the SQL services to run under NT AUTHORITY\NETWORK SERVICES during installation, everything installed just fine, but now I am running into issues such as...
When I try to back-up a database, and save it to the Backup directory on that same server, I get a permission denied message:
"Operating System Error 5 ( Access is Denied)"
Any idea how to fix this? I tried to move some databases over, doing a simple OS level copy/paste from the remote SQL, and I get access denied messages.
I am locally logged on to the SQL box as a Domain Admin, I can create new files on the NTFS location, but trying to copy stuff from remote location or using Server Manager Studio to back-up fails.