Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vule
Starting Member
11 Posts |
 Posted - 2004-05-05 : 10:41:20
|
| Hi folks, I tried to copy one database from my work machine (server1) to another machine (server2). When I have been the "Choose a Destination" step, I did not see the name of the server2 under the "selected server" window. Do you know how to set up the server2 for server1 access through it? please show me how to do it. I don't know how to set up two servers connect together. I got the errors below during I have been this step: 1) Error source: Microsoft OLE DB Provider for SQL Server 2) Error Description: [DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exist or access denied. 3) Context: Error during initialization of the providerThanks,Vu |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-05-05 : 12:09:02
|
| Easier to do a backup and restore then you don't have to be connected to both at once.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
vule
Starting Member
11 Posts |
Posted - 2004-05-05 : 12:53:45
|
| But I have to copy the database following the DTS access. Please help me out if you know it.Thanks,Vu |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-05-05 : 13:30:02
|
| If you can't see the destination m/c from the pc you are running dts on then you can't do it.What happens if you try to ping the server. Can you access the sql server via query analyser?If you can do both those then you should be able to access via dts. Do you have the correct network stack? Check in client network utilities and put in an alias with a different protocol.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Errors of copying database from server1 to server