SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 database mirroring error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mahajanakhil1985
Yak Posting Veteran

India
71 Posts

Posted - 09/07/2010 :  11:49:38  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

Germany
8764 Posts

Posted - 09/07/2010 :  12:48:17  Show Profile  Visit webfred's Homepage  Reply with Quote
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.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36810 Posts

Posted - 09/07/2010 :  12:50:48  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

mahajanakhil1985
Yak Posting Veteran

India
71 Posts

Posted - 09/08/2010 :  10:48:10  Show Profile  Reply with Quote
Thanks!

everything suggested by webfred and tkizer already tried. Is there anything else that I can do?
Go to Top of Page

mahajanakhil1985
Yak Posting Veteran

India
71 Posts

Posted - 09/08/2010 :  12:37:23  Show Profile  Reply with Quote
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>

Go to Top of Page

mahajanakhil1985
Yak Posting Veteran

India
71 Posts

Posted - 09/09/2010 :  05:46:50  Show Profile  Reply with Quote
Please help me out in solving this.
Go to Top of Page

mahajanakhil1985
Yak Posting Veteran

India
71 Posts

Posted - 09/10/2010 :  05:38:47  Show Profile  Reply with Quote
Any updates to this??
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36810 Posts

Posted - 09/10/2010 :  13:43:50  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

Hermosavnv
Starting Member

Ireland
2 Posts

Posted - 07/08/2013 :  04:01:20  Show Profile  Reply with Quote
unspammed
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000