Re: Password History in SQL Server

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 11/14/05

  • Next message: Andrew J. Kelly: "Re: Need assisance with SQL2000 error." 
    Date: Mon, 14 Nov 2005 07:14:38 -0600

    > SQL Server 7.0, 2000 and 2005 do not keep password history.

    Mike, I believe SQL 2005 indirectly provides a password history policy under
    Windows 2003 when with the CHECK_POLICY option is ON. SQL Server calls the
    Windows NetValidatePasswordPolicy API to enforce local server password
    policies. 

    -- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message 
news:uJZeRYw5FHA.2984@TK2MSFTNGP14.phx.gbl...
> Hi
>
> SQL Server 7.0, 2000 and 2005 do not keep password history.
>
> If you have a need for this, use NT Integrated Security and then that is 
> done at AD level.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "SRV" <SRV@discussions.microsoft.com> wrote in message 
> news:CB0A689E-7AB6-47FA-AADD-8F774F390974@microsoft.com...
>>I know that there is a rule in SQL Server password naming that last n 
>>number
>> of password cannot be used. Can anyone tell me how much is this n?
>>
>> Thanks in advance
>>
>
>
  • Next message: Andrew J. Kelly: "Re: Need assisance with SQL2000 error."

    Relevant Pages

    • Re: HasChanges returns false for one row, true when more than one
      ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... "Mike G Burton" wrote in message ... dataset has a single row, but True if the dataset has multiple rows. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: simple collaboration enable ?
      ... Listen to Mike, ignore the monkey trying to figure ... > throttling on more than 5 concurrent connections). ... > c) not restricted to WSS databases only ... > SQL Server 2K) ...
      (microsoft.public.sharepoint.windowsservices)
    • RE: VS 2005 Beta 1 and SQL Server 2005
      ... Hey Mike ... To use the April CTP of SQL Server 2005 you would have to also use the ... correct build of the .NET Framework which would be the official April CTP. ...
      (microsoft.public.dotnet.languages.csharp)
    • Re: Database events - notify an application
      ... of sql server was an extended stored procedure. ... Mike ... > You could look at Notification Services: ...
      (microsoft.public.sqlserver.programming)
    • Re: Alex
      ... I believe the XML data type ... If you are to store the data in the database, ... I would agree with Mike that the xml type is the best ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
      (comp.databases.ms-sqlserver)