0

TLDR: SQL Server mirror setup between 2 different VM servers on domain, need help

I have 2 virtual machines, both running SQL server 2016, the principal and the mirror that I want to set up for mirroring

I can connect to the principal on the mirror and vice versa. Both are on the same domain, and the SQL service is being ran with the same domain account.

That domain account has connect permissions on the endpoints created for mirroring, and I can telnet to the port that the endpoints are listening on.

I've restored the principal database and transaction log with no recovery on the mirror

and using the mirror setup GUI, I get the error:

Database cannot be opened it is in the middle of a restore

Using the SET PARTNER script I get the error:

The server network address "[TCP:\network address:port]" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.

Thoughts?

migrated from stackoverflow.com Sep 23 '17 at 4:22

This question came from our site for professional and enthusiast programmers.

  • 1
    On SQL 2016, why not use an AG? Basic Availability Groups are available on SQL 2016 Standard Edition, and are intended to eliminate the need to use Mirroring, which is deprecated. docs.microsoft.com/en-us/sql/database-engine/… – David Browne - Microsoft Sep 18 '17 at 23:52
  • Thanks for the input @david-browne-microsoft, I'll look into that – A. deBruyn Sep 19 '17 at 14:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy