Re: mssql password file

From: Dan Guzman (danguzman@nospam-earthlink.net)
Date: 10/25/02 

From: "Dan Guzman" <danguzman@nospam-earthlink.net>
Date: Fri, 25 Oct 2002 08:15:29 -0500

To add to BP's response, you can also use Windows authentication. This
is more secure because you can set password policies such as minimum
length, expiration and reuse. 

--
Hope this helps.
Dan Guzman
SQL Server MVP
-----------------------
SQL FAQ links (courtesy  Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------
"BRaTaX CK" <bratax@pandora.be> wrote in message
news:lY6u9.177527$8o4.28490@afrodite.telenet-ops.be...
> Thanks a lot BP Margolin.
> Now that I know about the location of the file, and about the fact
that the
> passwrds are encrypted, I feel a lot safer in using mssql.
>
> Cya,
>
> bratax
>
> "BP Margolin" <bpmargo@attglobal.net> schreef in bericht
> news:#Sq5qJ5eCHA.2532@tkmsftngp09...
> > 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: mssql lacks
    ... > mssql databases instead of access. ... > queries in programs just to enable users to choose between databases. ... recall that SQL Server has its origins at Sybase, ...
    (comp.databases.ms-sqlserver)
  • Re: Newbie, True and False
    ... All commands, Insert, Update etc work fine with MySql, but not with MsSql. ... First time working on an SQL database. ... will need to relearn when using sql server. ...
    (microsoft.public.sqlserver.clients)
  • Re: Upsizing To SQL Server
    ... to medium size databases to SQL Server? ... Access DB to MSSQL Server. ... changed after window updates), or installing new IE - silent refusal ... design queries - no bother as I write queries. ...
    (comp.databases.ms-access)
  • Re: oracle pl/sql -> sql server
    ... given that MSSQL 2000 is ... > already 5 years or so old, it would certainly worth be worth ... aimed at it "taking on Oracle" I'd ... will take an Oracle app and port to SQL Server. ...
    (comp.databases.ms-sqlserver)
  • RE: Invalid cursor state when using PRINT in MSSQL
    ... Invalid cursor state when using PRINT in MSSQL ... as you get the correct message back 'Changed database context to 'Database' ... I'm an Oracle not a Sybase or SQL Server person, but I believe that you can ...
    (perl.dbi.users)