Can't setup mirroring - keep getting 1418

In SQL 2012, I've tried setting up mirroring between 2 servers with no success.  I keep getting 'The server network address "TCP://1.2.3.4:7023" can not be reached or does not exist when trying to mirror from the principal. Check the network address name and that the ports for the local and remote endpoints are operational.

I have also tried by name instead of IP address

I have restored both the database and the transaction logs in NORECOVERY

I can telnet 7023 and ping this host.

From the mirror, I can also telnet on the specified port 7022

They are both listening on each specified ports according to netstat -a

I've tried using both the wizard and with t sql statements

I can however mirror from one instance to another (that I setup for testing) on the principal server

What else could I be missing?


March 17th, 2015 2:06am

What about SQL services account, are they running with same accounts

http://stackoverflow.com/questions/11032937/how-to-resolve-error-1418-in-sql-server-while-mirroring

Free Windows Admin Tool Kit Click here and download it now
March 17th, 2015 3:08am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics