March 17, 2008 at 11:02 pm
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)
------------------------------
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
March 18, 2008 at 4:26 pm
Hello,
I do not if it may be useful, but "SQL Server Browser" is enabled?
March 18, 2008 at 4:54 pm
I'm not 100% up on my terminology for Sql Server 2005, but Sql Server Browser is that just the Management Studio?
-- Francisco
March 18, 2008 at 9:32 pm
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]
March 18, 2008 at 10:00 pm
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
March 19, 2008 at 3:18 pm
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