Posted by d.grabov on 10/31/06 14:23

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?

• Next in forum: Comparing Database Data
• Prev in forum: SQL 2005 - Export table to a fixed width file.
• Thread view: setting up witness on SQL SERVER Express

[Reply to this message]