November 25, 2008 at 8:11 pm
Hi,
In my company, we are using the Microsoft SQL Server 2000 Standard Edition for our applications. We configure our SQL Server in Mixed mode. While using the NT id, Windows taking care of user password security, Password Expiry & User Authentication. While we creating the SQL ID, how we configure the system for password expiry & User Authentication (Like 3 times mistakenly enter the password ID has to block / disable).
I've checked with the Books Online and they menttion only the tracking option. But we need to block/disable and/or to display the message
Could you please guide us the solution for this scenario.
--
Thanks and Regards,
Ramani.K
November 25, 2008 at 8:13 pm
SQL Server 2000 does not enforce any password policies like expiration or max invalid logins. If you want this you need to upgrade to 2005/2008.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 25, 2008 at 8:23 pm
Some of this (like password expiry) you could implement yourself. Other parts (like 3 fails & you're out) are more difficult.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply