In our environment we are maintaining Transactional replication between 2 servers.
Both servers are sql server 2005 with standard edittion.
By launching replication monitor in server 1 we can see both the servers publisher status.
But i found that server 2 publisher is not able to connect with distributor.I tried to connect to distributor.Here i am getting error like
Replication monitor could not connect to distributor of server 2.
Failed to connect to server 2 (Microsoft .Sqlserver.Conenctioninfo)
Login failed for user " .The user is not associated with a trusted sql server conenction .(Microsoft sql server ,error :18452)
Kindly help me to find out the exact rootcause.
View Complete Post