Gain Administrative Access to a SQL Instance

security-policies-icon

Info

If a user requires administrative access to a SQL instance they can easily gain administrative access as long as the following is true:

  • The user is an administrator on the Windows Server that host the SQL instance
  • SQL Server Management Studio is installed on the Windows Server
  • PSExec can be copied to the Windows Server

Steps

  • Download PSExec and copy it locally to the SQL Server
  • Login to the SQL server with an administrative account
  • Find the installation location of SQL Management Studio
    • Typically somewhere under C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\
    • The name of the .exe is SSMS.exe

Read More