Security hole in SQL Server lets attackers take over

June 13, 2001, 09:47 AM —  IDG News Service — 

A security flaw in Microsoft Corp.'s SQL Server 7.0 and SQL Server 2000 Gold can allow an attacker to take control of a targeted server, the company said in a security bulletin late Tuesday night. Microsoft issued a patch for the flaw at the same time it released the bulletin.

A hitch in the way database connections are handled by the SQL (Structured Query Language) server could allow an attacker to hijack an administrator's connection, thus gaining administrator privileges, the company said, but added that the vulnerability only exists in servers configured for Mixed Mode authentication, a configuration type Microsoft recommends against, and can only be exploited by users who already have access to the server.

When a user ends a database session with a SQL server, the connection that has just ended is temporarily cached. However, using a special kind of server query, an attacker could exploit this flaw to restart an administrator's connection, thus gaining the administrator's access privileges, according to the bulletin. If this were to occur, the attacker could make any changes to the database, including adding, changing or deleting data, and could run code of the attacker's choice on the server, Microsoft said.

The bug is mitigated, however, due to the necessity that the server be configured for Mixed Mode authentication in order for the flaw to be usable, the company said. Mixed Mode authentication is a process by which the server attempts to authorize a user through Windows methods, but failing that uses SQL. This option is typically used on SQL servers hosted on Windows 95 and 98 systems and the company warns against it, Microsoft said.

Additionally, the bug is mitigated because the attacker would already have to be authorized by the server in order to restart a terminated connection.

The security bulletin and patch can be found at http://www.microsoft.com/technet/security/bulletin/MS01-032.asp

IDG News Service

Sign up for ITworld's Daily newsletter
Follow ITworld on Twitter @IT_world

I like it!
Post a comment
The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
peer-to-peer

jfruh
Apple syncing patent can't come soon enough

pasmith
New Twitter features borrow from 3rd party clients

Esther Schindler
Open Source Changes the Software Acquisition Process

mikelgan
How to set up continuous podcast play on the new iTunes

David Strom
Five important Windows 7 mobility features

sjvn
Guard your Wi-Fi for your own sake                        

Sandra Henry-Stocker
Grepping on Whole Words

 

Sidekick: The Good News & the Bad News
Either way you look at it Microsoft Data Center management did not follow standards or best practices in this failure. In which case it makes me wonder more about the outsourcing of corporate data much less personal data.
- mburton325

Join the conversation here

The Daily Tip

The Daily TipQuick, practical advice for IT pros. Made fresh daily.

Hot tips:

Want to cash in on your IT savvy? Send your tip to tips@itworld.com. If we post it, we'll send you a $25 Amazon e-gift card.

Newsletters

Subscribe to ITWORLD TODAY and receive the latest IT news and analysis.

I would like to receive offers via email from ITworld partners.
By clicking submit you agree to the terms and conditions outlined in ITworld's privacy policy.
Featured Sponsor

AISO founders envisioned a Web hosting company that was environmentally friendly. While the company employed energy-efficient innovations like solar panels, its infrastructure produced unacceptable power and cooling requirements. Find out how AISO leveraged AMD technology to overcome their challenge in this case study white paper.

In this whitepaper, Scalar explores the opportunity to change the landscape with respect to mission critical databases built around Oracle. Leveraging technologies such as Linux, high-end commodity processing power and Oracle RAC technology to architect, design, build and maintain database infrastructure that delivers maximum availability, reliability and performance at a fraction of traditional cost.

On a typical day, weather.com, the Web site for The Weather Channel in Atlanta, serves up between 15 million and 20 million page views. But in September 2004, when back-to-back hurricanes ransacked Florida, the peak traffic on one day more than tripled: over 70 million page views by more than 7 million unique visitors. Read the full success story now.

Marketplace