Dienstag, 12. März 2013 09:58
I get message in event handler every 20 seconds:
Service Broker login attempt by user 'MY-DOMAIN\SQL.user.' failed with error: 'Connection handshake failed. The login 'MY-DOMAIN\SQL.user' does not have CONNECT permission on the endpoint. State 84.'. [CLIENT: 172.16.0.83]
What that means? That client 172.16.0.83 try to send the message every 20 seconds or vice versa?
Where can I see what is happening and how to stop this sending? I'm not running any service on my computer under account MY-DOMAIN\SQL.user.
Dienstag, 12. März 2013 18:56Please check the service broker setup on the database on the machine in question here. once you have found the service broker application, try running ssbdiagnose on it, which will help you pinpoint the most probably rootcause of this error message.
Sanil Mhatre | Database Developer | MCTS | If you find my reply useful in any way, please vote it as helpful. If it has helped answer your question, please mark it as Answer. http://sqlwithsanil.com
- Als Antwort markiert simonxy Mittwoch, 13. März 2013 09:35
Mittwoch, 13. März 2013 09:36
I have found where the problem was.