Assigning 'System Administrator' Role

  1. On the computer where audited SQL Server instance is installed, navigate to Start All Programs Microsoft SQL Server SQL Server Management Studio.

  2. Connect to the SQL Server instance.
  3. In the left pane, expand the Security node. Right-click the Logins node and select New Login from the pop-up menu.

  4. Click Search next to Login Name and specify the user that you want to assign the sysadmin role to.

  5. Specify the Server roles tab and assign the sysadmin role to the new login.