How to perform full and differential backup in remote storage.
Hi, try to change the service account of the sql to domain user and give this user read write on the remote folder. you can also post your issue in sql forum to give you more help. Best Regards Mina Fouad
February 18th, 2011 10:53pm

Thanks Mina and Kris, Both MS SQL 2005 and windows internal db services are running in domain user (domain\administrator). The user has full access in remote storage drive and dbo roles in all databases.. But still i am getting the same error "SQL Server service account and the NT AUTHORITY\NETWORK SERVICE service account do not have permission to read or write to the backup folder.". Thanks in advance.
Free Windows Admin Tool Kit Click here and download it now
February 18th, 2011 10:56pm

Mina is correct. the Windows Internal DB by default is set to NT Auth\Network Service and you'll need to change that service account in the Windows Control Panel ->Administration -> Service to a domain account with dbo rights on the traget db. Make sure to restart the service when you make the change and try the change again.Kris Wagner, MVP, MCITP, MCTS Twitter @sharepointkris Blog: http://www.sharepointkris.com/blog
February 18th, 2011 11:00pm

How do i perform full and differential backup in remote storage device. I am getting failure message like "SQL Server service account and the NT AUTHORITY\NETWORK SERVICE service account do not have permission to read or write to the backup folder." I have moved content database from internal database to MS SQL 2005, however Sharepoint_adminContent, sharepoint_confi and wss_search databases are still in internal database. WSS is running in one of the DCs and domain users have access to remote storage device.
Free Windows Admin Tool Kit Click here and download it now
February 18th, 2011 11:09pm

Hi Pauzan, you can try to login with this account and try to access your share \\server\sharefolder and check whether you have access or not.
February 18th, 2011 11:41pm

Yes, the account has full access in shared folder. I can perform copy, paste and delete in the shared folder with this account. I think the problem is with NT AUTHORITY\NETWORK SERVICE account. I wonder why this account is used for backup.
Free Windows Admin Tool Kit Click here and download it now
February 18th, 2011 11:51pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics