Help setting up Mirroring on my Test pc in SQL Server 2012 Developer.

  • 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?

  • 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