Microsoft SQL Server Administrator Cached Connection Vulnerability



Date Discovered

June 12, 2001


Due to a flaw in the handling of specially crafted ad hoc queries, it is possible for a logged in user to utilize the ad hoc query in such a way that the use of the system administrator's cached connection would be invoked rather than that of the user. This would enable the user to access the database with administrative privileges.

Technologies Affected

  • Microsoft SQL Server 2000
  • Microsoft SQL Server 2000 SP1
  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 7.0 SP1
  • Microsoft SQL Server 7.0 SP2
  • Microsoft SQL Server 7.0 SP3

Microsoft has released a patch which rectifies this issue:



Published in a Microsoft Security Bulletin MS01-032 on June 12, 2001.

© 1995- Symantec Corporation

Permission to redistribute this alert electronically is granted as long as it is not edited in any way unless authorized by Symantec Security Response. Reprinting the whole or part of this alert in any medium other than electronically requires permission from


The information in the advisory is believed to be accurate at the time of publishing based on currently available information. Use of the information constitutes acceptance for use in an AS IS condition. There are no warranties with regard to this information. Neither the author nor the publisher accepts any liability for any direct, indirect, or consequential loss or damage arising from use of, or reliance on, this information.

Symantec, Symantec products, Symantec Security Response, and are registered trademarks of Symantec Corp. and/or affiliated companies in the United States and other countries. All other registered and unregistered trademarks represented in this document are the sole property of their respective companies/owners.