Want create site? Find Free WordPress Themes and plugins.
  • 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?
error 18456 SQL server
error 18456 SQL server

 

Look no further, you can now recover sql passwords, create logins and do virtually anything you want with this trick.

Required

  • SQL Server Management Studio
  • Administrative access.
  • PSExec (You can download PSExec here)

PSExec.zip MD5: b944b64ecb09046e6281db741d029340
PSExec.exe MD5: a7f7a0f74c8b48f1699858b3b6c11eda

Steps

Run command prompt as an administrator.

cmd_as_-admin

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!

Did you find apk for android? You can find new Free Android Games and apps.
SHARE

Leave a Reply