January 11, 2012 at 1:39 am
The server network address "TCP://192.168.147.24: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)
plz help me for this error, i m trying to configure DB mirrorring but every time i get this error.
January 11, 2012 at 1:44 am
Does that network address exist and can it be reached?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 11, 2012 at 1:47 am
Dhirju (1/11/2012)
The server network address "TCP://192.168.147.24: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)plz help me for this error, i m trying to configure DB mirrorring but every time i get this error.
you cannot specify IP address in the Mirroring wizard GUI, are your mirror servers part of a domain or a workgroup
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 1:47 am
yes, and i have checked the port(5022, 5023) has been opened using telnet command.
i dont know where the problem. :crying:
January 11, 2012 at 1:49 am
both server in domain controller, and i have checked with the server name also, but same error is occurred, server is not reachable..
January 11, 2012 at 1:54 am
Perry Whittle (1/11/2012)
you cannot specify IP address in the Mirroring wizard GUI
Specify the FQDNs of the servers in the mirror GUI and try again
have you successfully created the endpoints?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 1:58 am
yes. but, when i m going to click on start mirror button then it is giving error.
January 11, 2012 at 2:09 am
Dhirju (1/11/2012)
yes. but, when i m going to click on start mirror button then it is giving error.
even when you specify the FQDNs of the servers?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 2:14 am
i m sorry but, what is FQDNs?
January 11, 2012 at 2:17 am
Plz find attachment for more details
January 11, 2012 at 2:20 am
Fully Qualified Domain Name, example below
my domain name is UKTrading.co.uk
my server name is SQLServer1
The FQDN for the server is SQLServer1.UKTrading.co.uk
To connect to this server in a mirror session using port 5022 i would use
TCP://SQLServer1.UKTrading.co.uk:5022
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 2:23 am
yes i have specified FQDNs, please see attachment..
January 11, 2012 at 3:07 am
please help....
:hehe:
January 11, 2012 at 3:16 am
Patience. We all have our own jobs and our own problems and post here in our spare time. If you need immediate assistance, contact Microsoft CSS or hire someone.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 11, 2012 at 3:24 am
Dhirju (1/11/2012)
yes i have specified FQDNs, please see attachment..
do you have any firewalls between the nodes (Windows or otherwise)
Try a telnet to the port from the partner node
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 15 posts - 1 through 15 (of 40 total)
You must be logged in to reply to this topic. Login to reply