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

Configure SSL on a SQL Failover Cluster

Pre-Requisites

  • Have an SSL cert where the Common Name (CN) of the cert matches the name of the SQL instance that needs to have SSL enabled. A wildcard cert will also work.
  • Ability to modify the registry on each of the cluster nodes

Step 1 of 2 (Import the Certificate into Windows)

  • Hold down the Windows key and push R to open a run window
  • Type mmc.exe and hit enter
  • Click the File menu and select Add/Remove Snap-in…
  • Select Certificates from the left column and click Add >
  • Select Computer Account and click Next when prompted

Screenshot1

  • Click Finish
  • Click Ok

Read More