Re: sa account locked out



J. Cairn (jcairn@xxxxxxxxxxxxx) writes:
I was just about to try the service account (thanks for the
suggestion) but it appears that the account is now unlocked. Not sure
if it automatically unlocks after a certain period if it is locked due
to multiple password failures(?)

Probably. The policies are taken from Windows, so the same policy applies
to SQL logins.



--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.



Relevant Pages

  • Re: Allow NULL or Define DEFAULT Value
    ... And by the way, a column could permit NULLs, but still have ... NULL to account for stateless persons. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Trying To find a Match in computed columns
    ... account in the list. ... about it the Excel Help, but in a hurry I could not make much out of it. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Login/Account Lock
    ... account is locked or not before the password is reset. ... locked the app should pop up a msg. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: FOR XML not working in a subquery
    ... error 'Incorrect syntax near xml' when I run it in SQL Server 2000. ... select a.accountid, (select street, city, state, zip from account b ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Querying Windows Active Directory from Sql Server 2000
    ... is added to the active directory and i've rights in active directory to ... account in SQL Server to run the query. ... domain account that has permissions in the AD. ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)