DOCUMENT:Q263438 05-AUG-2000 [sms] TITLE :Integrated SQL Setup Does Not Work if Server Name Has Hyphens PRODUCT :Microsoft Systems Management Server PROD/VER:winnt:2.0,2.0 SP1 OPER/SYS: KEYWORDS:kbsetup kbsms200 kbsms200bug kbsms200preSP3 ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft Systems Management Server versions 2.0, 2.0 SP1 ------------------------------------------------------------------------------- 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 : kbsetup kbsms200 kbsms200bug kbsms200preSP3 Technology : kbSMSSearch kbSMS200 kbSMS200SP1 Version : winnt:2.0,2.0 SP1 Issue type : kbbug Solution Type : kbnofix ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 2000.