SQL Server 2008 Mirror (Witness issue Error 1456)
Posted on 2014-04-15
I have set up database mirroring before and know most of the gotchas with adding in a mirror, but I am really stuck on this new build.
Our setup is
3 physical boxes all with live IP and local lan.
Server A and Server B are domain controllers and the Witness is a member of the domain.
SQL and the agent runs as domain\administrator
We have mirroring working on Server A and B but without the Witness.
All servers through SSMS can connect to each other using the Windows AD login.
So, why is it when I add in the Witness do I get
TITLE: Microsoft SQL Server Management Studio
The ALTER DATABASE command could not be sent to the remote server instance 'TCP://witness:5022'. The database mirroring configuration was not changed. Verify that the server is connected, and try again. (Microsoft SQL Server, Error: 1456)
On the witness
select * from sys.database_mirroring_endpoints
Mirroring 65536 261 2 TCP 4 DATABASE_MIRRORING 0 STARTED 0 2 WITNESS 1 3 NEGOTIATE 0 1 RC4
All servers have hosts / dns entries, nothing is connecting on IP.
So I am now very stuck and need to fix this quickly :(