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/

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!

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. Apart from that most of the SME market are focusing on cloud computing and server virtualization options. 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!

Gaining higher IOP’s in iSCSI world

When it comes to consolidating servers one key concern is the hardware capability to handle that workload simultaneously. CPU is not an big issues since we’re having more rough horsepower on those. Disk speed and network speed has been key constraint areas. I’ve been discussing about using iSCSI for storage protocols and it’s popularity.

SAN storage has been the preferred method for the VHD hosting in most scenarios. To communicate with the SAN storage some vendors support HBA adapters, Even though this solution is good it comes with a hefty price tag. Step into the iSCSI protocol over the existing Ethernet. Ethernet has been improving for vastly and IT companies focusing on using Ethernet as the preferred method. As a result 10 Gbps has been introduced to cater the market requirement.

The interesting story I want to bring is Microsoft has incorporated with Intel to bring i million IOPs over iSCSI protocol! That means speed never will be a key issue again for you. Check out the following webcast which describe about this technology. Apart from that additional information can be found over here about this webcast.

bottom line is companies can carefully evaluate how they really want to move with storage and the storage designing and what components need to there. iSCSI and 10 G networks are getting popular so it’s time to invest your money carefully on virtualization and get maximum ROI.

Edit: I thought of highlighting this article again and it’s significant since at this stage Server Virtualization is having a rapid growth. Most of the companies I’m interacting are having the desire to taste the virtualization but don’t have the budget of owning FC SAN. Last year I’ve highlighted the advantage of considering the software based iSCSI solutions. Guess what that really applies now to most of our SMB, SME and also Enterprise customers who want to have their certain business applications hosted in virtualization environment. Intel has released the whitepaper of the test they carried out on this test lab.

Backup and Recovery methods for HYPER-V

Most of our customers are having practical issues on how to backup and recover HYPER-V machines. One key thing is HYPER-V  backup procedure or at least I would say approach is different from normal server backup methods.

If you’re expecting to backup the VPC using Windows native backup software then it is still possible but the issues will be you won’t be able to recover single VPC in a recovery scenario instead entire volume. As you can see this is time consuming but free options always comes with a catch. At least this is a good option to backup your VPC without shutting them down.

Please refer to this TechNet article which describes solutions in very detail and easy to understand method.

If you prefer to backup individual VPC level and their data inside separately then you’ll have to consider backup software which is aware about HYPER-V. Microsoft DPM is one such software which is very comprehensive in that area. Some of the resources about HYPER-V backup using DPM can be found over here and here.

Apart from that Symantec Backup Exec 12.5 is a good software which is capable of backing up HYPER-V  VPC’s and recovering individual file level. (hint…hint guys)

One practical advise is backup and restore of VPC is time consuming task. so make sure your backup solution has a speedy method of recovery, DPM overlook this sometime back and advise customers to move into disk based backup. Still you have to make sure backup media connectivity with the host server support speedy recovery.

So one way to minimize of these kind of unhappy moments is to have high availability solutions like HYPER-V host clustering. This will allow you to balance the HYPER-V  workload. More information about this can be found plenty out there when you do a search. One comprehensive article can be found over here.

We’re looking forward to provide more information about HYPER-V backup from DPM 2010 product in future articles, so stay tuned 🙂