K-027: Microsoft SQL Server and MSDE Malicious Query Vulnerability

PROBLEM:       A security vulnerability has been identified in Microsoft SQL
               Server 7.0 and Microsoft Data Engine (MSDE) 1.0.
PLATFORM:      All platforms running SQL Server 7.0 and MSDE 1.0.
DAMAGE:        The remote author of a malicious SQL query may take
               unauthorized actions on a SQL Server or MSDE database or on the
               underlying system that was hosting the SQL Server or MSDE
               database.
SOLUTION:      Apply the patch given in the Security Bulletin below or else
               apply register settings as indicated in Frequently Asked
               Questions page given in the bulletin.
VULNERABILITY  Risk is low. The attacker must have the right to submit queries
ASSESSMENT:    to the SQL Server or MSDE via ODBE, OLE DB, or DB-Library and
               be logged on using the SQL Server Security.


[ Start Microsoft Bulletin ]

Microsoft Security Bulletin (MS00-014)
Patch Available for "SQL Query Abuse" Vulnerability
Originally Posted: March 08, 2000

Summary
Microsoft has released a patch that eliminates a security vulnerability in
Microsoft® SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0. The
vulnerability could allow the remote author of a malicious SQL query to
take unauthorized actions on a SQL Server or MSDE database or on the
underlying system that was hosting the SQL Server or MSDE database.
Frequently asked questions regarding this vulnerability and the patch can
be found at
http://www.microsoft.com/technet/security/bulletin/fq00-014.asp

Issue
Microsoft SQL Server 7.0 and MSDE 1.0 perform incomplete argument
validation on certain classes of remotely submitted SQL statements. If a
user is able to submit a particular form of a SQL Select statement to SQL
Server or MSDE, it is possible to take actions on the SQL data base or, if
the SQL Server or MDSE is operating in an account with elevated privileges
on the underlying system, on the underlying operating system itself.
In order to exploit this vulnerability, a user would have to have the
right to submit queries to the SQL Server or MSDE via ODBC, OLE DB, or
DB-Library and be logged on using SQL Server Security. The user would not
require any special privileges beyond the right to submit SQL queries.

Affected Software Versions
  Microsoft SQL Server Version 7.0 and Microsoft Data Engine (MSDE) 1.0.

Patch Availability
  http://www.microsoft.com/downloads/release.asp?ReleaseID=19132
Note: Additional security patches are available at the Microsoft Download
Center

More Information
Please see the following references for more information related to this
issue.
  Frequently Asked Questions: Microsoft Security Bulletin MS00-014,
  http://www.microsoft.com/technet/security/bulletin/fq00-014.asp.
  As soon as more information on this topic is available, it will be
  posted here.
  Microsoft TechNet Security web site,
  http://www.microsoft.com/technet/security/default.asp.

Obtaining Support on this Issue
This is a fully supported patch. Information on contacting Microsoft
Technical Support is available at
http://support.microsoft.com/support/contact/default.asp.

Acknowledgments
Microsoft thanks Sven Hammesfahr http://www.itrain.de for reporting the
SQL Query Abuse vulnerability to us and working with us to protect
customers..

Revisions
  March 08, 2000: Bulletin Created.
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.

Last updated March 8, 2000
® 2000 Microsoft Corporation. All rights reserved. Terms of use.


[ End Microsoft Bulletin ]

    Voice:          +1 925-422-8193 (7 x 24)
    FAX:            +1 925-423-8002
    STU-III:        +1 925-423-2604
    E-mail:          ciac@llnl.gov
    World Wide Web:  http://www.ciac.org/
                     http://ciac.llnl.gov
                     (same machine -- either one will work)
    Anonymous FTP:   ftp.ciac.org
                     ciac.llnl.gov
                     (same machine -- either one will work)