4552

NO!!!! That pretty much summarizes my feelings on this topic. I have seen this proposed as a configuration before many times. The web guys say they need HA SQL for their web site data and then they figure that since they are getting a cluster that they can use it for IIS, too. No, don’t do it. While at first glance it makes some sense, if you start thinking big picture, then you start seeing the problems. First off, the big picture for an HA website with HA SQL backend should look like this: Clients connect to the Internet to … Continue reading Clustering IIS and SQL on the Same Boxes

What in the world was Microsoft thinking?   I was installing MOM 2005 and found out that it is not possible to install the MOM 2005 Database on a SQL Server 2000 server with SP4. WTF? That just doesn’t make sense.   Supposedly this will be fully supported with MOM 2005 SP1. Umm, that just doesn’t work for me. So, time to research. Thanks to Neil Hobson, a MOM MVP, a workaround has been published in the MOM 2005 public newsgroup. It is a registry hack, but at least it is a supported registry hack. What needs to be done is … Continue reading MOM 2005 and SQL Server 2000 SP4 – Original Posted Jun 27, 2005

Greg Page of the Microsoft Cluster Group and I had a mini-discussion today on the microsoft.public.windows.server.clustering newsgroup, as well as followed it up with a phone conversation, regarding the implementation of the MSDTC resource. In the past, Microsoft has clearly stated that the MSDTC resource and its dependent resources should be in their own cluster group separate from the default cluster group that contains the quorum. The reason behind that is that in the past, read: NT 4.0 clustering days, the MSDTC could consume enough disk time that the quorum would not be able to read/write to its disk, and it … Continue reading MSDTC and Server Clustering – Revisited – Original Posted Mar 24, 2005

I got brave and decided to fix the problem. The issue, for those who missed the first show, was that I needed to reconfigure the MSDTC on a SQL cluster. The MSDTC needed to be moved to a different drive because we are retiring one of the EMC frames. The more I read on this the more complex it seemed. I read through Q 301600 and Q 294209, and reviewed several other sources. These articles made it sound like I was going to have to rip out DTC on each node and then rebuild it on each node and restart … Continue reading MSDTC Issue Part 2 – Original Posted Feb 1, 2005

More like, it is semi-broken. Ok, it isn’t broken at all, but it isn’t configured the way I want it configured so I have a desire to fix it. It all started last Friday night. We are migrating from one EMC frame to another one. The storage guys (they really do a great job here) added new LUNS to the SQL cluster. We then added the drives as resources in cluster admin and then put the drive resources into the proper SQL cluster groups. We shut down the SQL services, did a quick file copy to the new drives, changed … Continue reading MSDTC Issue – Original Posted Jan 26, 2005