SQL SERVER – Fix : Error: 1418 – Microsoft SQL Server – The server network address can not be reached or does not exist. Check the network address name and reissue the command

« SQL Server Interview Questions and Answers Complete List Download

SQL SERVER – @@DATEFIRST and SET DATEFIRST Relations and Usage »

SQL SERVER – Fix : Error: 1418 – Microsoft SQL Server – The server network address can not be reached or does not exist. Check the network address name and reissue the command

April 22, 2007 by pinaldave

Error: 1418 – Microsoft SQL Server – The server network address can not be reached or does not exist. Check the network address name and reissue the command

The server network endpoint did not respond because the specified server network address cannot be reached or does not exist.

Fix/Workaround/Solution:

Step 1) Your system Firewall should not block SQL Server port.

Step 2) Go to Computer Management >> Service and Application >> SQL Server 2005 Configuration >> Network Configuration
Enable TCP/IP protocol. Make sure that SQL SERVER port is by Default 1433.

Just to make sure follow one more step which may or may not be necessary.

Step 3) Go to Computer Management >> Service and Application >> SQL Server 2005 Configuration >> Client Configuration
Enable TCP/IP protocol.

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

Posted in Pinal Dave, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Security, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology | Tagged Computer Network | 99 Comments

99 Responses

on August 8, 2007 at 4:48 pm | Reply Joseph

I have setup everything accordingly but still receiing the error. I have this error with database mirroring. The account I use is an domain admin account with full privileges on each server.

That may have something to do with the VM ware server? all my 3 server involved in the mirroring operation are setup on the same VM server host.

Any help, I will appreciate
on August 10, 2007 at 12:09 am | Reply Praveen Barath

IMP: By default, some OS like Microsoft Windows XP Service Pack 2 and Windows Vista block all ports.!!so i sueggest to check the ports as well !

NOte : Corrective action might be required on both partners
.For example:

# if this message is raised when you are trying to run SET PARTNER on the principal server instance, the message might imply that you only have to take corrective action on the mirror server instance. However, corrective actions might be required on both partners.

#After resolving any issues ,
rerun the ALTER DATABASE database_name SET PARTNER statement on the principal server.

#Check this ,sys.database_mirroring_endpoints to diagnose the problem .

I hope will inline your needs
If you can dispalay a exact error which you encountred will be more helpful to diagnose !!
on September 24, 2007 at 9:01 pm | Reply Ashish

This is exact error. I did the configuration set up as per you but still face the same problem. I have seen that the windows firewall services are not enabled in both of principal and Mirror servers.

“Msg 1418, Level 16, State 1, Line 1
The server network address “TCP://172.20.52.58:10111″ can not be reached or does not exist. Check the network address name and reissue the command.”
on September 24, 2007 at 11:55 pm | Reply Ashish

Hi I want to add one thing here that I don’t have administrator rights in the mirror server m\c. Would this really matter?
on November 8, 2007 at 3:27 am | Reply Eric

I get the same 1418 error with my mirroring set up too. I have a domain user for all my services, I use the same account for my endpoints, have given this account full access, have checked tcp port to be 1433 on all three nodes (principal, mirror, witness), and I have granted connect permissions to this account.

The Server log shows the account logging in and then out. A port monitor shows the listener for the sql service and when the partner is assigned on the mirror, the port monitor shows the attempt of the connection but it shuts down after a few seconds and ultimately fails.
on November 10, 2007 at 9:42 am | Reply Alan328

I have the above problems too….

After try and error and some readings, i fix the problem……

Hope this help everyone:

http://alan328.com/SQL2005_Database_Mirroring_Tutorial.aspx
on February 21, 2008 at 7:20 pm | Reply Ganesh

We tried all the above suggestions but still no luck. Is there anything additional we need to do so that we can enable mirroring? The two servers we are using is SQl server 2005 and both are in the same network. The ports we are using are in listening mode. Is this the right way or do we need to do any changes? Is there any way to test the pinging of the ports so that we can test the communications between to servers
on March 21, 2008 at 2:37 am | Reply Richard Silva

Thanks Alen328 That worked fine.
on April 18, 2008 at 9:45 am | Reply Thomas Teoh

Above mentioned SQL settings are there by default (after installed SQL 2005).

I am having the same problem for SQL 2005 mirroring.
on August 23, 2008 at 4:05 pm | Reply ravi kiran

am getting error
the database principal does not exists

during the system copy of SAP
on August 28, 2008 at 1:36 am | Reply Wilson Tsai

This is also ’caused when the mirroring endpoints do not have matching encryption methods.

You can change this by altering your mirroring endpoints on both partners as shown below:

“ALTER ENDPOINT Mirroring FOR DATA_MIRRORING (ROLE = PARTNER, ENCRYPTION = SUPPORTED)”
on April 8, 2009 at 7:04 pm | Reply ThomasLL

We were using 2 different domain accounts… once we made them the same, and re-started the services, everythiong worked.

ThomasLL
on May 12, 2009 at 6:18 pm | Reply sureshkumar

Am also facing same error that is ” The Server Network address TCP://mirror:5023 can not be reached or doesnot exist . check the network address name and the ports for the local and remote endpoints are operational (Microsoft sql server error no: 1418) ”

can any one help please … am waiting for you reply
on May 12, 2009 at 6:22 pm | Reply sureshkumar

Am also facing same error that is The Server Network address TCP://mirror:5023 can not be reached or doesnot exist . check the network address name and the ports for the local and remote endpoints are operational (Microsoft sql server error no: 1418)

can any one help please … am waiting for you reply
on May 19, 2009 at 8:34 pm | Reply Vad

Msg 1418, Level 16, State 1, Line 1
The server network address “TCP://OFFICE:5023″ can not be reached or does not exist. I am having this message only establishing connectivity from principal to “mirror”. The other way around (from “mirror” to principle) worked fine.
alter database dbXXX
set partner = ‘TCP://OFFICE:5023′
Any help would be greatly appreciated.

Thanks,
Vad
on May 28, 2009 at 12:08 pm | Reply sureshkumar

I solved the problem by changing the way that instead of local system account i used domain user account that had rights on both servers !

please try in Domain … it’s resolve that problem

” TCP://mirror:5023 can not be reached or doesnot exist . check the network address name and the ports for the local and remote endpoints are operational (Microsoft sql server error no: 1418) ”

now is working fine …… if anybody want doc plz give your email id. i will send the doc step by step.
- on November 11, 2009 at 10:14 pm | Reply Marco
  
  Hi,
  
  I saw you fix the DB mirroring TCP port problem by using domain user. Could you send me the detail document? Will your solution work if this is a home PC without domain?
  
  Regards,
  
  Marco
  - on February 10, 2010 at 8:46 pm | Reply Hariharan
    
    PLease send me the detailed document for the error 1418
  - on April 16, 2010 at 4:01 pm | Reply jitu
    
    Plz send me the required docs.
    
    Thanks in Advance,
    jitu
  - on December 18, 2010 at 12:15 am | Reply uma
    
    Hi,
    
    I am facing the same issue.Could you please send the document to my email.
    
    Thanks in advance.
    
    Uma
  - on February 25, 2011 at 11:17 am | Reply Mirza
    
    Please send me the step to resolve this Error 1418.
    
    Thanks
  - on March 7, 2011 at 9:26 am | Reply shankar
    
    Hi Marco,
    
    Could you pls send me Mirror Document.
    [email removed]
    
    Thanx&Regards ,
    Shankar.
  - on October 24, 2011 at 1:04 pm | Reply Arvind
    
    I have the same problem, please send the detailed document
- on November 13, 2009 at 10:31 am | Reply Rickson Prabu
  
  HI
  
  I can get the problem. Plz send me the mirroring document
- on December 23, 2009 at 12:55 pm | Reply Kaliyan
  
  Hi Suresh,
  
  I’m trying to build the SQL 2008 Database Mirror, i m getting error 1418, could you share your experice or send me the article.
- on December 30, 2009 at 6:09 pm | Reply velmurugan
  
  Hi Suresh,
  
  I am not able to configure mirrioring through GUI mode . It will throw error like:
  TCP://(myaddress) can not be reached or doesnot exist . check the network address name and the ports for the local and remote endpoints are operational (Microsoft sql server error no: 1418)
  
  Kindy help to resolve this problem. If any help would be appreciated.
- on February 2, 2010 at 2:53 pm | Reply K.Rajasekar
  
  Hi,
  SureshKumar
  
  I had tried same server in different instances it’s work fine for mirroring,but i’ll use different server and different instance the mirroring error no 1418 throws the error,ill try to enabled tcp\ip protocols both the server,but still the problem.pls give the idea or u have any document
- on February 12, 2010 at 11:31 am | Reply Rajasekar
  
  HI pls send the mirroring step by step document(i try to mirroring on diff server ill get the error 1418)
- on April 7, 2010 at 5:16 pm | Reply Selvakumar
  
  hi, i need the step by step guidence for sql database mirror.kindly send me the document
  
  Thanks
  Selvakumar
- on April 14, 2010 at 3:35 pm | Reply trung vo
  
  Dear Sureshkumar, We also have this problem. Please help us send your solution. Thanks so much.
- on May 20, 2010 at 9:39 am | Reply hut
  
  Please send me document. I try more and more time but database mirroring doesn’t work. Thank you so much
- on June 23, 2010 at 11:21 pm | Reply Vardan Hakopian
  
  Hi sureshhumar
  Plz send the document about step by step that you do
  i do mirroring step by step in sql help and all thing is ok till i want exec the Alter command on principle server that give us 1418 event error Id, i exec this command on mirror server and i don get any error.
  plz send you doc for me maybe this help me, this is my email :
- on July 6, 2010 at 1:19 pm | Reply hofi
  
  Hi Sureshkumar,
  I have the same problem with error 1418.
  Could you please send me you doc?
  
  TIA
  hofi
- on July 6, 2010 at 6:01 pm | Reply Laxmi Prakash
  
  Hi,
  
  I am getting same error, i tried all possible solution. Pleae send me the setting document as soon as possible.
- on July 7, 2010 at 11:39 am | Reply Volker
  
  Hallo sureshhumar
  please send the doc step by step for error 1418 sqlserver.
  Thank you!
  Volker
- on August 26, 2010 at 3:48 pm | Reply harish
  
  please send me the document for 1418
  error i will be very thankful to u……
  thanks&regards
  g.harish
- on October 28, 2010 at 9:43 pm | Reply pankaj
  
  Plz send me doc for Microsoft sql server error no: 1418)
  - on November 1, 2010 at 3:18 pm | Reply madhivanan
    
    You can find it in SQL Server help file
- on December 4, 2010 at 4:51 am | Reply Nancy Herrera
  
  Hello, I was reading that you could resolve the error 1418, please, send to me the file with the solution. My email is: [email removed]. Thank you very much
- on December 31, 2010 at 1:53 pm | Reply swamynathan
  
  Hi please seng document related to sql error 1418
  my id :[removed email address]
- on August 9, 2011 at 11:05 pm | Reply Deepak Chauhan
  
  Hi,
  
  I m facing 1418 error in db mirroring
  TCP://mirror:5023 can not be reached or doesnot exist . check the network address name and the ports for the local and remote endpoints are operational (Microsoft sql server error no: 1418)
  
  please help me I have already spend two days to configure this.
  
  and i check everything is fine and i shocked before start mirroring mirror database state in in “restoring” but after start mirroring this state change to “recovering” but if port is not reached then how state is change if port is reachable then why the 1418 error.
  
  Please help me to save my job
  
  Thanks in advance
- on September 6, 2011 at 12:56 pm | Reply mohammad izhar
  
  i need step – by step doc for the probum…
  Error: “The server network address “TCP://servername:5022″ 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)”
  thanks regards
- on September 8, 2011 at 3:23 pm | Reply somna
  
  i am facing same problem can u please help me on this my email id is
  [email removed]
  - on September 9, 2011 at 3:49 pm | Reply madhivanan
    
    Ask a question. We are here to help you
  - on December 15, 2011 at 7:58 am | Reply Kapil Mahershi (HCL)
    
    Just you need to specify service accounts which are using on principal and Mirror Server.
- on September 30, 2011 at 10:04 pm | Reply jeremy
  
  Please send me the Doc.
- on October 12, 2011 at 11:52 am | Reply prabhaker
  
  can u please send me the mirroring document with step by step ..
- on October 24, 2011 at 1:08 pm | Reply Arvind
  
  Hi,
  I also have the problem,
  please send the step by step document to configure database mirroring.
  thanks.
- on October 24, 2011 at 3:58 pm | Reply Arvind Sharma
  
  Hi Suresh,
  i am having the same problem please send to me the step by step document.
- on October 27, 2011 at 9:20 pm | Reply Nagavara
  
  Hi, i am also facing the same problem. can you please send me the document which would be very helpful to my mail [email removed]
  
  Thanks.
- on November 17, 2011 at 5:12 pm | Reply nn
  
  I am facing the same problem from last week.
  
  Please send me the doc at [email removed]
- on December 13, 2011 at 2:51 pm | Reply Yogesh Lodha
  
  i want document step by step.
on July 22, 2009 at 12:04 am | Reply Poneh

Hi sureshhumar
Plz send the document about step by step that you do
i do mirroring step by step in sql help and all thing is ok till i want exec the Alter command on principle server that give us 1418 event error Id, i exec this command on mirror server and i don get any error.
plz send you doc for me maybe this help me, this is my email : negeen_arya@yahoo.com
on July 27, 2009 at 4:05 pm | Reply yasser

hi
please send the documet about step by step that you do
this is my emai
on July 29, 2009 at 10:17 am | Reply Vanice

Hi, I fixed the problem by adding the Principal Server’s Service Account (Domain account) to the Mirror SQL Server (As SQL Login) with ‘sysdba’ role. Then, this sttm was ran successfully :
ALTER DATABASE LiteSpeedLocal SET PARTNER = ‘TCP://MirrorServer.Domain.Com:5022′
on August 26, 2009 at 10:31 am | Reply behrooz

please send me step by step thaaaaaaaaaaanks
on September 2, 2009 at 1:12 pm | Reply Mario

can you send me a step-by-step instruction to fix the error 1418.

thanks.
on September 24, 2009 at 4:06 am | Reply Jeff

I ran into the same thing, here’s how i did it.
Do the same full backup of your primary and restore to your mirror. Be sure to restore in the “NO RECOVERY” mode. The DB will stay in restore mode. Once that is done, do a “Transaction Log backup” of your primary and then do a Trans restore to your mirror. At this point, you can go through the gui and setup your mirror. If at all possible, use the same domain account for the SQL service on both servers. Hope that helps.
on October 26, 2009 at 9:25 pm | Reply pshah

Sureshhumar,

I have set domain name for both servers, TCP/IP enabled, andnamed Pipes enabled. I am still getting SQL server , error 1418.

Could you please send me the document about step by step that you have mentioned.

Thanks
on December 5, 2009 at 11:25 pm | Reply Balajiraman.G

Hi suresh

Please send the step by step doc for the database mirroring.
on February 13, 2010 at 1:17 am | Reply Rosa

Hi suresh

Please send the step by step doc for the database mirroring.
on April 7, 2010 at 5:20 pm | Reply Selvakumar

Hi Guys!
I am trying to do the mirroring on two different servers, but i am getting error 1418, tcp & namedpipe also enabled.if i am trying in on two different instance on same server, then it works sucsessfully,

any one can help me on this
on April 18, 2010 at 7:27 pm | Reply zain

Please send the step by step doc for the database mirroring.
- on May 11, 2010 at 12:45 pm | Reply kiran
  
  Hello Suresh
  
  Please send the doc
  
  [email address removed]
on May 28, 2010 at 7:25 am | Reply yana

Hello Suresh!
Please, send me the doc!!!
on May 28, 2010 at 10:33 pm | Reply David Moore

How about posting the DOC here. As many people that are having the problem whouldn’t it just be easier than having to send it to everyone?
on June 18, 2010 at 10:20 pm | Reply Ed K.

I’m having the same problem as everyone else. I get the 1418 error, using the same domain id on both servers.
Please send me your documentation at
on July 7, 2010 at 1:52 pm | Reply Volker

Hallo Sureshhumar,
send please the doc for the error 1418, this is a katastroph, an Microsoft a debakel.
Thank you for this script.

Volker
on July 9, 2010 at 12:41 pm | Reply andhika

Hello suresh, I got the same problem here, please send me your doc please.

regrads
on July 20, 2010 at 5:31 am | Reply Shekhar

Hi Suresh,

I am facing same mirroring problem using SQL Server 2008 R2. Can you send your document please? Please…

Shekhar
on July 21, 2010 at 2:02 pm | Reply Shraddha

Hello suresh, I got the same problem here, please send me your doc please.

regrads
on July 26, 2010 at 7:31 pm | Reply Kyle

Hi Suresh,

I am facing same mirroring problem using SQL Server 2008 Standard. Can you send your document please? Thanks in advance!

Kyle
- on August 24, 2010 at 11:38 am | Reply vijay
  
  Hi suresh,
  
  I am also facing same issue,kindly mail me the steps to [email removed] .Help appreciated.
  
  Regards
  Vijay
on August 24, 2010 at 11:36 pm | Reply andrismg

Hi suresh,

I need to know if can set Mirroring in two server with :

Principal Server: SQLSERVER2005 SP3 EE
Partner: SQLSERVER2008 SP RTM

you think that I can set mirror in two servers?
on August 27, 2010 at 2:02 am | Reply Anu

Hi Suresh,

I am facing same mirroring problem using SQL Server 2008 . Can you send your document please?
on September 6, 2010 at 6:12 am | Reply Joseph

Suresh,

We are facing the same problem. Could you please send me the document as well?

Thank you
on September 25, 2010 at 9:25 pm | Reply Hitesh Bhagiya

I have sql server 2008 standard..
can u plz give me provide step by step mirroring …

i have same error while establishing mirroring
on October 8, 2010 at 9:31 pm | Reply Ivan

Hi Suresh,

I have same mirroring problem using SQL Server 2008 R2 . Can you send your document please?
on October 30, 2010 at 1:39 am | Reply sagar

Working solution.

1. Start MSSQLSERVER Services with Domain user credentials (instead of Local System Account) on principal database Server and Mirror Database Server.

Note: To switch from “Local System Account” to Domain User credentials do the following (a).

a) On Windows (XP or Server): Start -> Control Panel -> Administrative tools -> Services. Then right click on SQL Server (MSSQLSERVER). Then click on properties. And then click on tab “Log On”. And then choose radio button “this account”. Then provide the Domain user name and password.

If you want repeat (a) for all SQLSERVER related Services.

2. And then try the mirroring process in MS SQL Server Management Studio.
- on February 20, 2011 at 12:50 am | Reply sunny
  
  Awesome. Your solution worked for me. I just made sure that all the sql server services of different instances use the same windows login account that I use to log into my computer.
on November 10, 2010 at 2:04 am | Reply Marcio

Hi Sureshhumar,

I have same mirroring problem using SQL Server 2008.

Can you send your document please (error 1418) ?

Thanks
on November 12, 2010 at 7:21 pm | Reply Pramod

Hi Suresh,

I have the same problem configuring SQL server 2008 mirrroing, can you send me the document ?

Thanks,

Pramod
on November 21, 2010 at 6:07 pm | Reply jeong

thanks regard.

i want to document

(how to ms-sql 1418 error solve )

please a solve document

help me…

thanks.
on February 4, 2011 at 2:30 pm | Reply Mark Johnson

I had the same issue and my two servers are on the same domain with no local or physical firewalls in between. Nothing to do with ports in my case. It was simply that I had not used the correct Domain accounts. I also ensured the two accounts used were local admin on both boxes (not sure if this is necessary). Worked fine after that. Im mirroring from a cluster by the way. Lets see how it looks in a week.
on March 21, 2011 at 5:15 pm | Reply Lars

I’ve tried all this but still got the error 1418
Check if your sql user has sysadmin rights under login in SQL Management Console. My account was setup with only public rights. It did work once I added sysadmin rights on the domain user running the SQL service. Hope that helps
on April 2, 2011 at 12:21 am | Reply Doug Zuck

I had the exact same problem. Was already using the same domain account to run SQL Service on both principal and mirror. Already had the firewalls open on both.

I was able to set partner on mirror with principal as target, but I would get the above mentioned error 1418 when trying to set partner on principal with mirror as target.

What fixed it for me was adding the SQL service domain account to the local admins group on both the principal and the mirror.

Thanks.
on April 12, 2011 at 9:11 pm | Reply Ashley

Hi Suresh,

I have the same erro, can you pls send me the document.

Thanks,
on April 20, 2011 at 2:16 am | Reply Laxman

Hi Suresh,

I have the same problem configuring SQL server 2008 R2 mirrroing, can you send me the document ?

Error: “The server network address “TCP://servername:5022″ 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)”

Thanks,
Laxman
on April 21, 2011 at 2:13 pm | Reply Ricky

Hi,

I have also met this issue when I configure the mirroring.

could you sent the doc to me?

Thanks in advance!
Ricky
on May 10, 2011 at 5:32 pm | Reply angela

kindly mail me the document
i have same issue with mirroring on sql 2008 server and my system runs windows 7
on May 26, 2011 at 2:31 pm | Reply Edgar

Seems like some people were able to fix this problem. but, ’till this date nobody was able to post a how to on this page.

A little how to about 10 lines or so would benefit all feature readers.

thanks.
on June 1, 2011 at 10:34 pm | Reply Jeff

I’ve read every post in this thread, and it is still failing for me.
- Put both computers in a domain.
- Put a domain user in the local admin group of both computers.
- Booted under that domain user.
- Run all SQL services under that domain user.
- Created a SQL user in SSMS of that domain user, and granted sysadmin rights.
- Attempt to configure mirroring; still get error 1418.
on June 4, 2011 at 1:56 am | Reply coors

I got the same error when I set a mirroring with certificates between two untrusted domain can you please send the those too.

Thank you
on July 30, 2011 at 3:32 pm | Reply raghuvamsi

HI to all,
I have configured like,
-two computers in same domain
- started all the mssqlserver and agent services(principle and mirror) under same domain account
created the mssqlserver security logins with sysadmin privs
followed the backup and steps restore steps properly
Attempt to configure mirroring; still getting same error 1418.

Hi suresh,

Please send database mirror document to my mail id

thanks,
J.Raghu
on September 5, 2011 at 3:46 pm | Reply Arash Moradabadi

Hi

Just take a look at URL below and follow the instruction.

Sure it works

JUST REMEMBER TO create the mirror endpoint first

http://www.sqlservercentral.com/articles/Database+Mirroring/72009/
on October 10, 2011 at 9:25 pm | Reply Mohamed Mubeeth

I have setup everything accordingly but still receiing the error. I have this error with database mirroring. The account I use is an domain admin account with full privileges on each server.
on November 23, 2011 at 3:57 pm | Reply Markus Mobius

I used the default accounts in SQL 2012 install which presumably is the network account. Both computers are in the same domain. I then used the two machine accounts on both computers:

domain\machine1$
domain\machine2$

That resolved the error for me.
on December 8, 2011 at 12:06 am | Reply sergiosaint

If your machines are not in a domain, take a look at this http://blogs.msdn.com/b/suhde/archive/2009/07/13/step-by-step-guide-to-configure-database-mirroring-between-sql-server-instances-in-a-workgroup.aspx it worked just fine for me.

For this case cenario seems to exist another simpler solution explained here http://www.kendalvandyke.com/2011/12/database-mirroring-in-windows-workgroup.html but i did not manage to put it to work using that solution.

Best regards :)
on February 8, 2012 at 10:28 pm | Reply RMS

Hi Anyone help me to get solve this issue? 1418 …

Same domain, full access ( sysadmin) for the domain users who has priv on both servers. fire walls off… END point are set.. still same problem..