Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Help setting up Mirroring on my Test pc in SQL Server 2012 Developer. Expand / Collapse
Author
Message
Posted Monday, May 06, 2013 6:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 17, 2014 7:30 AM
Points: 18, Visits: 185
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?



Post #1449682
Posted Monday, May 06, 2013 7:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 17, 2014 7:30 AM
Points: 18, Visits: 185
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.


Post #1449721
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse