May 1, 2007 at 3:44 am
Newbie here..Im trying to get mirroring going on 2 new (identical) servers using the wizard. Both running Windows 23k/SP2 etc. No witness.
When I try to set mirroring I get the following message and cant work out why...
-> One or more of the server network address lacks a fully qualified domain name (FQDN). Specify th e FQDN for each server. Mirroring and click Start again.
-> The syntax for a fully-qualified TCP address is:The syntax for a fully-qualified TCP address is :
-> TCP://
The primary is called SQL0 and the secondary is SQL1. I have tried:
Principal: TCP://sql0:5022
Mirror: TCP://sql1:5022
and
Principal: TCP://sql0:5022
(eg) Mirror: TCP://sql1.domain.com:5022
I can telnet on port 5022 both ways and can access the databases via Copy Database Wizard feature etc. Any ideas?
May 7, 2007 at 9:27 am
I'm having the same issue and would love to figure out what I'm doing wrong.
My servers are identical as well running on a Workgroup and I'm trying to mirror via a WAN vs local network connection.
Thanks,
Paul
May 8, 2007 at 3:06 am
Can you ping the server by FQDN ? Maybe it is a network issue.
May 10, 2007 at 4:32 am
Yes, I can ping from both ends. Still stumped. 🙁
March 28, 2008 at 2:01 pm
Not sure if this is the most optimal work around, but is does work. Edit the host file on all three
servers...your principal, your mirror and your witness. In the host file create a FQDN for each server.
Example:
10.0.0.1 principalservername.domainname.local
10.0.0.2 mirrorservername.domainname.local
10.0.0.3 witnessservername.domainname.local
the domain name can be your domain name and just add .local to the end.
This worked for me.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply