May 6, 2013 at 6:08 am
Hi,
I am following the article on this site about setting up Database Mirroring and am having a bit of difficulty setting it up in my test environment.
I have recently installed SQL Server 2012 Developer Edition on my pc so that I can test mirroring.
To do this I have installed 3 instances and enabaled Named Pipes and TCP/IP. I have 1 default instance and 2 named instances.
I have backed up and restored the DB and the Tlog onto the secondary sever.
I have managed to created the enpoints (As all 3 are on the same machine I have given each one a separate port number).
I have run the alter databse on the secondary server.
The issue I am having is when I run the alter database on the primary server to set the partner database I get the following error
Msg 1418, Level 16, State 1, Line 1
The server network address "TCP://MY-PC.local:5023" 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.
I have checked the endpoints and they are present and started. I have aslo checked that the user is in the relevant local policy as specifed in the article.
Can anyone suggest what I am missing?
May 6, 2013 at 7:44 am
I have now fixed this issue. It seems that even though all 3 instances are on my local machine they need to run with a windows account rather than the default system accounts the services use when SQL is installed.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply