Re: sql server
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/20/03
- Next message: Rand Boyd [MS]: "Re: Service Pack 3"
- Previous message: Sue Hoegemeier: "Re: linked server security for dummies"
- In reply to: bill: "sql server"
- Next in thread: Cindy Gross: "Re: sql server"
- Reply: Cindy Gross: "Re: sql server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 20 Nov 2003 08:01:03 -0700
The message is saying that you have SQL Server setup to use
the local system account for the startup account. When you
use local system for the SQL Server account, it will not
have access to network resources. Access to network
resources is required to copy a database to another machine.
You need to change the SQL Server service startup account to
a domain account that has the necessary permissions on the
other server.
For more information, refer to:
INF: Understanding and Troubleshooting the Copy Database
Wizard in SQL Server 2000
http://support.microsoft.com/?id=274463
-Sue
On Thu, 20 Nov 2003 06:41:52 -0800, "bill"
<anonymous@discussions.microsoft.com> wrote:
>I have 2 sql servers running on 2 different machines
>
>I am using the dts (meta data services packages and
>selecting the copy database task)
>
>I am trying to copy a database from one to the other. I am
>getting an error message saying
>
>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 right to copy files over the network
>
>
>Any help would be appreciated
>
>Thanks
- Next message: Rand Boyd [MS]: "Re: Service Pack 3"
- Previous message: Sue Hoegemeier: "Re: linked server security for dummies"
- In reply to: bill: "sql server"
- Next in thread: Cindy Gross: "Re: sql server"
- Reply: Cindy Gross: "Re: sql server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
