- Have you forgotten your SA password?
- Have you tried to recover SQL passwords but are having errors?
- Are you trying to create a sysadmin account but you don’t have the privileges?
- Are you experiencing Microsoft SQL Server, Error: 18456 when you try to log in to your SQL Server?
Look no further, you can now recover sql passwords, create logins and do virtually anything you want with this trick.
- SQL Server Management Studio
- Administrative access.
- PSExec (You can download PSExec here)
PSExec.zip MD5: b944b64ecb09046e6281db741d029340
PSExec.exe MD5: a7f7a0f74c8b48f1699858b3b6c11eda
Run command prompt as an administrator.
Run SQL Server Management Studio (ssms.exe) using PSExec. Use this command PsExec.exe -s -i “file path of SSMS” in my case is “C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Ssms.exe”
psexec -s -i “C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Ssms.exe”
This makes SQL Server Management Studio open with SYSTEM user rights (NTAUTHORITY\SYSTEM) which by default has SYSADMIN rights to any SQL database.
Once you login, you can now create any sysadmin login to the database, change the sa password, and do any other administrative tasks. It is advisable to create a new sysadmin user so that you can use it for future logins.
Did it work for you? Then, ECHO IT!