How do I connect to SQL Server if I am locked out?
Right-click your server name, and then click Restart. Make sure to start SQL Server Agent again if you stopped it before starting SQL Server in single-user mode.
Could not connect to SQL Server using Windows Authentication?
Go to the Properties of the selected server (from the right-click menu). Now go to the Security page and under Server authentication choose the option SQL Server and Window Authentication mode. Now expand Security > Logins and right-click the server name, and select Properties. ... Click OK and restart the SQL server.
Why is SQL account locked out?
If a SQL Server login is configured to use password policy enforcement and your organization uses account lockout after a certain number of failed logins, you can end up locking out a SQL Server login via the same scenario. This can result in the account being locked out.
How do I log into SQL Server authentication?
In SQL Server Management Studio, right-click Security > Logins; then select New Login. Enter the username (for example, papercut). Change the Server Authentication to SQL Server and Windows Authentication mode. Enter the user's password.