Thursday, March 22, 2012

Copy Database Wizard Problem

I am trying to copy a database from SQL server 2000 to SQL server 2005. In using the Copy Database Wizard I am getting an error. I have selected the SQL Management Object method as the transfer method. The error is occurring on the create package step when running. The error code is: "While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80004005 (Client unable to establish connection)."

check if you are writing the file to

the specified folder and make sure you have suffiecient

rights to write to it.

|||

I'm receiving the same message when trying to copy. I first installed SQL Express then updated to Developer edition.

Error:

While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80004005 (Client unable to establish connection).

|||

The destination server must be running SQL Server 2005 Service Pack 2 or a later version. The computer on which the Copy Database Wizard runs may be the source or destination server, or a separate computer. This computer must also be running SQL Server 2005 Service Pack 2 or a later version to use all the features of the wizard.

To use the Copy Database Wizard, you must be a member of the sysadmin fixed server role on the source and destination servers. To transfer databases by using the detach-and-attach method, you must have file system access to the file-system share that contains the source database files.

No comments:

Post a Comment