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
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
- 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.
Affected Software Versions
- Microsoft SQL Server 7.0
Note: Additional security patches are available at the Microsoft
Please see the following references for more information related to
- Frequently Asked Questions: Microsoft Security Bulletin MS00-041,
- Microsoft Knowledge Base article Q264880 discusses this issue
and will be available soon.
- Microsoft TechNet Security web site,
Obtaining Support on this Issue
This is a fully supported patch. Information on contacting Microsoft
Technical Support is available at
- June 14, 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 June 14, 2000