Поделиться через

List of SQL Server Service Names

  • Статья

In the tables below, services that can have multiple instances on the same server have the default instance name listed first and then a named instance – “Contoso1.” These services names are without any service packs being applied. I haven’t checked to see if there are any changes to service names after installing service packs.

SQL Server 7

Common Name

Service Display Name

Service Name

Executable Name

Distributed Transaction Coordinator (DTC)

Distributed Transaction Coordinator

MSDTC

msdtc.exe

SQL Server

MSSQLServer

MSSQLServer

sqlservr.exe

SQL Server Agent

SQLServerAgent

SQLServerAgent

sqlagent.exe

SQL Server Analysis Services

MSSQLServerOLAPService

MSSQLServerOLAPService

msmdsrv.exe

 

SQL Server 2000

Common Name

Service Display Name

Service Name

Executable Name

Distributed Transaction Coordinator (DTC)

Distributed Transaction Coordinator

MSDTC

msdtc.exe

SQL Server

MSSQLServer

MSSQL$CONTOSO1

MSSQLServer

MSSQL$CONTOSO1

sqlservr.exe

SQL Server Active Directory Helper

MSSQLServerADHelper

MSSQLServerADHelper

sqladhlp.exe

SQL Server Agent

SQLServerAgent

SQLServerAgent

sqlagent.exe

SQL Server Analysis Services

MSSQLServerOLAPService

MSSQLServerOLAPService

msmdsrv.exe

 

 SQL Server 2005

Common Name

Service Display Name

Service Name

Executable Name

Distributed Transaction Coordinator (DTC)

Distributed Transaction Coordinator

 

MSDTC

msdtc.exe

SQL Server

SQL Server (MSSQLSERVER)

MSSQLServerContoso1

MSSQLSERVER

MSSQL$CONTOSO1

sqlservr.exe

SQL Server Active Directory Helper

SQL Server Active Directory Helper

MSSQLServerADHelper

sqladhlp90.exe

SQL Server Agent

SQL Server Agent (MSSQLServer)

SQL Server Agent (CONTOSO1)

SQLSERVERAGENT

SQLAgent$CONTOSO1

sqlagent.exe

SQL Server Analysis Services

SQL Server Analysis Services (MSSQLSERVER)

SQL Server Analysis Services (CONTOSO1)

MSSQLServerOLAPService

MSOLAP$CONTOSO1

msmdsrv.exe

SQL Server Browser

SQL Server Browser

SQLBrowser

sqlbrowser.exe

SQL Server Full Text Search

SQL Server FullText Search (MSSQLSERVER)

SQL Server FullText Search (CONTOSO1)

msftesql

msftesql$CONTOSO1

msftesql.exe

SQL Server Integration Services

SQL Server Integration Services

MsDtsServer

MsDtsSrvr.exe

SQL Server Reporting Services

SQL Server Reporting Services (MSSQLSERVER)

SQL Server Reporting Services (CONTOSO1)

ReportServer

ReportServer$CONTOSO1

ReportingServicesService.exe

SQL Server VSS Writer

SQL Server VSS Writer

SQLWriter

sqlwriter.exe

 

 

SQL Server 2008 and

SQL Server 2008 R2

Common Name

Service Display Name

Service Name

Executable Name

Distributed Transaction Coordinator (DTC)

Distributed Transaction Coordinator

MSDTC

msdtc.exe

SQL Server

SQL Server (MSSQLSERVER)

SQL Server (CONTOSO1)

MSSQLSERVER

MSSQL$CONTOSO1

sqlservr.exe

SQL Server Active Directory Helper

SQL Active Directory Helper Service

MSSQLServerADHelper100

SQLADHLP.EXE

SQL Server Agent

SQL Server Agent (MSSQLSERVER)

SQL Server Agent (CONTOSO1)

SQLSERVERAGENT

SQLAgent$CONTOSO1

SQLAGENT.EXE

SQL Server Analysis Services

SQL Server Analysis Services (MSSQLSERVER)

SQL Server Analysis Services (CONTOSO1)

MSSQLServerOLAPService

MSOLAP$CONTOSO1

msmdsrv.exe

SQL Server Browser

SQL Server Browser

SQLBrowser

sqlbrowser.exe

SQL Server Full Text Search

SQL Full-text Filter Daemon Launcher (MSSQLSERVER)

SQL Full-text Filter Daemon Launcher (CONTOSO1)

MSSQLFDLauncher

MSSQLFDLauncher$CONTOSO1

fdlauncher.exe

SQL Server Integration Services

SQL Server Integration Services 10.0

MsDtsServer100

MsDtsSrvr.exe

SQL Server Reporting Services

SQL Server Reporting Services (MSSQLSERVER)

SQL Server Reporting Services (CONTOSO1)

ReportServer

ReportServer$CONTOSO1

ReportingServicesService.exe

SQL Server VSS Writer

SQL Server VSS Writer

SQLWriter

sqlwriter.exe

 

 

 

SQL Server Service Names.docx

Comments

  • Anonymous
    January 01, 2003
    Really, really handy (especially the link to download the word document). It's in the toolbox, thanks.

  • Anonymous
    September 05, 2011
    useful list, when you need to re-register all SQl services with another user. I found it searching with "which are the SQl 2005 services"?

  • Anonymous
    June 20, 2012
    hey, thanks for your list..very helpful indeed.

  • Anonymous
    July 04, 2012
    Really very helpful.  Thanks a lot.

  • Anonymous
    January 26, 2013
    As a security analyst this list will be very helpful for writing database compliance checks for Nessus scanning.

  • Anonymous
    April 18, 2013
    When checking SNMP for the SQL Agent running (The Dude) I had to observe case sensitivity;  SQL Agent runs as SQLAGENT.EXE, not sqlagent.exe

  • Anonymous
    August 14, 2013
    I would like to find out if you have any text servers available what are their names?my email add is hmbao@realpeople.co.ke will appreciate the info Regards

  • Anonymous
    August 22, 2013
    What about SQL Server 2012 and 2014

  • Anonymous
    July 02, 2015
    thanks

  • Anonymous
    August 18, 2015
    Thanks!

  • Anonymous
    October 15, 2015
    This would be really good. if someone could update this.

  • Anonymous
    November 18, 2015
    thanks!

  • Anonymous
    January 11, 2016
    This is a really helpful list, thank you! Would you be willing to update this list for SQL 2012 and 2014?

  • Anonymous
    January 21, 2016
    very helpful thanks.

  • Anonymous
    March 09, 2016
    Nice one