Wednesday, July 2, 2008

Installing SQL Server on a domain controller

Hi All,

One of the members in the Mumbai IT forum asked about installing SQL Server 2008 on a domain controller. The following is an abstract from Books Online. This applies to SQL Server 205 as well.

--------------------------------------------------
For security reasons, Microsoft recommends that you do not install SQL Server 2008 on a domain controller. SQL Server Setup will not block installation on a computer that is a domain controller, but the following limitations apply:

-On Windows Server 2003, SQL Server services can run under a domain account or a local system account.
-You cannot run SQL Server services on a domain controller under a local service account or a network service account.
-After SQL Server is installed on a computer, you cannot change the computer from a domain member to a domain controller. You must uninstall SQL Server before you change the host computer to a domain controller.
-After SQL Server is installed on a computer, you cannot change the computer from a domain controller to a domain member. You must uninstall SQL Server before you change the host computer to a domain member.
-SQL Server failover cluster instances are not supported where cluster nodes are domain controllers.
-SQL Server is not supported on a read-only domain controller.
-------------------------------------------

Thanks
Amit

2 comments:

Jayant said...

Good post by Amit on Installing SQL Server 2005 and 2008 on Diomain Controller.

Ayyappan said...

Nice article.

Please give abstract for all the features in sql server 2008