SQL Server 7.0 SP1 and SP2 Expose Admin Psw

SQL Server 7.0 SP1 and SP2 Expose Admin Psw
Reported May 30 by
Gordon Newman of PeopleSoft

Microsoft Windows Media Encoder 4.0
  • Microsoft Windows Media Encoder 4.1

    According to Microsoft"s bulletin, "When SQL Server 7.0 Service Packs 1 or 2 are installed on a machine that is configured to perform authentication using Mixed Mode, the password for the SQL Server standard security System Administrator (sa) account is recorded in plaintext in the file \%TEMP%\sqlsp.log. The default permissions on the file would allow any user to read it who could log onto the server interactively. The password is only recorded if Mixed Mode is used, and even then, only if the adminstrator chose to use SQL Server Authentication when installing the service pack."


    Microsoft had released a patch to correct the matter. See Q263968 for more details.

    Discovered and reported by Gordon Newman of PeopleSoft

    Hide comments


    • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

    Plain text

    • No HTML tags allowed.
    • Web page addresses and e-mail addresses turn into links automatically.
    • Lines and paragraphs break automatically.