Installing SQL 2008 on a domain controller

This is something i have seen in the tech forums and as well as tried by myself. So it would be ideal to share this knowledge with others to get benefited.

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 :)

Proud owner of a Apple iPod (3rd Generation)

Got my hands into the long awaited apple iTouch yesterday. This is 32 GB version. Even though they have 3rd generation iTouch on 8 GB it’s entire design is on 2nd generation. As a technical point of first thing I did is upgrade the firmware :) Well tough to say what kind of improvement has it made since I barely test it even for few hours. So far I’m loving all the features in it specially the wifi access availability and the mail access. Apart from that I really like the idea of voice memos. Even though this is introduced as MP3 player I think it has the essential tools for day to day work.

One disappointment is missing of the camera. I really wish Apple would have consider that into this device since it is a essential part. Let’s put it this way, so far they have given all the utilities you can imagine of and give the apps to edit pictures even but missing the camera! But again before moving to this I did some web research and found of lots of positive feedback on it.

I didn’t went for Microsoft Zune due to the limited apps available in the internet when I did the research. But guess MS will find a way to overcome that very soon. Saying that here goes a another member to the Apple iPod community :)