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.

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.

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.

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.

Coping Stored Procedures

I have and ASP.NET and VB.NET application that needs to copy selected stored procedures from one SQL Server to another SQL Server. The scenerio is that the user will select a source server from a drop down list then the source database from another dropdown listbox which then populates a listbox with the stored procedures in the database. They can select multiple stored procedures from the listbox.

Once selected, they select a target SQL Server from a dropdownlist and then a target database from another dropwdown list. I have a command button that they need to do the actual move but I am not sure how to get the selected source stored procedures copied to the target database. Any ideas would be greatly appreciated.Do you want copy store procedures at run time?
you may try sp_helptext 'sp-Name' . it ruturns the source code.
Then connect to second server and run the code generated from sp_helptext.|||Loads of ways DTS, sp_helptext to name but two methods.|||How can I use DTS to do this?|||Remember stored procs are nothing more than text in a database table. Literally.