sql server dts: Copy Database Wizard -- sql server dts

Copy Database Wizard

jez123456
9/7/2004 3:25:02 AM

sql server dts:

Hi, using the wizard I'm trying to copy a database from my local PC to a
server and I'm getting the following errors.

Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 08001)
Step Error Description:[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Step Error code: 80004005
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:700

Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 08001)
Step Error Description:[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Step Error code: 80004005
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:700

Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 08001)
Step Error Description:[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Step Error code: 80004005
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:700

Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 08001)
Step Error Description:[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Step Error code: 80004005
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:700

Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 08001)
Step Error Description:[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Step Error code: 80004005
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:700

Re: Copy Database Wizard

Sue Hoegemeier
9/7/2004 6:28:20 AM

There are some specific permissions needed for the accounts
on the servers at the OS level (as well as the permissions
in SQL Server). The account(s) just need permissions to
perform the actions needed for their role as the source or
destination server. You can find those in the following:
INF: Understanding and Troubleshooting the Copy Database
Wizard in SQL Server 2000
http://support.microsoft.com/?scid=274463

-Sue

On Tue, 7 Sep 2004 03:25:02 -0700, jez123456
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.