In case if the SA account is disabled, and if you try to connect, you will get the error message “Login failed for user ‘sa’. Reason: The account is disabled. (Microsoft SQL Server, Error: 18470) “.
This article will guide you how to log into SQL Server if your SA account is disabled.
If the SA account is the only account that logs in to SQL Server under the System Admin, you will get an SQL Server login error and lose control of your database. Fortunately, there is still a way to activate the disabled SA account without having to reinstall SQL Server 2014, 2012, 2008 and 2005. With SQL Server Password Changer, you can log in to SQL Server if you SA account is disabled with reactivation of SA account with just a few mouse clicks.
How to activate SA account is disabled offline
You must first stop SQL Server on the SQL Server Configuration Manager. Then download and install the SQL Server Password Changer application on your local computer.
Download the SQL Server Password Changer application to your computer and install it here: Download SQL Server Password Changer
Open the SQL Server Password Changer program. Click the button Open File and on the screen will show the File Open dialog box. It requires you to select the master database (master.mdf) for SQL Server. SQL Server stores the login information in the master.mdf file, located in the directory:
C: Program Files Microsoft SQL Server MSSQL10 MSSQL DATA.
After selecting the master database file, the program will analyze the file format and extract all user databases from it. Select your SA account and then click the button Change Password. In the pop-up window displayed on the screen, enter the password you want to use and then click OK, got it.
The program will assign a new password that you have just created for SA account, and enable / enable SA account if it is disabled. Open SQL Server and you can connect to the SA account successfully from SQL Server Management Studio.
https://thuthuat.taimienphi.vn/cach-dang-nhap-sql-server-neu-tai-khoan-sa-bi-vo-hieu-hoa-31488n.aspx
So above Taimienphi.vn has shown you how to log into SQL Server if the SA account is disabled. If the SA account is disabled, you can use the SQL Server Password Changer to specify a new password and reactivate the SA account or follow the instructions. SA password reset is lost on SQL Server to be able to login to your admin account.
.
