Microsoft KB Archive/263438

= SMS: Integrated SQL Setup Does Not Work if Server Name Contains Hyphens =

Article ID: 263438

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Standard Edition
 * Microsoft Systems Management Server 2.0 Service Pack 1

-



This article was previously published under Q263438



SYMPTOMS
Systems Management Server (SMS) Setup cannot perform an integrated SQL installation on site server computers that contain hyphen characters (-) in their names. Note that the Express Setup option for SMS also exhibits this problem.



CAUSE
This problem can occur because the SQL version 6.5 installation is restricted to servers without hyphens in their names. SQL 7.0 does not have this restriction. However, SMS Setup does not differentiate between the two while considering the server name for a SQL installation. SMS Setup does not accept hyphenated server names for either SQL version during the SQL installation.

SQL 6.5 does not work properly if the computer name contains hyphens, but SQL 7.0 removed this restriction. SMS Setup was never updated for the new behavior, so it checks the computer name under the assumption that every version of SQL server has the hyphen restriction. This blocks Express Setup and integrated SQL installations on these computers.



WORKAROUND
To work around this problem, avoid installing SQL on servers whose names contain hyphens. If you are running SQL 7.0, install SQL first, and then perform a custom installation for SMS.



STATUS
Microsoft has confirmed this to be a problem in Systems Management Server version 2.0.

Additional query words: prodsms

Keywords: kbbug kbnofix kbsetup kbsms200presp3 KB263438

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.