I've recently installed a new server with Windows 2003 Server R2 o/s, and sql 2005 standard edition. This has been built to be my witness server (i originally installed SQL express, which is what i'll go back to once i resolve the problem).
I've got an existing Mirrored configuration, on two separate servers, but when i try to add this new server as a witness (on the same domain as the principle), it errors. As i stated earlier, i originally installed SQL Express, that generated the same error as the SQL standard thats on it now.
The error message is:
Database Mirroring login attempt failed with error: 'Connection handshake failed. There is no compatible encryption algorithm. State 22.'. [CLIENT: 192.168.130.3]
This is the event viewer error on the witness server itself. SQL Studio Manager generates a generic "unable to connect to remote server" error.
I've looked at Microsoft for this, and there's a lot of information about people experiencing this problem, but it all seems to be a problem with sql logons (they all need to be the same). Or DNS issues.
I've verified the logons for SQL, and all three servers use the Domain Admin account. I've looked at a hotfix solution from Microsoft and this done nothing.
I've tested the mirror using a different SQL server as a witness and it works fine (all using the same domian admin account). I've checked the account that the services start up in windows, and all servers use the same account.
The problem i'm experiencing seems to be related to this new server, and i'm not sure what other configuration is required on the SQL server instance, that isn't standard "out of the box".
If anyone has any advice it would be appreciated as i've been battling this for about two weeks now, and don't seem to be getting far.