Securing SQL Server: DBAs Defending the Database

© Peter A. Carter 2018

Peter A. CarterSecuring SQL Serverhttps://doi.org/10.1007/978-1-4842-4161-5_7

7. Implementing Service Accounts for Security

Peter A. Carter¹ 

(1)

London, UK

 

A Service Account is simply an account that is used as the security context that Windows uses to run a service. Each SQL Server Service needs to be configured with a Service Account, which will be granted the appropriate permissions to run the service. In this chapter, we will discuss the general considerations for service accounts. We will then examine how service accounts can be exploited before, finally, discussing an appropriate service account strategy.

Service Account Types

SQL Server 2017 supports the following types of account as Service Accounts:

• Local User

• Domain User ...