Blank sa password on Microsoft SQL Server

mssql-no-sapassword (1459) The risk level is classified as HighHigh Risk

Description:

Microsoft SQL Server provides weaker than expected security. The default installation of Microsoft SQL Server includes no password with the sa account. If the sa account is left without password protection, any user can act as administrator on the SQL server. An authorized user who has gained access to the sa account can also gain access to admin privileges on the Windows NT Server by using commands, such as "xp_cmdshell".

This vulnerability is exploited by the Cblade worm and the SQL Spida worm. See References for more information.


Consequences:

Gain Access

Remedy:

Establish a password for the sa login that is difficult to guess. The password can be changed using the stored procedure "sp_password".

References:

Platforms Affected:

  • Microsoft SQL Server
  • Microsoft Windows 2000
  • Microsoft Windows 2003 Server
  • Microsoft Windows NT 4.0
  • Microsoft Windows XP

Reported:

Dec 18, 1998

The information within this database may change without notice. Use of this information constitutes acceptance for use in an AS IS condition. There are NO warranties, implied or otherwise, with regard to this information or its use. Any use of this information is at the user's risk. In no event shall the author/distributor (IBM Internet Security Systems X-Force) be held liable for any damages whatsoever arising out of or in connection with the use or spread of this information.

For corrections or additions please email ignore thisxforceignore this@ignore thisus.ignore thisibm.comignore this

Return to the main page