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