Re: mssql password file

From: BP Margolin (bpmargo@attglobal.net)
Date: 10/24/02 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Thu, 24 Oct 2002 15:24:10 -0400

bratax,

SQL Server passwords are stored in the syslogins system table in the master
database. The passwords are encrypted.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"BRaTaX CK" <bratax@pandora.be> wrote in message
news:N2Vt9.176708$8o4.28295@afrodite.telenet-ops.be...
> Heya
>
> I got a little (stupid) question..
> I'm new to mssql, and I was wondering where the password file is located
(I
> want to try some things out to learn more about the program).
> I'm using mssql7 on winnt5 (iis).
>
> Thanks a lot in advance,
>
> bratax
>
>

Relevant Pages

  • Re: Pathname to access and usernames in shortcut
    ... >> network drive (for maintenance reasons initially, ... >> using usernames but no passwords. ... change their passwords within the access database (they won't know how ... >> gets the current username from the system and then calls access (via the ...
    (microsoft.public.access.security)
  • Re: security issues
    ... It was obviously never meant to be; multiple defences against it being ... The Ubuntu installer uses a framework called debconf to do ... when you're asking for passwords ... you take a lot of care to clean them out of the database ...
    (Ubuntu)
  • Re: Basic security questions
    ... > question be able to open the database in the appropriate view. ... > Isn't there any way to just set up users with passwords that are saved ... How would I specify a relative path for the ... The path to the workgroup file is defined in a shortcut in the format: ...
    (microsoft.public.access.security)
  • Re: Windows service
    ... if you know all of this why you recommend to Rotsey not to use Domain Security? ... It's easily cracked, doesn't have any metering on it to prevent brute force attacks, transmits the credentials to the database in plain-text, and doesn't integrate at all into the standard security infrastructure already being used by the organization. ... There's no default monitoring of the invalid password attempts, no automatic account lock-out, etc. There's a ton of documentation on this found on the web. ... It's one less set of passwords to remember, less configuration in the long run, fewer plain-text passwords floating around in email & config files. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Security Problem with Access 2000
    ... has the user names, personal ID's, and passwords. ... I backed up the database on a CD. ... If you have the report with the user information, then you should be able to open the database with that information. ... Make sure that you're using the correct workgroup file (the wizard normally creates a desktop shortcut; ...
    (microsoft.public.access.security)