Unlock server
Hit Win+R and type cmd in the dialogue box.Method 2: Unlock SQL Server Account Using Command Prompt Uncheck the box next to Login in the Login Properties window and hit OK. Press a right-click on SA account> go to Properties.ģ. Then open the Security folder in Object Explorer>open Logins folder. Initially, sign into SQL Server using Windows Authentication.Ģ.If mixed-mode authentication is enabled in SQL Server, you can easily log in with Windows Authentication to SQL Server Management Studio and unlock any SQL Server user account. Method 1: Unlocking the SA Account in Management Studio
#Unlock server manual#
There are various manual methods to Microsoft SQL server unlock SA account as given below: How to Unlock SQL Server SA Account When It’s Locked Out? Now, after knowing the reasons for its occurrence, move ahead to know the solutions to fix it. The reason for locking the SA account after multiple failed login attempts is because the SQL Server login is configured to use password enforcement policy and account lockout is enabled after a number of failed login attempts. Reasons for “SQL Server account locked out” error. Just follow us!!įirst of all, you should know the reason behind this error so that you can easily understand it. As it contains all the correct manual techniques to unlock Microsoft SQL Server User Accounts. You can take the help of this blog to fix this type of error. Then What to do? If you are not able to access SQL server then you might have to face this error “Login failed for user ‘sa’ because the account is currently locked out”. Unable to connect to SQL Server, the SQL Server SA Account When It’s Locked Out.