Mirroring Error

Question

Mirroring Error

VastSQL

SSC-Dedicated

Points: 36097
More actions
March 12, 2009 at 7:08 am

#129695

Hi Experts,
I am getting the error
An error occurred while starting mirroring.
Alter failed for Database 'RKN'. (Microsoft.SqlServer.Smo)
The server network address "TCP://192.168.2.117.sprintdev.local:5022" can not be reached or does not exist. Check the network address name and reissue the command. (Microsoft SQL Server, Error: 1418)
I am using username:sa in both servers .
Please help
TIA

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

Richard M. SSCertifiable Points: 7401 More actions · Answer 1

Is 192.168.2.117.sprintdev.local reachable? Most likely not.... try only with 192.168.2.117

_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

ab5sr SSCarpal Tunnel Points: 4056 More actions · Answer 2

Check to make sure that your endpoints are visible; use telnet to see if open.

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 3

Thanks for the reply.

I am able to connect that machine using IP from SSMS.

During mirroring configuration also it accepts the IP but its rejecting the server name

ab5sr SSCarpal Tunnel Points: 4056 More actions · Answer 4

Can you add server with IP instead of name? Is DNS giving any error in eventvwr?

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 5

I am not able to connect through telnet. Can anyone please tell me the reason?

TIA

ab5sr SSCarpal Tunnel Points: 4056 More actions · Answer 6

No way to tell unless I get on the box. Try this to see if these steps help - sounds like you didnt' set up endpoints correctly.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=258365&SiteID=1

Richard M. SSCertifiable Points: 7401 More actions · Answer 7

...as mentioned above, use EITHER the IP address or the servername.. NOT BOTH

_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 8

My primary server is RTM and the mirror is SP2 ,Is that a problem?

ab5sr SSCarpal Tunnel Points: 4056 More actions · Answer 9

I found that quite a bit did not run well in RTM; I wouldn't advise it.

Mohit K. Gupta SSChampion Points: 12130 More actions · Answer 10

Mirroring wasn't supported until SP1. If you have mirroring running on local computer you will not be able to use server.local; it will not work. You have to use IP.

If you try to use server name you will get error similar to in my blog entry, Link.

Thanks.

[font="Arial"]---

Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE

* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

How to ask for help .. Read Best Practices here[/url].

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 11

Thanks Mohit,

Can you please be specific on how to give the IP address and whole endpoint.

ab5sr SSCarpal Tunnel Points: 4056 More actions · Answer 12

Just do what you are doing, but specify IP address rather than computer name. My blog has steps on how I set it up...have you checked it out?

Lee

Mohit K. Gupta SSChampion Points: 12130 More actions · Answer 13

Ratheesh.K.Nair (3/13/2009)
Thanks Mohit,
Can you please be specific on how to give the IP address and whole endpoint.

I use scripts for setting up mirroring because setting up over 40 databases mirroring using GUI is annoying .. I am a scripting guy 🙂

Please have a look ... http://sqllearnings.blogspot.com/2009/03/mirroring-scripts.html

They are not difficult to follow; if you need help let me know. Thanks.

Edit: Fixing link...

[font="Arial"]---

Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE

* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

How to ask for help .. Read Best Practices here[/url].

ab5sr SSCarpal Tunnel Points: 4056 More actions · Answer 14

Exactly neither do I. That's probably why he's having all of the difficulty