What is Instance-aware and Instance-unaware Services in SQL Server ?

 Posted by PandianS on 7/16/2010 | Category: Sql Server Interview questions | Views: 8884

Instance-aware services are associated with a specific instance of SQL Server, and have their own registry hives. We can install multiple copies of instance-aware services by running SQL Server Setup for each component or service.
1.SQL Server
2.SQL Server Agent
3.Analysis Services
4.Reporting Services
5.Full-text search

Instance-unaware services are shared among all installed SQL Server instances. They are not associated with a specific instance, are installed only once, and cannot be installed side-by-side.
1.Integration Services
2.SQL Server Browser
3.SQL Server Active Directory Helper
4.SQL Writer

Asked In: DBA Interviews | Alert Moderator 

Comments or Responses

Login to post response