question

yaj avatar image
yaj asked

login failed for user 'sa' because the account is currently locked out. the system

Hi, After googling for the solution i founds somethng like this.... msg: 18486 Login failed for user ‘sa’ because the account is currently locked out. The system administrator can unlock it. Fix/Solution/Workaround: 1) Disable the policy on your system or on your domain level. However, this may not be the most appropriate option as it will adversely affect your security protection level. 2) If this is a one-time issue, enable “sa” login WITH changing password of “sa” login. ALTER LOGIN sa WITH PASSWORD = 'yourpass' UNLOCK ; GO 3) If this is a one-time issue, enable “sa” login WITHOUT changing password of “sa” login. ALTER LOGIN sa WITH CHECK_POLICY = OFF; ALTER LOGIN sa WITH CHECK_POLICY = ON; GO Well this works but gain after a certain amount of time whenever i try to connect the error keeps on poping up!!! Also i had not made any changes to server settings or neither is anyone trying to connect to my machine with sa's password. Additionally my machine is not even connected to the net where someone maybe trying to hack my machine. NOTE: I want sa login to work as it was previously working.
loginpasswordalter-logins
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.