2006-08-09 21:52:45 UTC
mirroring without a witness is working fine. But when I try to set up a
witness, using either the Wizard or direct T-SQL, error 1456 appears, “The
alter database command could not be sent to remote server
Server A and Server B are running SQL Server 2005 Enterprise ed.
Server C is an installation of SQL Express running on a remote file server.
All 3 SQL Server servers run in the same domain and the endpoints have been
set up and connection permissions granted.
Querying the sys.database_mirroring_endpoints on each server yields these
Server EndPoint Role ConnAuthority
Server A Started Partner Negotiate
Server B Started All Negotiate
Server C Started Witness Negotiate
I have used command prompt “netstat –abn” to confirm that the witness is
listening on the designated port (and no other processes are using that port).
So everything I can check looks OK, but I can’t get the mirroring to start.