Microsoft Security Bulletin (MS00-041)
Patch Available for "DTS Password" Vulnerability
Originally posted: June 14, 2000
Microsoft has released a patch that eliminates a security vulnerability in a component that ships with Microsoft(r) SQL Server 7.0. If the component is configured improperly, the vulnerability could allow passwords to be compromised.
Frequently asked questions regarding this vulnerability and the patch can be found at http://www.microsoft.com/technet/security/bulletin/fq00-041.asp
Data Transformation Service (DTS) packages in SQL Server 7.0 allow database administrators to create a package that will perform a particular database action at regular intervals. As part of the creation of a DTS package, the administrator provides the account name and password under which the action should be taken. However, the password can be retrieved by programmatically interrogating the package's Properties dialogue.
The vulnerability could only occur if several best practices have not been followed: - The creator of the DTS package chose to supply a username and password instead of using Windows Authentication. - The DTS package was created without restricting who can edit it. - The SQL Server administrator allowed Guest access to the SQL Server MSDB database.
Note: Additional security patches are available at the Microsoft Download Center
Please see the following references for more information related to this issue. - Frequently Asked Questions: Microsoft Security Bulletin MS00-041, http://www.microsoft.com/technet/security/bulletin/fq00-041.asp - Microsoft Knowledge Base article Q264880 discusses this issue and will be available soon. - Microsoft TechNet Security web site, http://www.microsoft.com/technet/security/default.asp
This is a fully supported patch. Information on contacting Microsoft Technical Support is available at http://support.microsoft.com/support/contact/default.asp.
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 June 14, 2000