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 |
|
vaidyanathanpc
Starting Member
24 Posts |
 Posted - 2002-03-08 : 15:13:16
|
| Hi, I have two different servers Server1 and Server2. I had a database DB1 on Server1 which I restored onto the server Server2 with the same name DB1. Then I deleted the database DB1 from the server Server1. Now when I try to establish snapshot replication of DB1 from Server2 onto the Server1, I'm getting the following error."A connection could not be established to Server1 - Cannot open default database '<ID>'. Using master database instead.Please verify SQL server running and check your SQL server registration properties (by right-clicking on the Server1 node) and try again."DB1 was the default database on Server1 which I deleted after restoring the same onto Server2.Now I'm not even able to connect to server1.I'm using the user SA. Thanks in advance.Regards,P.C. Vaidyanathan |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-03-08 : 15:24:37
|
| Have you tried resetting the default database to master for the sa user? |
 |
|
|
vaidyanathanpc
Starting Member
24 Posts |
Posted - 2002-03-09 : 03:27:09
|
| I'm not even able to connect to the server through enterprise manager. Is there any other way I can change the default database to master? |
|
|
|
vaidyanathanpc
Starting Member
24 Posts |
Posted - 2002-03-14 : 03:21:40
|
| I recreated the database throught the command prompt and now it's working fine.ThanksP.C. Vaidyanathan |
|
|
|
|
|
|
Replication problem