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 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 🙂

 

http://support.microsoft.com/kb/2032911

http://www.sql-server-performance.com/2006/domain-controller-performance/

Advertisements

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 view, 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 even given 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 🙂

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 🙂

SQL 2008 high availability through Windows 2008 clustering

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,

SQL 2008 high availability through Windows 2008 clustering

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,

End of Microsoft EBS (Essential Business Server)

Sadly but truly Microsoft has removed the plug from the EBS server. MS has taken decision since there has been no much sales improvement in the server market for this product. EBS is targeted for customer who is having 300 seats (computers), but as the MS has identified a customer who is having 300 computers will be already established company in Infrastructure point of view.

Even though EBS provide significant cost benefit moving to EBS from existing server environment to EBS is daunting task.  Requiring  minimum 3 servers (And they need to be high end as well) to run the product suit including an additional server for premium version is not a easy financial consideration.So the product will be discontinued from selling from June onwards. But the for the existing customers the product will be supported by MS in the normal product life cycle.

What I like most is SBS has not been done any changes and most of the customers still benefit that. Personally I prefer SBS product since it is a significant cost saver for SBS market. This product is targeted for companies who is having less than 75 seats.

SBS Rocks!