setting up witness on SQL SERVER Express

  • I am trying to set up mirroring between two SQL SERVER 2005 servers

    using a third SQL SERVER Express as a witness. However SQL SERVER

    Express does not seem to work as a witness. I have set up the

    endpoints, logins and permissions. When the principal tries to connect

    to the witness I get the following error message in the logs:

    Database Mirroring login attempt by user 'WITNESSDOMAIN\WITNESSNAME$.'

    failed with error: 'Connection handshake failed. The login

    'WITNESSDOMAIN\WITNESSNAME$' does not have CONNECT permission on

    endpoint. State 84.'.

    Setting up the witness on a SQL SERVER 2005 server with exctly the same

    permissions works without problems. Also, I noticed that the endpoints

    created do not show up on the SQL SERVER Express under Objects folder

    in the Management Studio where they should be. They do however exist

    and can be viewed using SQL statements.

    Can someone suggest a reason why the witness is not working?

  • Are you sure that your Express instance has TCP/IP enabled? It's installed by default with only shared memory enabled. Check it out in SQL Server Configuration Manager.

    Check out the topic "Grant Endpoint Permissions" in BOL and make sure you've covered all the bases. It appears that the user needs permission to even view the endpoints, which may be why they don't show up in Mgmt Studio. Perhaps the user you used in SQL Server (non-Express) was in an administrative role and automatically had permissions?

  • Thanks, I'll give it a go

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply