Error 1418 – Microsoft SQL Server – The server network address cannot 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.
Well, this blog about error 1418 is pretty straight forward. Do let me know if you find it easy to solve this problem. Though this blog post was written to the SQL Server 2005 it is still true and it is applicable to the latest version of SQL Server as well.
If you find any similar errors in your environment, please let me know and I will be happy to write about them on this blog.
Reference: Pinal Dave (https://blog.sqlauthority.com)
112 Comments. Leave new
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
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 !!
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.”
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?
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.
I have the above problems too….
After try and error and some readings, i fix the problem……
Hope this help everyone:
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
Thanks Alen328 That worked fine.
Above mentioned SQL settings are there by default (after installed SQL 2005).
I am having the same problem for SQL 2005 mirroring.
am getting error
the database principal does not exists
during the system copy of SAP
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)”
We were using 2 different domain accounts… once we made them the same, and re-started the services, everythiong worked.
ThomasLL
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
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
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
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.
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
PLease send me the detailed document for the error 1418
Plz send me the required docs.
Thanks in Advance,
jitu
Hi,
I am facing the same issue.Could you please send the document to my email.
Thanks in advance.
Uma
Please send me the step to resolve this Error 1418.
Thanks
Hi Marco,
Could you pls send me Mirror Document.
[email removed]
Thanx&Regards ,
Shankar.
I have the same problem, please send the detailed document
Hi
I have two SQL Server 2008 R2
A)- Primary
B)- Mirroring
No witness
Before I configured MIrror and success..
later remove mirrror from principle and set partner off of mirroring (B) Server and remove DB and create DB again and retsotore last backup and trn log with no archive same processes before
but error 1418 appears
waiting your help please
[email removed]
Regards
HI
I can get the problem. Plz send me the mirroring document
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.
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.
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
HI pls send the mirroring step by step document(i try to mirroring on diff server ill get the error 1418)
hi, i need the step by step guidence for sql database mirror.kindly send me the document
Thanks
Selvakumar
Dear Sureshkumar, We also have this problem. Please help us send your solution. Thanks so much.
Please send me document. I try more and more time but database mirroring doesn’t work. Thank you so much
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 :
Hi Sureshkumar,
I have the same problem with error 1418.
Could you please send me you doc?
TIA
hofi
Hi,
I am getting same error, i tried all possible solution. Pleae send me the setting document as soon as possible.
Hallo sureshhumar
please send the doc step by step for error 1418 sqlserver.
Thank you!
Volker
please send me the document for 1418
error i will be very thankful to u……
thanks®ards
g.harish
Plz send me doc for Microsoft sql server error no: 1418)
You can find it in SQL Server help file
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
Hi please seng document related to sql error 1418
my id :[removed email address]
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
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
i am facing same problem can u please help me on this my email id is
[email removed]
Ask a question. We are here to help you
Just you need to specify service accounts which are using on principal and Mirror Server.
Please send me the Doc.
can u please send me the mirroring document with step by step ..
Hi,
I also have the problem,
please send the step by step document to configure database mirroring.
thanks.
Hi Suresh,
i am having the same problem please send to me the step by step document.
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.
I am facing the same problem from last week.
Please send me the doc at [email removed]
i want document step by step.
Please share the step by step document
Hi Suresh Kumar,
I am getting into the same Problem. We initially tried with VM and then since it did not work, we tried with 2 Physical machines which are in Domain. Even then this problem occurs.
Would be great if you send me the Step by Step document that helps in resolving the above problem
hey suresh , could you please send me doc as I am facing same issue.
Regards,
Vikas
please send the document
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
hi
please send the documet about step by step that you do
this is my emai
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’
please send me step by step thaaaaaaaaaaanks