October 31, 2006 at 8:49 am
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?
November 1, 2006 at 9:36 am
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?
November 1, 2006 at 9:43 am
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