Configure Windows Service Accounts and Permissions • • 29 minutes to read • Contributors • • • • • • In this article THIS TOPIC APPLIES TO: SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse For content related to previous versions of SQL Server, see. Each service in SQL Server represents a process or a set of processes to manage authentication of SQL Server operations with Windows.

'Local System account. The name of this account is NT AUTHORITY System. It is a powerful account that has unrestricted access to all local system resources. It is a member of the Windows Administrators group on the local computer, and is therefore a member of the SQL Server sysadmin fixed server role '. The NT AUTHORITY SYSTEM account is also granted a SQL Server login. The NT AUTHORITY SYSTEM account is provisioned in the SYSADMIN fixed server role. Do not delete this account or remove it from the SYSADMIN fixed server role. The NT AUTHORITY SYSTEM account is used by Microsoft Update and by Microsoft SMS to apply service packs and hotfixes to a SQL Server 2005 installation. The NT AUTHORITY SYSTEM account is also used by the SQL Writer Service. This is no longer the case in 2012.

For SQL Server 2012 and above, as What's New in SQL Server Installation states: BUILTIN administrators and Local System (NT AUTHORITY SYSTEM) are not automatically. For SQL Server 2012 and above, as What's New in SQL Server Installation states: BUILTIN administrators and Local System (NT AUTHORITY SYSTEM) are not.

This topic describes the default configuration of services in this release of SQL Server, and configuration options for SQL Server services that you can set during and after SQL Server installation. This topic helps advanced users understand the details of the service accounts. Most services and their properties can be configured by using SQL Server Configuration Manager. Here are the paths to the last four versions when Windows in installed on the C drive. SQL Server 2016 C: Windows SysWOW64 SQLServerManager13.msc SQL Server 2014 C: Windows SysWOW64 SQLServerManager12.msc SQL Server 2012 C: Windows SysWOW64 SQLServerManager11.msc SQL Server 2008 C: Windows SysWOW64 SQLServerManager10.msc Services Installed by SQL Server Depending on the components that you decide to install, SQL Server Setup installs the following services: • SQL Server Database Services - The service for the SQL Server relational Database Engine.

The executable file is MSSQL Binn sqlservr.exe. • SQL Server Agent - Executes jobs, monitors SQL Server, fires alerts, and enables automation of some administrative tasks. The SQL Server Agent service is present but disabled on instances of SQL Server Express. The executable file is MSSQL Binn sqlagent.exe. • Analysis Services - Provides online analytical processing (OLAP) and data mining functionality for business intelligence applications. Dazzle Digital Video Creator 80 Driver Windows Xp.

The executable file is OLAP Bin msmdsrv.exe. • Reporting Services - Manages, executes, creates, schedules, and delivers reports. The executable file is Reporting Services ReportServer Bin ReportingServicesService.exe. • Integration Services - Provides management support for Integration Services package storage and execution. The executable path is 130 DTS Binn MsDtsSrvr.exe • SQL Server Browser - The name resolution service that provides SQL Server connection information for client computers. The executable path is c: Program Files (x86) Microsoft SQL Server 90 Shared sqlbrowser.exe • Full-text search - Quickly creates full-text indexes on content and properties of structured and semistructured data to provide document filtering and word-breaking for SQL Server. • SQL Writer - Allows backup and restore applications to operate in the Volume Shadow Copy Service (VSS) framework.

• SQL Server Distributed Replay Controller - Provides trace replay orchestration across multiple Distributed Replay client computers. • SQL Server Distributed Replay Client - One or more Distributed Replay client computers that work together with a Distributed Replay controller to simulate concurrent workloads against an instance of the SQL Server Database Engine. • SQL Server Trusted Launchpad - A trusted service that hosts external executables that are provided by Microsoft, such as the R runtime installed as part of R Services (In-Database). Satellite processes can be launched by the Launchpad process but will be resource governed based on the configuration of the individual instance.

The Launchpad service runs under its own user account, and each satellite process for a specific, registered runtime will inherit the user account of the Launchpad. Satellite processes are created and destroyed on demand during execution time. Launchpad cannot create the accounts it uses if you install SQL Server on a computer that is also used as a domain controller.