Someone removed the witness from our SQL Mirroring configuration.
He wanted to do a test. (Bad idea on a production server)
Now, when i try to add the witness, i get the following error message :
ALTER DATABASE xyz SET WITNESS='TCP://abc.domain.com:7022';
Msg 1427, Level 16, State 31, Line 1
The server instance 'TCP://abc.domain.com:7022' could not act as the witness. The ALTER DATABASE SET WITNESS command failed.
All servers use SQL 2008 (10.0.4000)
Endpoints are started. Authentication by certificate.
I can telnet the port.
Everything worked fine before the witness was removed. Why can not I add it?
Any idea ?