Login failed (Urgent)

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hello sir,

I install a replication with two servers serv1 and serv2. serv1 is a distributor and publishing server. serv2 is subscriber server. my database name in serv1 is 'test',and the database distribution name is'test_distribution' (it is in serv1). in serv1 , i execute this commande: ->sp_dropserver serv2 ->sp_addserver serv2 ->sp_addremotelogin serv2,sa,sa The security mode in the two servers is 'standard'. my probleme is this: when i want to install subscribing server (serv2) i receive this message: ->Unable to connect to site 'serv2'because login failed.

Any advice please (is urgent)..

-- Anonymous, October 07, 1999



The SQL Server Books Online has an article titled, "Troubleshooting" in Administrator's Companion 6.0/Part 6 Replication/Chapter 15 Advanced Replication/Troubleshooting and Recovery/Troubleshooting.

This will advise you on how to assure that the login is successful.

Good Luck,


-- Anonymous, October 11, 1999

Moderation questions? read the FAQ