Re: Can't copy databases across network with copy wizard
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 04/14/04
- Next message: Geoff N. Hiten: "Re: Windows 2003 Terminal Server"
- Previous message: DHatheway: "Re: Kill SPs then sqlserveragent stop working - <== NOT Tested, Possibly Hazardous!"
- In reply to: JackO: "Can't copy databases across network with copy wizard"
- Next in thread: Jeff Duncan: "RE: Can't copy databases across network with copy wizard"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 14 Apr 2004 13:32:25 -0600
You would need to change the destination server to run under
a domain account. Then you need to restart SQL service.
The configuration requirements for using the copy database
wizard can be found in the following article:
INF: Understanding and Troubleshooting the Copy Database
Wizard in SQL Server 2000
http://support.microsoft.com/?id=274463
-Sue
On Wed, 14 Apr 2004 11:26:05 -0700, "JackO"
<anonymous@discussions.microsoft.com> wrote:
>I am having trouble copying a database across a network using the copy database wizard.
>
>I am receiving the following error:
>
>'Your 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.'
>
>I have gone into services and set up the appropriate account to log unto the network servers with system admin priviledges but this does not solve the problem. Any step by step help would be appreciated.
>
>Regards
- Next message: Geoff N. Hiten: "Re: Windows 2003 Terminal Server"
- Previous message: DHatheway: "Re: Kill SPs then sqlserveragent stop working - <== NOT Tested, Possibly Hazardous!"
- In reply to: JackO: "Can't copy databases across network with copy wizard"
- Next in thread: Jeff Duncan: "RE: Can't copy databases across network with copy wizard"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
