2

I'm looking to start the very minimum number of services to have a fully working version of SQL Server running that will enable external connections.

I know MSSQLSERVER is required but do I need to start SQLSERVERAGENT, MSSQLServerOLAPService, SQLBrowser and msftesql?

Thanks

Webmonger
  • 203
  • 2
  • 7

1 Answers1

3

Your server instance (MSSQLSERVER) is all that you absolutely need. The other services are required for other things that support the database service.

  • SQLSERVERAGENT is your job runner and required if you want to run SQL Agent jobs
  • MSSQLServerOLAPServices is Analysis Services
  • SQLBrowser is the instance locater and required if you do things like run your instances on non-standard TCP/IP ports
  • msftesql is the full-text search service and needs to run if you have that enabled
squillman
  • 37,883
  • 12
  • 92
  • 146