Post reply

Mirroring Error

  • 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

  • March 12, 2009 at 7:19 am

    #958287

    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]

  • March 12, 2009 at 7:20 am

    #958288

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

  • March 12, 2009 at 8:15 am

    #958344

    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

  • March 12, 2009 at 8:18 am

    #958347

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

  • March 12, 2009 at 8:20 am

    #958350

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

    TIA

  • March 12, 2009 at 8:26 am

    #958360

    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

  • March 12, 2009 at 8:33 am

    #958372

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

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

  • March 12, 2009 at 8:42 am

    #958381

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

  • March 12, 2009 at 8:45 am

    #958387

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

  • March 12, 2009 at 10:13 am

    #958481

    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].

  • March 13, 2009 at 1:38 am

    #958930

    Thanks Mohit,

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

  • March 13, 2009 at 5:27 am

    #959002

    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

  • March 13, 2009 at 8:49 am

    #959171

    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].

  • March 13, 2009 at 8:51 am

    #959174

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

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

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