Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Copy Database Wizard Error Message

Author  Topic 

hnomani
Starting Member

35 Posts

Posted - 2001-07-30 : 18:01:29
I am trying to copy database between two servers using Copy Database Wizard. When I select the destination Server name and click Next button, I am getting the following message,

CDW Error Message
Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account to have rights to copy files over network.

I am logged in as an administrator and am using sa userid. Is there something else which I need to set to avoid getting any error?

I am using Windows 2000 and Sql Server 2000.
Thanks
   

- Advertisement -