What are the Instance Aware and Unaware services in SQL Server?

 What are the Instance Aware and Unaware services in SQL Server?

Instance Aware Services:

  • The Instance Aware Services are specific to particular instance of SQL Server.
  • If we installed multiple instances you we get multiple copies of aware services.

The following services are:

  1. SQL Server
  2. SQL Server Agent.
  3. SQL Server Analysis Service.
  4. SQL Server Reporting Service.
  5. Full- text Service.

Instance Unaware Services:

  • The Instance Unaware services are shared among all installed SQL Server instances.

The following services are:

 

  1. Integration Service.
  2. SQL Server Browser Service.
  3. SQL Writer.
  4. SQL Server Active Directory Helper.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s