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?
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?