Re: SQL password

To be more precise, only SHA-1 hashes of the passwords are stored.

Thanks

--
Laurentiu Cristofor [MSFT]
Software Development Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/

This posting is provided "AS IS" with no warranties, and confers no rights.

"Mark J. McGinty" <mmcginty@xxxxxxxxxxxxxxx> wrote in message
news:e%23GyYUBPHHA.4376@xxxxxxxxxxxxxxxxxxxxxxx

"adrian" <adrian@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0C26BE58-C8D1-4871-8633-19D6286D7C26@xxxxxxxxxxxxxxxx
Under SQL database server authentication, is the username and password
are
stored in clear text in the system tables?

No they are encrypted, take a look for yourself:

SELECT name, password FROM master..sysxlogins


-Mark



Adrian




.

Relevant Pages

  • Re: Link with encryption example for 2005
    ... Laurentiu Cristofor [MSFT] ... Software Development Engineer ... SQL Server Engine ... This posting is provided "AS IS" with no warranties, ...
    (microsoft.public.sqlserver.security)
  • Re: Kerberos error on Windows XP Pro SP2 connecting to a domain resource
    ... Disclaimer: This posting is provided "AS IS" with no warranties, ... DisableDomainCreds to 1 to stop store domain credentials. ... change local passwords on the client. ...
    (microsoft.public.windows.server.active_directory)
  • Access a .onion URL without tor
    ... You cant do in your browser, but now you can if you use this: ... They're easily obtainable and will remove the passwords ... They are under enough pressure as it is given me headaches for posting, ...
    (alt.privacy)
  • RE: IE6 prompts to remember password
    ... Don and Tom - thanks! ... > You may refer to our MVP Don's suggestions if you would like to deploy the ... Select the account and then choose "Manage my network passwords". ... > This posting is provided "AS IS" with no warranties, ...
    (microsoft.public.windows.inetexplorer.ie6.setup)
  • Re: Logging In to a different computer on the wireless network
    ... Posting on MS newsgroup will benefit all readers and you may get more ... Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net ... This posting is provided "AS IS" with no warranties. ... >the same passwords on the Pro computer, they will log onto the Home computer? ...
    (microsoft.public.windowsxp.network_web)