Can't see sql server instance

  • SeeCoolGuy

    SSCrazy

    Points: 2871

    I'm trying to setup a mirrored database for my friend, I'm referencing this guide

    http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1199004,00.html#implement

    what's odd is that server A can see Server B w/o issues. What it can't see is the instance on Server B. I thought that perhaps the instance was setup to not accept remote connections but after checking the configuration tool I see that it's configured just like the default instance on server B. What I did notice was that it's default port was blank instead of having a value such as the default value for the default instance.

    I'm really out of ideas here, I've uninstalled and re-installed the instance several times, rebooting each step of the way and I can't see the forest for the trees. From Server B I can register all instances (the default instance in Server A, Server B and Server B\Witness) but even when I complete the wizard setup the mirror fails with an error to reaching the primary server A.

    This is the error I get when I try to setup the mirror:

    TITLE: Database Properties

    ------------------------------

    An error occurred while starting mirroring.

    ------------------------------

    ADDITIONAL INFORMATION:

    Alter failed for Database 'myDB'. (Microsoft.SqlServer.Smo)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476

    ------------------------------

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    The server network address "TCP://ServerA.DomainName.local: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. (Microsoft SQL Server, Error: 1418)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476

    ------------------------------

    BUTTONS:

    OK

    ------------------------------

    any assistance with this is truly appreciated.

    -- Francisco

  • fasttrack

    SSCertifiable

    Points: 6071

    Hello,

    I do not if it may be useful, but "SQL Server Browser" is enabled?

  • SeeCoolGuy

    SSCrazy

    Points: 2871

    I'm not 100% up on my terminology for Sql Server 2005, but Sql Server Browser is that just the Management Studio?

    -- Francisco

  • RBarryYoung

    SSC Guru

    Points: 143327

    No, SQL Server Browser is a service that tells clients what instances are available and where they are.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • SeeCoolGuy

    SSCrazy

    Points: 2871

    Thanks, that is what it was. I enabled the sql browser and i was able to connect to the the instance. I am still having a problem with the mirroring but I will post back to the correct thread 🙂

    Thank you for your help that was invaluable! 🙂

    -- Francisco

  • fasttrack

    SSCertifiable

    Points: 6071

    I am happy for having helped you

Viewing 6 posts - 1 through 6 (of 6 total)

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