AUSCERT External Security Bulletin Redistribution

            ESB-2002.302 -- Compaq Security Advisory (SSRT2195)
Compaq Insight Manager & Potential SQL Server /MSDE Security Vulnerability
                               25 June 2002


        AusCERT Security Bulletin Summary

Product:                Compaq Insight Manager XE (Version 1.1 and later)
                        Compaq Insight Manager 7 (all versions)
Vendor:                 Compaq
Impact:                 Execute Arbitrary Code/Commands
                        Denial of Service
Access Required:        Remote

Ref:                    ESB-2002.187

- --------------------------BEGIN INCLUDED TEXT--------------------

(SSRT2195) Compaq Insight Manager & Potential SQL Server
           /MSDE Security Vulnerability


NOTICE: There are no restrictions for distribution of this Bulletin
        provided that it remains complete and intact.



    Compaq Computer Corporation, a wholly-owned subsidiary of
    Hewlett-Packard Company and Hewlett-Packard Company HP Services
    Software Security Response Team

CROSS REFERENCE:  (CERT Incident Note IN-2002-04)


Broad-based attacks on Microsoft's SQL Server sites have been
recently discovered by many security research groups and reported
in an incident note by  CERT/CC . It first became apparent when it
was observed that there  was a sudden increase in hosts scanning
for port 1433, the  port commonly used by Microsoft's SQL Server.
This bulletin is in follow-up to  the previous announcements that
describe this potential threat.  The  malicious code  propagates via
an account "SA" that was set up, by the MSDE/SQL Server installation
program, with no default password.  The capability  to  use  MSDE
(free, scaled down version of Microsoft SQL Server) was included
on the Compaq  Management  CD  beginning  with  the  release of
Compaq Insight Manager XE 1.1, but is not installed as part of the
Compaq Insight Manager installation program. The MSDE installation
program is  included  (as a batch file) on all  subsequent  Compaq
Management CD's and must be installed manually. Although the Compaq
Insight Manager installation  recommends that the "sa" account be
set upon  installation, default installations of  MSDE  from  the
Compaq Management CD (or the Insight Manager 7 softpaq's) are not
properly secured without manual intervention.


    Compaq Insight Manager XE (Version 1.1 and later)
    Compaq Insight Manager 7 (all versions)

RESOLUTION: Note: If during current installations of Insight Manager
            the MSDE "SA" account password has been changed from the
            no password default, the impact of this potential threat
            has been diminished. The process to change or check for
            the default no password "SA" account for MSDE is:

    o Log into Insight Manager 7 as an administrator (prior to
      changing in MSDE ), click on Settings>Server>Database,
      change the "SA" password to your new password for the database.

A typical secure password for the database account should be greater
than six characters and contain alpha and numeric characters.

    o Stop the Insight Manager 7 service  Open a command window and
      navigate to the MSSQL7 directory

    o Type osql -Usa -P (this will log you on with the blank
      password provided the default password was not changed
      during installation)

    o Type sp_password @old="", @new= <choose-a-new-password-here>,
      @loginame = sa (Note: no space between the double quotes)

    o Type go

    o You will get a "Password changed." Message

    o Type exit

    o Restart the Insight Manager 7 service. It should login and
      run with the new password. Note: If the password was not
      changed successfully, then the Insight Manager 7 service
      will stop. At this time, call Compaq Customer Support in
      to resolve the situation.

SUPPORT: For further information, contact HP Services.

SUBSCRIBE:  To subscribe to automatically receive future
            Security Bulletins  from the Software Security
            Response Team via electronic mail:

    HP and Compaq appreciates your cooperation and patience.
    As always, HP and Compaq urges you to periodically review
    your system management and security procedures. HP and
    Compaq will continue to review and enhance the security
    features of its products and work with our customers
    to maintain and improve the security and integrity of their

    "HP and Compaq are broadly distributing this Security Bulletin
    in order to bring to the attention of users of the affected
    Compaq products the important security information contained
    in this Bulletin.  HP and Compaq recommend that all users
    determine the applicability of this information to
    their individual situations and take appropriate action.
    Neither HP nor Compaq warrant that this information is
    necessarily accurate or complete for all user situations and,
    consequently, neither HP nor Compaq will be responsible for
    any damages resulting from user's use or disregard of the
    information provided in this Bulletin."

 Copyright 2002 Compaq Information Technologies Group, L.P.
 Compaq shall not be liable for technical or editorial errors or
 omissions contained herein. The information in this document is
 subject to change without notice. Compaq and the names of Compaq
 products referenced herein are trademarks of Compaq Information
 Technologies Group, L.P. in the United States and other countries.
 Other product and company names mentioned herein may be trademarks
 of their respective owners.

- --------------------------END INCLUDED TEXT--------------------

You have received this e-mail bulletin as a result of your organisation's
registration with AusCERT. The mailing list you are subscribed to is
maintained within your organisation, so if you do not wish to continue
receiving these bulletins you should contact your local IT manager. If
you do not know who that is, please send an email to auscert@auscert.org.au
and we will forward your request to the appropriate person.

This security bulletin is provided as a service to AusCERT's members.  As
AusCERT did not write the document quoted above, AusCERT has had no control
over its content.  The decision to use any or all of this information is
the responsibility of each user or organisation, and should be done so in
accordance with site policies and procedures.

NOTE: This is only the original release of the security bulletin.  It may
not be updated when updates to the original are made.  If downloading at
a later date, it is recommended that the bulletin is retrieved directly
from the original authors to ensure that the information is still current.

Contact information for the authors of the original document is included
in the Security Bulletin above.  If you have any questions or need further
information, please contact them directly.

Previous advisories and external security bulletins can be retrieved from:


If you believe that your system has been compromised, contact AusCERT or
your representative in FIRST (Forum of Incident Response and Security

Internet Email: auscert@auscert.org.au
Facsimile:	(07) 3365 7031
Telephone:	(07) 3365 4417 (International: +61 7 3365 4417)
		AusCERT personnel answer during Queensland business hours
		which are GMT+10:00 (AEST).
		On call after hours for member emergencies.

Version: 2.6.3i
Charset: noconv
Comment: ftp://ftp.auscert.org.au/pub/auscert/AUSCERT_PGP.key