This is something I have seen in the tech forums and as well as tried by myself. So it would be great to share this knowledge with rest of the world.
one fundamental rule in computer world is security vs. productivity balance. Running SQL on a domain controller will expose the AD for too many issues. Following information has been abstracted from various online resources.
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. (This is the key issues I had to face)
-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.
I do hope these information will helpful when you’ve been requested to carry out a SQL setup on a DC 🙂
With the introduction of Windows 2008 Cluster service Microsoft has made the clustering as easy as it can for a system administrators. I’ve been blogging about Windows 2008 clustering on my blog and various other third party software you can use to accommodate the clustering. Once the Microsoft released MS Storage server for the TechNet subscribers I have been using that software frequently. Apart from that I found out StarWind software also providing good solutions as well.
Last month I got the opportunity to demonstrate the Windows 2008 clustering and it’s new capability to the IT Pro community with live demonstration. Too bad I forgot to get some picture on that event 😦 You can download the presentation I have created for that session from here.
This month I have received an invitation from the SQL community group to conduct a session about SQL cluster creation. Special thanks goes for the SQL community MVP’s for giving me the opportunity.
In that session I present about the MSCS (Microsoft Cluster Service) and the new features in the windows 2008 R2 cluster. Apart from that we went ahead of doing a live demo on SQL cluster creation. It too nearly 1.5 hours for the entire demo since I ran everything from singe machine!
Never the less it very exciting session since I got to interact with the SQL community members. Apart from that participant had various questions about the cluster creation since most of them are database developers and some of them have already work on SQL cluster 2005.
One thing I briefly went talk about is the cluster migration from SQL 2005 cluster to SQL 2008. Forum members can download the presentation from www.sqlserveruniverse.com.
Apart from that we went and discuss about various technical setup and configurations you need give attention during the cluster creation and how to do basic level troubleshooting steps.
SQL MVP Dinesh Asanka presenting the SQL session,
forum members who won prizes,