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
Wednesday, July 2, 2008
Installing SQL Server on a domain controller
Subscribe to:
Post Comments (Atom)





2 comments:
Good post by Amit on Installing SQL Server 2005 and 2008 on Diomain Controller.
Nice article.
Please give abstract for all the features in sql server 2008
Post a Comment