database mirroring error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

database mirroring error

Author

Topic

mahajanakhil1985
Yak Posting Veteran

71 Posts

Posted - 2010-09-07 : 11:49:38

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?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-09-07 : 12:48:17

Just an idea:
On the server that can't be reached go into Configuration manager and see if protocol TCP/IP is enabled.

No, you're never too old to Yak'n'Roll if you're too young to die.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-07 : 12:50:48

Verify that you can telnet to that. Do that for both endpoints.

So for the primary server's endpoint, go to the mirror server and try to telnet to the primary server,EndPointPort. Then do the same in reverse. You will likely find that the port is blocked.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

mahajanakhil1985
Yak Posting Veteran

71 Posts

Posted - 2010-09-08 : 10:48:10

Thanks!

everything suggested by webfred and tkizer already tried. Is there anything else that I can do?

mahajanakhil1985
Yak Posting Veteran

71 Posts

Posted - 2010-09-08 : 12:37:23

Following is the output that I get when I check the ports from one machine from another. I get the similar output in vice-versa case.

C:\PortQryV2>PortQry.exe -n ctx -e 5022

Querying target system called:

ctx

Attempting to resolve name to IP address...

Name resolved to 101.91.0.33

querying...

TCP port 5022 (unknown service): LISTENING

C:\PortQryV2>

mahajanakhil1985
Yak Posting Veteran

71 Posts

Posted - 2010-09-09 : 05:46:50

Please help me out in solving this.

mahajanakhil1985
Yak Posting Veteran

71 Posts

Posted - 2010-09-10 : 05:38:47

Any updates to this??

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-10 : 13:43:50

If we had any updates, we'd post them. I think you need to open a case with Microsoft to get help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog