I am trying to mirror a database using Management Studio.
When everything is done and I click on "Start Mirroring', then I get the following error message after some time.
The server network address "TCP://CTX-2008.ent.test.com:5022" 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. (.Net SqlClient Data Provider)
I have downloaded 'portqry' utility from Microsoft's website and observed that the requires ports are open and their status is 'listening'.
The steps that I have followd are:
1. Restored a backup of principal database with 'no recovery' option. 2. Then restored the backup of transaction log with 'no recovery' option. 3. Then used Management Studion to configure mirroring.
On our domain, I have been able to setup "mirroring" but on a test domain with two machines, I am facing this error.
On test domain, 'select * from sys.database_mirroring_endpoints' returns the expected results.
Is there anything else that I could do to resolve this error?