April 29, 2010 at 11:38 pm
Hi Gurus,
I have a few questions this time
1.When i connected to server i gave wrong password and ticked the save password check box and entered correct one and then i checked the box again but I am getting the eror wrong password.SQL server is still having the old password only..Any idea on this?
2.Is there any way to get alert if any of the logins in server enter wrong password for 3 consecutive times?
Thanks in advance.
April 29, 2010 at 11:43 pm
Are you using SQL authentication?
then enable the password policy for that account,(but remove the tick from "user must change password..... and password expiration....")
and also see if its locked under status.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 30, 2010 at 1:07 am
Thanks for the reply Henrico..
Enabling the password policy means that must meet windows password policy right?
For this user its not enabled and that makes me more annoying..
April 30, 2010 at 1:15 am
and that makes me more annoying.
you said it 😀
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply