Replication problem

[vaidyanathanpc]

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.

&quot;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.&quot;
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

 

[Andel]

You should have not deleted the database. You should have just deleted or truncated its tables.

If you can't connect to server 1 now using enterprise manager, try starting the server in dos, open query analizer then create db1 database again.


Andel
andel@barroga.net

http://andyb.8m.com