Answer:
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.
ie:
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.
ie:
1.Integration Services
2.SQL Server Browser
3.SQL Server Active Directory Helper
4.SQL Writer
Asked In: DBA Interviews |
Alert Moderator