Login Error

  • 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.

  • 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

  • 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..

  • 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