I'm lost here, I am configuring a SQL Server for failover and have three servers.
Principal server > SQL 2008 R2
Witness server > SQL 2014
Mirror server > SQL 2008 R2
All three servers can ping the other via IP and FQDN.
The endpoints configure successfully but when I go to start mirroring, I get this error:
Alter failed for Database 'DBNAME'
The ALTER DATABASE command could not be sent to the remote server instance
'TCP://witness.domain.abc:5022'. The database mirroring configuration was not changed.
Verify that the server is connected and try again.
Any idea what this error is?
I restored the database and transaction log to the mirror server. All I did on the witness server is set up SQL, is there anything else I need to do?
Banging my head against the wall here.