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:

  • Active Directory Helper. MSSQLServerADHelper adds and removes objects used to register SQL Server and Analysis Server instances. It also updates object permissions related to SQL Server service accounts.

  • Analysis Services. The Microsoft SQL Server Analysis Services are used for OLAP and data mining. For the default database instance, this service is named ...

Get Microsoft® SQL Server™ 2005 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.