DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2032911 - Last Review: January 7, 2013 - Revision: 3.0

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 (http://msdn.microsoft.com/en-us/library/ms143506.aspx) 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:

Collapse this tableExpand this table
Rule softwareRule titleRule descriptionProduct 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






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
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support