Replication monitor could not conenct to distributor

_{Thursday, October 21, 2010 4:00 AM}

Hi,

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.

_{Thursday, October 21, 2010 8:22 AM ✅Answered | 3 votes}

It is probably that you have configured replication monitor to connect to your distributor with an account which does not have the necessary rights to monitor SQL server. Can you ensure that SQL Server is able to authenticate using mixed authentication (right click on it, select properties, select security and ensure that SQL Server and windows authentication is selected. Add an account in the sysadmin role or verify with the sa account if you know password.- Kerobin

_{Thursday, October 21, 2010 11:43 AM ✅Answered | 3 votes}

Pls check if the password changed for the login is the same used in configuring the replication.

Also check the agent security settings under publication properties.

- Kerobin

_{Thursday, October 21, 2010 5:47 AM}

Please refer http://blogs.msdn.com/b/sql_protocols/archive/2008/05/03/understanding-the-error-message-login-failed-for-user-the-user-is-not-associated-with-a-trusted-sql-server-connection.aspx. It may be helpful.

Thanks, Mohan Kumar - www.sqlvillage.com -- Please mark the post as answered if it answers your question.

_{Thursday, October 21, 2010 7:07 AM}

Hi sir,

The data is not repliacting in between these 2 servers.At the same time we are observing one error

SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed.

Login failed for user ''. The user is not associated with a trusted SQL Server connection.

this error is occuring for every sec.

Please help me to find out exact root cause.

_{Thursday, October 21, 2010 8:27 AM | 1 vote}

Hi

Thanks for the replay.

It is using mixed aiutentication.yes we tried one time as u said but the thinkg still it is coming.So i am confusing .

_{Thursday, October 21, 2010 9:38 AM | 3 votes}

Hi kerobin,,

Sorry....

i forgot to tell yesterday we changed  the password for server 1.

Is this error due to changing password.....