DotCom’s Blog Space

We have been working on a remote distributor Highly available SQL 2008 / Windows Server 2008 installation.  We have come across many issues in doing this.  Microsoft claims they are geocluster capable.  FALSE**** The truth of the matter is that many geographically distributed datacenters in many cases due to security and the such also have there own VLAN’s or Subnets.  The old solution to clustering across datacenters was to create a VLAN that spanned the two datacenters.   With Geoclustering this was supposed to be solved.

 

Well after working with Microsoft teams and getting to the guys in the SQL development group.  There geocluster solution requires that each server have a NIC with the IP address of each Subnet the cluster will live in.   Guess what?  That means you still have to stretch the VLAN/Subnet across datacenter opening possible security issues.  Geocluster my butt.  Even there developers have been arguing its not truely geoclustering.   They say that in future versions this would probably be taken care of.   Anyways now to the new errors we had installing the solution.

 

When installing SQL on the primary cluster node,  toward the end of the install it will attempt to bring the cluster online.  If it doesn’t and errors out with the code above, you may want to check to make sure you have the NIC IP physically set, instead of using DHCP.  We got this error because it was set to DHCP and we are not running an environment that DHCP is supported in, so theres no servers to dish out IP’s.

Another Error we ran into was when we “Add a SQL Node” on the secondary nodes was “INVALID SKU” error.  You must retrieve the Cumulative Update #1 for sql 2008 to fix this issue.   They say it will be in the first service pack for 2008 but as of right now you must request it from Microsoft. 

 

I will try to keep people up to date on our implementation and issues we see as we progress through this.  I am also curious to hear from others what there experience is in the 2008/2008 installs.