Follow

How to add a service account to Microsoft SQL Server

Created by: Tod Ewasko
Created date:
Last Updated date:

Add service account to SQL

  • Open SQL Management Studio using SQL Authentication SysAdmin (SA) Account.
  • Open up Security then Right Click on Logins, choose “New Login”
  • On the new login screen choose “Search”
  • On the search screen ensure you are searching the Entire Directory, type in the user name, choose Check Names, then choose ok.
  • After you click OK, Click Server Roles and check “sysadmin”
  • Click OK and you are done
  • Test out by logging into SQL Management studio using Windows Authentication.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk