{"id":524,"date":"2013-01-09T19:39:51","date_gmt":"2013-01-09T14:09:51","guid":{"rendered":"http:\/\/pramodsingla.wordpress.com\/?p=524"},"modified":"2013-01-09T19:39:51","modified_gmt":"2013-01-09T14:09:51","slug":"sql-server-services-installed-by-sql-server-2012","status":"publish","type":"post","link":"https:\/\/pramodsingla.com\/?p=524","title":{"rendered":"SQL Server Services installed by SQL Server 2012"},"content":{"rendered":"
\n
\n

List of Services Installed by SQL Server 2012<\/strong> <\/a><\/span><\/h4>\n
\n
\n<\/div>\n<\/div>\n<\/div>\n
\n

Depending on the components that you decide to install, SQL Server Setup installs the following services:<\/p>\n

    \n
  • SQL Server Database Services<\/span>\u00a0–<\/strong> The service for the SQL Server relational Database Engine. The executable file is <MSSQLPATH>\\MSSQL\\Binn\\sqlservr.exe.<\/li>\n
  • SQL Server Agent<\/span> –\u00a0<\/strong>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 <MSSQLPATH>\\MSSQL\\Binn\\sqlagent.exe.<\/li>\n
  • Analysis Services<\/span> –\u00a0<\/strong>Provides online analytical processing (OLAP) and data mining functionality for business intelligence applications. The executable file is \\OLAP\\Bin\\msmdsrv.exe.<\/li>\n
  • Reporting Services<\/span> –\u00a0<\/strong>Manages, executes, creates, schedules, and delivers reports. The executable file is <MSSQLPATH>\\Reporting Services\\ReportServer\\Bin\\ReportingServicesService.exe.<\/li>\n
  • Integration Services<\/span> –\u00a0<\/strong>Provides management support for Integration Services package storage and execution. The executable path is <MSSQLPATH>\\110\\DTS\\Binn\\MsDtsSrvr.exe<\/li>\n
  • SQL Server Browser<\/span> –\u00a0<\/strong>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<\/li>\n
  • Full-text Search<\/span> –<\/strong>\u00a0Quickly creates full-text indexes on content and properties of structured and semi-structured data to provide document filtering and word-breaking for SQL Server.<\/li>\n
  • SQL Writer<\/span> –<\/strong>\u00a0Allows backup and restore applications to operate in the Volume Shadow Copy Service (VSS) framework.<\/li>\n
  • SQL Server Distributed Replay Controller<\/span> –\u00a0<\/strong>Provides trace replay orchestration across multiple Distributed Replay client computers.<\/li>\n
  • SQL Server Distributed Replay Client\u00a0<\/span>–\u00a0<\/strong>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.<\/li>\n<\/ul>\n

    References :\u00a0<\/strong>http:\/\/msdn.microsoft.com\/en-us\/library\/ms143504.aspx<\/p>\n

    \n<\/div>\n","protected":false},"excerpt":{"rendered":"

    List of Services Installed by SQL Server 2012 Depending on the components that you decide to install, SQL Server Setup[…]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[1],"tags":[148,163,173],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts\/524"}],"collection":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=524"}],"version-history":[{"count":0,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts\/524\/revisions"}],"wp:attachment":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=524"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=524"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=524"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}