Login failed (Urgent)greenspun.com : LUSENET : SQL Server Database Administration : One Thread
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.
-- Anonymous, October 11, 1999