![]() ![]() In Object Explorer, open Security folder, open Logins folder. Login into SQL Server using Windows Authentication.If the mixed mode authentication is enabled in SQL Server, you can log into SQL Server Management Studio with Windows Authentication, and then unlock any SQL Server user account easily. ![]() Option 1: Unlock SA Account in Management Studio The methods work with all versions including SQL Server 2014. In this article we'll show you 2 methods to unlock SQL Server SA account when it is locked out or disabled. When password policy is checked for a SQL Server login account, your account will get locked out after too many failed login attempts. Can't connect to SQL Server due to SA account locked out? If the SA account is locked down you may receive the error message "Login failed for user 'sa' because the account is currently locked out. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |