Services in SQL Server

Service :
               Service is a long running program which takes the request  and gives the response .
               These services can be installed on 2 types of accounts .

                a . Local System Account .
                b.  Domain User Account .

               The main advantages of domain user account are listed below .

               1. More secured than local system account .
               2. Databases backup and restore can be performed across network folders.
               3. The applications like log shipping , db mirroring can be implemented across the multiple                       servers .

    Note : We can change the account type but we required downtime for it .

Type of Services :

    a. Instance Aware Services :

           These services are installed once for each instance .
           The following are the instance aware services .

              1. SQL Server Service (Database Engine) .
              2. SQL Server Reporting Services .
              3. SQL Server Analysis Services .
              4. SQL Server Agent Services .
              5. SQL Server Full Text Search Service .
 
  b. Instance UN-Aware Services :


          Instance Aware Services are installed only once for all the instances .
          Some are SQL Server Services and some are windows services .
          The instance un -aware services are displayed in the format of service name .

        Following are the list of  instance - unaware services

             1. SQL Server Integration Services .
             2. SQL Server Browser Services .
             3. SQL Server VSS Writer (Windows Service ).
             4. SQL Server Active Directory Helper (Windows Service )