NO SQL Server on a domain controller

You may encounter problems when installing SQL Server on a domain controller

• Email
• Print

Summary

It is not recommended to install SQL Server on a domain controller. There are specific security restrictions when running SQL Server in this configuration and given the resource demands of a domain controller, SQL Server performance may be degraded. Furthermore, SQL Server is not supported on a read-only domain controller. Setup will normally fail. Even if you find methods to work around the problem with setup, SQL Server is not supported on a read-only domain controller. In addition, SQL Server failover clustering is not supported to install on a domain controller.

More information

For more information about the security restrictions for SQL Server on a domain controller, see the section titled Hardware and Software Requirements for Installing SQL Server 2008 R2 Hardware and Software Requirements for Installing SQL Server 2008 R2 in the SQL Server Books Online.

For more information about the products or tools that automatically check for this condition on your instance of SQL Server and on the versions of the SQL Server product, see the following table:

Rule software	Rule title	Rule description	Product versions against which the rule is evaluated
SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA)	SQL Server installed on PDC/BDC	The SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA) provides a rule to detect if SQL Server is installed on a domain controller. The SQL Server 2008 R2 BPA supports both SQL Server 2008 and SQL Server 2008 R2. If you run the BPA tool and encounter a Warning with the title of Engine -SQL Server installed on PDC/BDC- , then your SQL Server 2008 or SQL Server 2008 R2 instance is installed on a domain controller. BPA detects this configuration by querying the domain role property of the win32_computersystem WMI class.	SQL Server 2008 SQL Server 2008 R2
SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA)	SQL Server installed on PDC/BDC	The SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA) provides a rule to detect if SQL Server is installed on a domain controller. If you run the BPA tool and encounter a Warning with the title of Engine -SQL Server installed on PDC/BDC- , then your SQL Server 2012 instance is installed on a domain controller. BPA detects this configuration by querying the domain role property of the win32_computersystem WMI class.	SQL Server 2012

Properties

Article ID: 2032911 - Last Review: 01/07/2013 21:09:00 - Revision: 3.0

Applies to

• Microsoft SQL Server 2008 Analysis Services
• Microsoft SQL Server 2008 Developer
• Microsoft SQL Server 2008 Enterprise
• Microsoft SQL Server 2008 Express
• Microsoft SQL Server 2008 Express with Advanced Services
• Microsoft SQL Server 2008 R2 Datacenter
• Microsoft SQL Server 2008 R2 Developer
• Microsoft SQL Server 2008 R2 Enterprise
• Microsoft SQL Server 2008 R2 Express
• Microsoft SQL Server 2008 R2 Express with Advanced Services
• Microsoft SQL Server 2012 Analysis Services
• Microsoft SQL Server 2012 Business Intelligence
• Microsoft SQL Server 2012 Developer
• Microsoft SQL Server 2012 Enterprise
• Microsoft SQL Server 2012 Express
• Microsoft SQL Server 2012 Standard
• Microsoft SQL Server 2012 Web
• SQL Server 2012 Enterprise Core

Keywords:

• KB2032911