March 26, 2014 at 9:13 am
Good morning everybody! I am working with Mirroring an enviroment (Windows Server 2012 DataCenter) - 64 Bits and my SQL is SQL Server 2012 Enterprise. I do the configuration but I have a doubt respect the message
The server network address "TCP://PUMB.abc.com.pe: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. (Microsoft SQL Server, Error: 1418)
I have already check the ports and they are OK, The firewall is turn down.
I'm not sure about it:
Service accounts for the following instances. => I put the account with privilegies for the main and the mirror. The configuration finish OK but when I try to Star Mirroring it show
The server network address "TCP://PUMB.abc.com.pe: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. (Microsoft SQL Server, Error: 1418)
Please, I need your help!
Grettings
PD: Excuse if my english is not good, my native language is Spanish
March 26, 2014 at 10:36 am
March 26, 2014 at 11:31 am
Thanks for the recomendation but I checked these options but the problem persist.
I think the problem is about the service account but I don't know What is the account?
March 26, 2014 at 12:35 pm
cesarscorp2 (3/26/2014)
Thanks for the recomendation but I checked these options but the problem persist.I think the problem is about the service account but I don't know What is the account?
Are you using same service account for both Principal and Mirror databases ?
--
SQLBuddy
March 27, 2014 at 4:13 am
cesarscorp2 (3/26/2014)
Thanks for the recomendation but I checked these options but the problem persist.I think the problem is about the service account but I don't know What is the account?
first check the name resolution to ensure the TCP address is valid. Double check the port used for the mirror endpoint too.
Check the Windows application log and advise back any errors you find
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 27, 2014 at 9:15 am
cesarscorp2 (3/26/2014)
Good morning everybody! I am working with Mirroring an enviroment (Windows Server 2012 DataCenter) - 64 Bits and my SQL is SQL Server 2012 Enterprise. I do the configuration but I have a doubt respect the messageThe server network address "TCP://PUMB.abc.com.pe: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. (Microsoft SQL Server, Error: 1418)
I have already check the ports and they are OK, The firewall is turn down.
I'm not sure about it:
Service accounts for the following instances. => I put the account with privilegies for the main and the mirror. The configuration finish OK but when I try to Star Mirroring it show
The server network address "TCP://PUMB.abc.com.pe: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. (Microsoft SQL Server, Error: 1418)
Please, I need your help!
Grettings
PD: Excuse if my english is not good, my native language is Spanish
Todos los servidores estan en el mismo Dominio, cierto? Puedes darle ping al otro server usando el nombre completo? Yo empezaria por alli. Asegurate de que puedes darle ping al otro servidor usando el nombre completo.
Para hacer Mirroring, requires tener todos los servidores en el mismo Dominio, si no vas a usar certificates. Los puertos para Mirroring deben estar abiertos y debes tener EndPoints configurados en ambos lados.
March 27, 2014 at 3:48 pm
Thanks a lot my friends; I solved the problem when I configured an domain account in the services. I try again and All OK. On the other hand, Do you know about failover automatic? Because my mirroring doesn't have a witness and I would like the change between main and mirror is automatic.
By the way, Do you know the text box about the Listener port is disable, I would like register other port but I can't change the port for my configuration of Witness.
============================================================
Muchas Gracias sql-lover por responder y sobretodo en español; trato en lo posible de escribir en inglés pero a veces no se me da tan bien; gracias por el apoyo felizmente pude resolver el inconveniente!!! =D
March 27, 2014 at 4:36 pm
cesarscorp2 (3/27/2014)
Thanks a lot my friends; I solved the problem when I configured an domain account in the services. I try again and All OK. On the other hand, Do you know about failover automatic? Because my mirroring doesn't have a witness and I would like the change between main and mirror is automatic.By the way, Do you know the text box about the Listener port is disable, I would like register other port but I can't change the port for my configuration of Witness.
============================================================
Muchas Gracias sql-lover por responder y sobretodo en español; trato en lo posible de escribir en inglés pero a veces no se me da tan bien; gracias por el apoyo felizmente pude resolver el inconveniente!!! =D
Yeah, you can make the DB mirroring to have automatic failover by adding witness server.
Check this link ..
http://technet.microsoft.com/en-us/library/ms190430.aspx
--
SQLBuddy
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply