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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.