Thursday, March 29, 2012

error: copy database wizard

SQL SERVER SERVICE IS RUNNING UNDER THE LOCAL SYSTEM
ACCOUNT.
YOU NEED TO CHANGE YOUR SQL SERVER SERVICE ACCOUNT TO
HAVE THE RIGHTS TO COPY FILES OVER THE NETWORK.
Hi,
Yes, The copy database wizard requires the write permissions in destination
server folder. So you should start the SQL Server in both the servers using
domain user which got write access to the destination server folder.
How to change the startup SQL server account:-
1. Go to Control Panel -- Admin tools -- Services
2, Double click MSSQL server services
3. Go to Log on option and change the start up account and password to a
domain user.
4. Do the same for both servers
5. restart both sql servers.
(I feel like you are starting SQL server in Local system account.)
Thanks
Hari
MCDBA
"new" <anonymous@.discussions.microsoft.com> wrote in message
news:a8ce01c4368d$098b76c0$a401280a@.phx.gbl...
> SQL SERVER SERVICE IS RUNNING UNDER THE LOCAL SYSTEM
> ACCOUNT.
> YOU NEED TO CHANGE YOUR SQL SERVER SERVICE ACCOUNT TO
> HAVE THE RIGHTS TO COPY FILES OVER THE NETWORK.

No comments:

Post a Comment