You tried to login a user and have this message / error:
Solution:
Step 1: Login to sql server as Administrator
Step 2: Security >> Logins >> right click the user >> click Properties >> select Status page
Uncheck Login is locked out. and click Ok.
It will ask for "Reset password for the login while unlocking".
We need to go to General page and give password and Confirm password.
Click Ok.
The account is currently locked out.
Solution:Step 1: Login to sql server as Administrator
Step 2: Security >> Logins >> right click the user >> click Properties >> select Status page
Uncheck Login is locked out. and click Ok.
It will ask for "Reset password for the login while unlocking".
We need to go to General page and give password and Confirm password.
Click Ok.
No comments:
Post a Comment