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 2008 Forums
 High Availability (2008)
 can't start database mirroring
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

learntsql
Aged Yak Warrior

India
516 Posts

Posted - 05/02/2011 :  03:26:37  Show Profile  Reply with Quote
Hi All,

I am trying to conifigure database mirroring on 2 vms with SQL Server 2008 R2 standerd edition.
after configuring it when i click on start mirroring its giving error as
"The server network address "TCP://Mirror.testdomain.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)"

How to resolve this one.
TIA.

tkizer
Almighty SQL Goddess

USA
37466 Posts

Posted - 05/02/2011 :  11:56:35  Show Profile  Visit tkizer's Homepage  Reply with Quote
Telnet to the ports from both sides to verify they are open.

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

Subscribe to my blog
Go to Top of Page

learntsql
Aged Yak Warrior

India
516 Posts

Posted - 05/03/2011 :  00:26:26  Show Profile  Reply with Quote
Thanks Tara,

Please tell me how telnet to port 5022.
I tried but noluck.
TIA.
Go to Top of Page

raghuveer125
Constraint Violating Yak Guru

India
285 Posts

Posted - 05/03/2011 :  00:53:41  Show Profile  Reply with Quote
1.Open network connection
2.Right click on local area connection and click properties
3.click advance tab
4.click settings
5.click exceptions
6.click on button add port
7.Give name Ex:mirror
8.Port number 5022
9.and Click OK OK two time



Raghu' S
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37466 Posts

Posted - 05/03/2011 :  12:30:20  Show Profile  Visit tkizer's Homepage  Reply with Quote
I telnet via a cmd window: telnet ServerName PortNumber

If it gives you a blank screen after you hit enter, then that's good it means it's open. If it gives you an error, well you're going to have to fix that in order for mirroring to work.

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

Subscribe to my blog
Go to Top of Page

learntsql
Aged Yak Warrior

India
516 Posts

Posted - 05/04/2011 :  01:15:51  Show Profile  Reply with Quote
Thanks Tara,

Yes its working when i telnet from my XP client machine to that server.
but when i login in to Server machine and telnet local its saying
"'telnet' is not recognized as an internal or external command,
operable program or batch file."

My server is installed with Windows Server 2008 R2 Standard.

Plz guide me..
TIA.
Go to Top of Page

learntsql
Aged Yak Warrior

India
516 Posts

Posted - 05/04/2011 :  01:20:47  Show Profile  Reply with Quote
Hey I got this one.
In windows server 2008 R2 by default it was not added.
I added this like
Server Management ==> Add Features ==> Telnet Client.
Thanks.
Go to Top of Page

learntsql
Aged Yak Warrior

India
516 Posts

Posted - 05/04/2011 :  01:39:35  Show Profile  Reply with Quote
But Still i am unable to configure mirroring.
getting same error message
"The server network address "TCP://Mirror.testdomain.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)"
Please guide me.
TIA.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37466 Posts

Posted - 05/04/2011 :  12:47:16  Show Profile  Visit tkizer's Homepage  Reply with Quote
Testing telnet from your client machine is not what we need to test.

You'll need to get telnet installed in order to do this test. It's not installed by default on Win2k8. It doesn't require a reboot, but it does take a few minutes to complete.

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

Subscribe to my blog
Go to Top of Page

learntsql
Aged Yak Warrior

India
516 Posts

Posted - 05/05/2011 :  00:06:46  Show Profile  Reply with Quote
Tara I did this process.
Installed Telnet client and server in my server.
still same error.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37466 Posts

Posted - 05/09/2011 :  19:44:28  Show Profile  Visit tkizer's Homepage  Reply with Quote
If you are getting an error in the telnet client, then you've got a network/firewall issue.

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

Subscribe to my blog
Go to Top of Page

learntsql
Aged Yak Warrior

India
516 Posts

Posted - 05/10/2011 :  01:04:20  Show Profile  Reply with Quote
Thanks Tara,

Please provide some solution.
Plzzzzz.....
TIA.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37466 Posts

Posted - 05/10/2011 :  12:50:17  Show Profile  Visit tkizer's Homepage  Reply with Quote
I'm not a network or firewall person, so I'm unable to help. I can only help with the SQL Server side and light Windows administration.

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

Subscribe to my blog
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.12 seconds. Powered By: Snitz Forums 2000