Database Mirroring GUI does not work and throws FQDN error - by Michael Hotek

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 343027 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 5/9/2008 12:01:51 PM
Access Restriction Public

Description

I am getting an error within the Database Mirroring GUI about an FQDN that prevents me from using the GUI to configure Database Mirroring.  The specific error is:
TITLE: Database Properties
------------------------------

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.

The syntax for a fully-qualified TCP address is:
TCP://<computer_name>.<domain_segment>[.<domain_segment>]:<port>

------------------------------
BUTTONS:
OK
------------------------------

The relevant piece of ipconfig \all is:
Windows IP Configuration
        Host Name . . . . . . . . . . . . : hotek
        Primary Dns Suffix  . . . . . . . : 
        Node Type . . . . . . . . . . . . : Unknown
        IP Routing Enabled. . . . . . . . : No
        WINS Proxy Enabled. . . . . . . . : No

Principal:  TCP://hotek:5022
Mirror:  TCP://hotek:5023
Witness:  TCP://hotek:5024

Additionally, the fields to specify the server addresses for the principal, mirror, and witness are greyed out and do NOT allow any direct entry.  The only way to get an entry into those fields is to use the configure security wizard.  This is isolated ONLY to SSMS.  Database Mirroring will configure with NO errors by executing the appropriate ALTER DATABASE statements directly.  (But it sucks for a demo and when it blows up in front of a couple hundred people, doesn't leave them with a whole lot of confidence that a major HA feature will even work if a simple GUI doesn't even function.)

Version 9.0.3228
Sign in to post a comment.
Posted by Microsoft on 2/24/2009 at 7:39 PM
Michael, we are resolving this as wont fix in yukon. This is fixed in Katmai. Gopal
Posted by Microsoft on 5/14/2008 at 11:43 AM
Thanks for reporting this issue. As you have seen there are cases where the DBM UI is more restrictive in what it will accept compared to the DDL. This will affect demo scenarios, such as yours, where you're configuring mirroring using multiple instances on the same machine. Production scenarios should not be impacted as the servers will be in a domain and have a FQDN; if not in a domain then certificates needs to be configured and the UI cannot be used.

This issue is addressed in SQL Server 2008 - instead of an error message box, a warning is displayed and you have the option to continue.

On 2005, it looks like you will be able to workaround the issue - see the following forum post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1715639&SiteID=1

Thanks again for taking the time to report this issue.