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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy