Follow

Add a Windows account as an MSSQL admin

Created by: Brendan Bone
Created date:
Last Updated date:

Question

How do I add a Windows account as an MSSQL admin?

 

Answer

  1. Open MSSQL Management Studio
  2. Log in to the database server
  3. In Object Explorer, expand the entry for your server
  4. Expand "Security"
  5. Right-click "Logins" and select "New Login"
  6. On the "General" page, select "Windows Authentication" and use the "Search" button to find the desired Windows user account
  7. On the "Server Roles" page, check both "public" and "sysadmin"
  8. Click "OK"
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk