SQL Server and Windows

When you install SQL Server on server operating systems, SQL Server makes several modifications to the environment. These modifications include new system services, integrated authentication, new domain/workgroup accounts, and registry updates.

Services for SQL Server

When you install SQL Server on Windows, several services are installed on the server. These services include the following:

  • Distributed Transaction Coordinator. The Distributed Transaction Coordinator service coordinates distributed transactions between two or more database servers.

  • SQL Active Directory Helper. MSSQLServerADHelper100 adds and removes objects used to register SQL Server and Analysis Server instances. It also Updates object permissions related to ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.