Click on Ok to close the sa Login Properties. Click on the Enabled button to enable the sa account. By default, the sa account will be disabled. (if you don’t want to provide a complex password for the sa account, you can uncheck this option. By default, the Enforce password policy is checked. Specify a complex password for the sa account. Right-click on the sa account and go to Login Properties. You can see the sa account is disabled when you install SQL Server using Windows Authentication mode.ģ. Connect to the SQL Server instance using SSMS and go to Security. After restarting the SQL Server, the authentication mode will be changed to SQL Server and Windows Authentication mode. Once you clicked on the Ok button, we will get the following screen:Īs discussed earlier, we need to restart the SQL Server service to make this change effective. Click on the radio button next to SQL Server and Windows Authentication mode, and click on OK to close the Server Properties page.ģ. On the Server Properties page, Click on Security. Right-click on the database instance, and go to Properties.Ģ. Login to the SQL server instance using SQL Server Management Studio. You need to remember that, the SQL Server service needs to restart to make this change effective.ġ. To Change the Authentication Mode:įollow the steps mentioned below to change the authentication mode from Windows Authentication to SQL Server and Windows Authentication. You need to change the authentication mode for SQL server from Windows Authentication Mode to SQL Server and Windows Authentication Mode to use the sa account. Sometimes, due to users/customers request, you may need to enable the sa account. Now close SQL Password Genius, restart SQL Server services, and you could login SQL Server with SA account ever locked.When you install the SQL Server using Windows Authentication mode, by default, the “ sa” account is disabled. When a new dialog pops up, input a new password in box for SA account and click "OK". Step 3: Reset password to unlock SA account.Īs soon as SA account appears in SQL Password Genius, just select it and click on Reset button. Master database file usual location: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data When it is found, open it in SQL Password Genius. If it is lost, SQL Password Genius will not help to reset SQL SA password. Step 2 : Search and import SQL master database into SQL Password Genius.Ĭlick " Open File" to search master database file in computer. Step 1: Install and run SQL Password Genius on computer.Īfter getting SQL Password Genius (trial version or full version), install and run it on Windows computer where SQL Server has been installed. Preparation: Stop SQL Server servivces at Start - All Programs - Microsoft SQL Server - Configuration Tools - SQL Server Configuration Manager. SQL Password Genius is one of them, enabling users to reset SA password after only three steps and no damage to SQL Server database. And this would not trouble most of SQL Server users, since so many SQL password recovery tools have been used for SQL user password reset or unlock SQL SA account. While this happens, you just need to find ways to reset SA password for logining SQL Server again. If SA account locked out is because of password forgot or lost, the case would be different from case 1. If it is locked out, just uncheck " Login is locked out" and click OK.Ĭase 2: Login SQL Server with SA Account by Unlocking SA Account with Tool Under Status option, you can see whether SA account is locked out of logon. Step 3: Select Status tab on the left pane of Login Properties. Step 2: Unfold Security Logins, and right-click on sa, then choose Properties. Step 1: Open SQL Server Management Studio Express and Connect with Windows Authentication. If not, just only to look for other ways. If it can work, this problem would be solved easily. While the fact is that SA account has been really locked out of logon in SQL Server settings, please try to login SQL Server with Windows Authentication. Case 2: Login SQL Server with SA Account by Unlocking SA Account with ToolĬase 1: Login SQL Server with Windows Authentication and Unlock SA Account.Case 1: Login SQL Server with Windows Authentication and Unlock SA Account.This article will introduce two cases, to explain why we cannot login SQL Server with SA account and how to unlock SA account to login SQL Server. SA account locked out and lost other users' sysadmin privileges? How to login SQL Server database? How to Login SQL Server after SA Account Locked Out
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |