October 31, 2014 at 9:10 am
Hi,
I am trying to configure database mirroring in sql server -2014 on the local windows 8 machine. I go following error . How to solve.
Not: I have not configured any virtual lab.all sql server instances are on the same machine.
TITLE: Database Properties
------------------------------
An error occurred while starting mirroring.
------------------------------
ADDITIONAL INFORMATION:
Alter failed for Database 'AdventureMirror'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.0.2000.8+((SQL14_RTM).140220-1752)&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://tas:7024" 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%20SQL%20Server&ProdVer=12.00.2254&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Thanx.
Taslima
October 31, 2014 at 11:39 am
How are you doing the mirroring, between desktop systems or between two instances on the same desktop?
What port(s) are you configuring for the instances?
October 31, 2014 at 1:35 pm
Hi,
Thanx for the reply.
I am doing mirroring between two instaces on a same desktop.
actually I am the programmer so I have zero knowledge in terms of administration or networking.
October 31, 2014 at 1:56 pm
How are you configuring mirroring?
November 2, 2014 at 7:55 pm
I think that the problem is because mirroring wants you to use fully qualified domain names (FQDN). TCP://tas:7024 is not. Simplistically, this needs to become something like TCP://tas.something:7024 for it to be a FQDN.
So how to achieve this ? In Windows Explorer, right click on "My Computer" and select Properties. In the "Computer Name" tab, click on "Change" - next to "To rename this computer or changes its domain or workgroup, click Change". In the box that pops up, click "More...". You now see the "DNS Suffix and NetBIOS Computer Name" dialog box. Enter a value for the "Primary DNS suffix of this computer (e.g. "local") and click OK.
You will need to restart the computer.
(This was on a Windows 8.1 computer - the names of the various screens may be different on other operating systems)
You computer will now have a FQDN of tas.local and the end point will become TCP://tas.local:7024 and mirroring should be a lot happier.
There may be other ways to achieve this but this works for me
November 2, 2014 at 8:19 pm
Also, each instance on the desktop system need to use different ports.
November 3, 2014 at 5:30 am
It works !!!
Thanks a lot
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply