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.
2.SQL Server Agent
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.
2.SQL Server Browser
3.SQL Server Active Directory Helper
Asked In: DBA Interviews |