From the course: Microsoft SQL Server 2016: Installation and Administration

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Understanding service accounts

Understanding service accounts - SQL Server Tutorial

From the course: Microsoft SQL Server 2016: Installation and Administration

Start my 1-month free trial

Understanding service accounts

- [Instructor] The sequel server relies on many services for its operations. In each service has an associated security account that provides permissions on the system for which it is installed. Understanding these service account options is critical to operation and security of your sequel server instance. You configure these accounts during setup but you can also modify them later using the sequel configuration tools. One thing that you can do with your login accounts for these particular services is to choose the same account for all services, even though that's not a recommendation. Really you should have a separate account for each service and that way what you can do is you can configure specific permissions for each service separately rather than the need to worry about configuring specific settings for one account that applies to multiple services. I'm actually going to recommend that you use the default sequel assigned accounts. To get an understanding of the sequel server…

Contents