Home > IT Answers > Database > Lacking a FQDN during database mirroring on SQL Server 2005
SQL Server Ask the Experts
2,585 pts.
 Lacking a FQDN during database mirroring on SQL Server 2005
Database mirroring, FQDN, SQL Server 2005, SQL Server errors, TCP
I am trying to work with database mirroring on SQL Server 2005, and I keep receiving the error message, “One or more of the server network addresses lacks a fully qualified domain name (FQDN). Specify the FQDN for each server, and click Start Mirroring again.” I know that the syntax for a fully-qualified TCP address is: TCP://<computer_name>.<domain_segment>[.<domain_segment>]:<port> However, I still receive the error. Do you have any ideas?

Software/Hardware used:
ASKED: September 2, 2008  6:59 PM
UPDATED: September 2, 2008  9:34 PM
RELATED QUESTIONS
Answer Wiki:
If SQL is telling you that it can't see the FQDN then either it can't see the internal DNS server, or the SQL Server can not be found in the domains DNS server. Use the nslookup command line tool to check that DNS is setup correctly for the machine. <pre>nslookup SQLServer.yourdomain.local</pre> Or check with your network admin and have him/her check the DNS server to ensure that the SQL Server has been registered correctly.
Last Wiki Answer Submitted:  September 2, 2008  9:34 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.