O'Reilly logo

Securing SQL Server: DBAs Defending the Database by Peter A. Carter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Peter A. Carter 2016

Peter A. Carter, Securing SQL Server, 10.1007/978-1-4842-2265-2_7

7. Implementing Service Accounts for Security

Peter A. Carter

(1)Botley, 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 is granted the appropriate permissions to run the service. This chapter discusses the general considerations for service accounts. You then examine how service accounts can be exploited. Finally, I discuss the appropriate service account strategy.

Service Account Types

SQL Server 2016 supports the following types of account as service accounts:

  • Local user

  • Domain user

  • Built-in accounts

  • Managed service accounts ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required