We all know that “sa” is the account with highest administrative access, which is Sysadmin access. Sometimes we all come in a situation where we lose our access to the SQL instance. In order to manage the SQL databases and perform administrative activities we need to get the access back. In some situations the server loses their domain connectivity and due to this, we lose our administrative access which was associated with Windows logon. So, in those situations we try to crack the password of “sa” account. Here, I am going to tell you how to crack the password or how to get access even when we do not know the password for “sa” account.

1. Login to the server with administrator account.
2. Go to SQL Server Configuration Manager.
3. You will see SQL services running on that server. Right click on the SQL Server service and go to properties.

4. In properties, go to the Startup Parameters and add “-m” to start the SQL Server in Single user mode.

5. Stop the SQL Server and Start it. Now SQL server will start in Singe user mode.

6. Now open the SQL Server Management Studio as administrator and now you can connect to the SQL Server instance without any issue.

Now go ahead and reset the password for “sa” account or create a login for yourself. Once again go to the properties and remove that -m from parameter and start SQL server normally (or in multiuser mode). Consequently login with newly created login and perform your activity.

Check All Related Articles