July 27, 2009 at 2:23 am
Hi,
I am trying to setup DB mirroring on SS2k5 and its failing with errors as
"The Server Network address "TCP://HQ-BMC-D-1.tdic.auh:5022" cannot be reached or does not exist. Check the network address name and the ports for the local and remote endpoints are operational. (Microsoft SQL Error, Error: 1418)".
Here's my endpoint script:
CREATE ENDPOINT [Mirroring]
AUTHORIZATION [TDIC\hq-srv-sdb]
STATE=STARTED
AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)
FOR DATA_MIRRORING (ROLE = PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE
, ENCRYPTION = DISABLED)
Please let me know, if i am missing something.
Thanks & Regards,
Rohit
July 27, 2009 at 2:31 am
Rohit ,
Looks like the isue is related to the FQDN .is HQ-BMC-D-1.tdic.auh a correct name or the actual name .Or its shadowing the actual name .
Other possibility could be the port being blocked or is in use already .
Regards
Abhay
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
July 27, 2009 at 3:56 am
Thanks Abhay for reply. I dont see here FQDN is the problem, as it is resolving the name correctly from principal server to mirror server.
The server HQ-BMC-D-1.tdic.auh is not the actual server. Its the VM Server and "HQ-BMC-D-1.tdic.auh" is the actual name of this VM.
The port 5022 is listening on "HQ-BMC-D-1.tdic.auh", which i tried using telnet on this port. Also, no connection is till yet established (checked from netstat -a)
Any idea, if the actual issue is with the VM? Logically, this should work.
July 27, 2009 at 5:25 am
What account are you running sql server under? as you will have issues if you are using a LocalSystem account
July 27, 2009 at 5:50 am
I am running both principal and mirror sql instances under domain account (service account) [domain_name\username]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply