dslreports logo
site
 
    All Forums Hot Topics Gallery
spc

spacer




how-to block ads


Search Topic:
uniqs
392
share rss forum feed


Chiyo
Save Me Konata-Chan
Premium
join:2003-02-20
Charlotte, NC
kudos:1

[Other] Do MS SQL accounts unlock like AD?

This may be a silly question. If User XYZ fails to log in too many times their account locks but does it auto-unlock like Active Directory account does?

Thanks.
--
That was the wild boar.... Moo!
My podcast: The Banzai Beat »www.banzaibeat.com



psafux
Premium,VIP
join:2005-11-10
kudos:2

No, it won't auto unlock. SQL Admin (sa or someone with similar privilege) will have to unlock it.


aguen
Premium
join:2003-07-16
Grants Pass, OR
kudos:2

said by psafux:

No, it won't auto unlock. SQL Admin (sa or someone with similar privilege) will have to unlock it.

waiting for the other shoe to drop.


psafux
Premium,VIP
join:2005-11-10
kudos:2

What, like "It *was* the SA account" ?

Never



Chiyo
Save Me Konata-Chan
Premium
join:2003-02-20
Charlotte, NC
kudos:1
reply to Chiyo

Was curious because this happened over a weekend where a user called in to state their ERP log in was locked and I didn't want ot bother an on call person. Of course I did but just wanted to make sure I knew for the future.

I tried Googling the question but nobody ever had a simple "Yes or No" answer.

Thanks for your help!
--
That was the wild boar.... Moo!
My podcast: The Banzai Beat »www.banzaibeat.com