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: How can I update a column value to be the column value of a table in another database ?
    ... ALTER TABLE Customer ... ADD PRIMARY KEY (Account) ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.programming)
  • 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)