Re: expire sql server 2000 passwords

From: Steve Thompson (stevethompson@nomail.please)
Date: 11/11/02 

From: "Steve Thompson" <stevethompson@nomail.please>
Date: Mon, 11 Nov 2002 15:58:21 -0500

"david-hg" <dgordon@fftw.com> wrote in message
news:e4a201c289ba$fe57bb40$36ef2ecf@tkmsftngxa12...
> Can and expiration date be assigned to sql server
> passwords ?

No, not natively by SQL Server, consider using Windows authentication where
you can use password expiration.

Steve

Relevant Pages

  • Re: Locking down database accounts
    ... Windows Authentication rather than SQL Server user accounts and passwords. ...
    (microsoft.public.sqlserver.security)
  • Re: Convert SQL logins to Windows authentication
    ... SQL Server doesn't store passwords for Windows authenticated accounts since ... > SQL accounts...is there a known script/utility that can transfer the SQL> login passwords to the new corresponding Windows Authentication passwords? ...
    (microsoft.public.sqlserver.security)
  • RE: Secure Logins for SQL Server 2000 on Novell Netowrk
    ... all the traffic to and from the client ... Is there a way I can use Windows authentication on the SQL server? ... you have to duplicate usernames and passwords on the machines. ...
    (microsoft.public.sqlserver.security)
  • Re: Convert SQL logins to Windows authentication
    ... > SQL Server doesn't store passwords for Windows authenticated accounts ... > grant the existing Windows accounts access to SQL Server, ... >> login passwords to the new corresponding Windows Authentication ...
    (microsoft.public.sqlserver.security)
  • [NT] SQL Server Installation Process May Leave Passwords on System
    ... service pack for SQL Server 7.0 or SQL Server 2000, ... without having to actually perform an installation. ... to SQL Server 7.0 Service Pack 4, the passwords were stored in clear text. ... information in the setup.iss and log files would not allow any access. ...
    (Securiteam)