x

An error occurred while starting mirroring

I am setting up Database mirroring two sqlserver instance, one is a physical server one is a VM. After going through all the process of setting up Database miroring, at the end of the wizard when i click the button:Start mirroring, i receive this error: An error occurred while starting mirroring. Addional information: Alter failed for Database 'mydb'(Microsoft.SqlServer.Smo) (Microsoft.SqlServer.ConnectionInfo) The server network address "TCP://Myservername.domain.gm:5022 cannot be reached or does not exist. Check the network address name and that the ports for local and remote endpoint are operational.

Pls help. i am a newbie on this

more ▼

asked Mar 07, 2013 at 12:05 PM in Default

avatar image

ecomma
470 18 22 26

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

You first need to confirm the two servers can talk to each other. You can try this by using telnet to connect via the ports you will use. You can also try opening SSMS on each server and connect to each other. If you find this connection is not open then contact your network engineer group that is responsible for your internal firewall and ask them to open up the necessary ports.

more ▼

answered Mar 07, 2013 at 12:48 PM

avatar image

Tim
40.4k 39 85 166

Ha! 30 seconds. So there.

Mar 07, 2013 at 12:49 PM Grant Fritchey ♦♦

Looks like the extra vote negated the early answer advantage :(

Mar 07, 2013 at 05:51 PM KenJ

Oh well. I guess I'll survive. Ha!

Mar 07, 2013 at 06:39 PM Grant Fritchey ♦♦

Most likely firewalls blocking 5022 or another application has grabbed the port before SQL Server. Try "telnet Myservername.domain.gm 5022" both ways between servers.
You can also try running "netstat -nb" and look for 5022

Mar 07, 2013 at 07:56 PM Blackhawk-17
(comments are locked)
10|1200 characters needed characters left

Sounds like you don't have connectivity between the two servers. You need to log on to the primary server us a remote desktop. Then attempt to connect to the second server. If you can't, then that's the problem. You need to ascertain why. Is the second server accepting connections? Do you have the network configured correctly? Are you running things under the correct accounts? Are the security settings configured to allow connection between the two? All that has to be worked through.

more ▼

answered Mar 07, 2013 at 12:48 PM

avatar image

Grant Fritchey ♦♦
137k 20 43 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2136

asked: Mar 07, 2013 at 12:05 PM

Seen: 2316 times

Last Updated: Mar 07, 2013 at 07:56 PM

Copyright 2016 Redgate Software. Privacy Policy