SQL SERVER – Mirroring Configured Without Domain – The server network address TCP://SQLServerName:5023 can not be reached or does not exist

Regular readers of my blog will be aware of my friend who called me few days ago with very a funny SQL Problem SQL SERVER – SSMS Query Command(s) completed successfully without ANY Results. This time, it did not take long before he called me up with another interesting problem, although the issue he was facing this time was not that interesting and also very specific to him, however, he insisted me to share with all of you. Let us understand his situation at first.

My friend is preparing for DBA exam Exam 70-450: PRO: Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008 and for the same, he was trying to set up replication on his local laptop. He had installed two different instances of SQL Server on his computer and every time when he started the mirroring, it failed with common error message.

The server network address “TCP://SQLServer:5023″ cannot 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)

Well, before he contacted me, he searched online and checked my article written on the error in mirroring. However, he tried all the four suggestions, but it did not solve his problem. He called me at a reasonable time of late evening (unlike last time, which was midnight!). I even tried all the seven different suggestions myself, as previously proposed in my article; however, none of them worked. While looking at closely at services, I noticed something very simple. He was running all the instances on ‘Network Services’. In fact, his computer was a stand-alone computer. There was no network at all. Also, there was no domain or any other advance network concepts implemented.

I just changed services from ‘Network Services’ to ‘Local System’ as his SQL Server was running on his local system and there were no network services. This prompted to restart the services. As this was not the production server and his development machine, we restarted the services on the laptop (do not restart services on production server without proper planning).

After changing the ‘services log on’ account to localsystem, when he attempted to reconfigure the mirroring it worked right away. As usually in production server, proper domains are configured and advance network concepts are implemented I had never faced this type of problem earlier. My friend insisted to post this solution to his situation, wherein there was no domain configured and setting up mirroring was throwing an error. According to him, this is bound to help people, like him, who are preparing for certification using single system.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

15 thoughts on “SQL SERVER – Mirroring Configured Without Domain – The server network address TCP://SQLServerName:5023 can not be reached or does not exist

  1. Thanks, I will make a note of this, this situation can crop up when one is installing the sql server ,the server piece on a local pc/laptop.

    Like

  2. Thank you!, I’ve been searching to a solution to a problem I am having which seems like a a slight variation on the above. I have three seperate machines each running SQL Server 05 under local system. The machines are in a workgroup not domain and all have identical DNS suffix ‘local’.

    When attempting to start mirroring I get the following on the mirror server log – (sometimes, not always?!):

    Message
    Database Mirroring login attempt by user ‘NT AUTHORITY\ANONYMOUS LOGON.’ failed with error: ‘Connection handshake failed. The login ‘NT AUTHORITY\ANONYMOUS LOGON’ does not have CONNECT permission on the endpoint. State 84.’. [CLIENT: 192.168.1.4]

    It doesnt seem to matter however what credentials I supply when setting up the mirror via the wizard it either has some (error regarding anonymous login appears in log) or no effect (wizard fails with complaint one or more servers lacks FQDN – As far as I can tell this shouldnt be the case, they are all in format machinename.local and all pingable using the machinename.local form of address)

    I can telnet to the mirror port to and from all machines so the route seems good to me – clearly I lack authentication but I cant determine where or what I need to grant

    Really would appreciate a steer on this

    Thanks

    Philip

    Like

  3. Thanks….
    I am A new DBA and also provide Basic training for SQL dba, one time at my student’s satnd alone PC is got the same error at the time of my Mirering lecture, But I aneble to solve it before I read this post. thnks
    P.Dev.

    Like

  4. Pingback: SQL SERVER – Database Mirroring and Fine-Prints – Quiz – Puzzle – 23 of 31 « SQL Server Journey with SQL Authority

  5. Hi Pinal Dave

    I have whole-heartedly embraced all of your suggestions thus far and still get the old 1418 error. I have 2 instances of SQL 2008R2 installed and one version of SQL Express (for witness) all locally on a PC that is on a domain. No matter what steps I take (including that above and your step by step guide) I still cannot reach the network address nor can I perform mirroring. Your thoughts would be appreciated.

    Like

  6. ya it worked for me as well but i would like to know about mirroring in different machine without using a domain.. i know we need to issue a certificate. When i quered to create an endpoint it says already an endpoint exists and how to create an endpoint while one is already exist?

    Like

  7. Goto System properties->Computer name->click Change button->click More button-Type the text box in “something.com” click ok->ok->Apply->ok

    After restart the computer it will change

    mirrioring also worked

    Like

  8. I opened 3 instances of sql 2012 in my laptop. I am not able to mirror with above problem.I manually created 3 end points in different instances with 5022,23,24 port numbers. same problem agai. I don’t know about telnet or pinging between instances. Can you help me. I done remaining steps as above +7 steps of you article.please help me

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s