SQL broker service Endpoint authentication RRS feed

  • Question

  • I am doing a SQL Service broker basic programs from msdn tutorial.

    I created a endpoint with windows authentication in sql server( machine1 ).

    When I try to connect endpoint from another SQL server instance ( machine 2) . The instance sends the machine_name instead of my windows user name to the endpoint on machine1. So I getting the following error

    Service Broker login attempt by user 'mahinename$.' failed with error: 'Connection handshake failed. The login 'domain\machinename$' does not have CONNECT permission on the endpoint. State 84.'. [CLIENT: 10.xxx.10.xxx]

    I want to make the sql server to send my windows credentials.

    thanks in advance,



    Thursday, June 26, 2008 1:27 PM

All replies