Can't see sql server instance

Question

Post reply

Can't see sql server instance

SeeCoolGuy

SSCrazy

Points: 2902
More actions
March 17, 2008 at 11:02 pm

#187527

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

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

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

fasttrack SSCertifiable Points: 6071 More actions · Answer 1

Hello,

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

SeeCoolGuy SSCrazy Points: 2902 More actions · Answer 2

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: 143329 More actions · Answer 3

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: 2902 More actions · Answer 4

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 More actions · Answer 5

fasttrack

SSCertifiable

Points: 6071

March 19, 2008 at 3:18 pm

#791758

I am happy for having helped you