SQL 2000a? Does it really exist, or is it a misprint?

After the fun Microsoft had with Slammer a change was made: SQL 2000a does exist and is the current version. SQL 2000a is basically the original disk of SQL 2000 with one DLL replaced to protect against getting the Slammer worm.  Windows Server 2003 actually has a check for this particular patch (hence the need for SQL SP3a or higher requirement) and disables network access for SQL until it is in place.  That is why we have to do the named pipe alias (see http://msmvps.com/clustering/archive/2005/10/19/71580.aspx) for clustered non-default instance installs on Windows Server 2003. Windows Server 2003 doesn’t like installing the original version and prefers SQL … Continue reading SQL 2000a? Does it really exist, or is it a misprint?

Installing a new SQL instance into an existing cluster on a new Node

We added a node to one of our clusters. We confirmed that the hardware, firmware, bios, OS, and installed programs were exactly alike. The new machine joined the cluster like a champ, no issues. When I went to install SQL and create a new instance, I was hit with this error: The cluster resource failed to come online. If extended error information was reported by the clustering service it can be obtained from the event log. It turns out this is a known issue. From http://support.microsoft.com/default.aspx?scid=kb;en-us;815431 “To run SQL Server on Windows Server 2003, you must have SQL Server 2000 Service … Continue reading Installing a new SQL instance into an existing cluster on a new Node

Should Clustered services be set to ‘manual’ or ‘automatic’?

The question goes something like this: My cluster is installed and running SQL/Exchange nicely but I noticed that all the services for SQL/Exchange are set to start manaully. Should I set the services to automatic instead? Answer: Cluster controlled services should always be set to manual, so that the cluster can control the startup and shutdown. Remember with Microsoft clustering only one server can control a resource at any given time. Leaving the services set to manual will help the cluster service do it’s job and ensure an error free service 🙂

Small Business Server (SBS) Clustering

I get this question from time to time: “Does Windows 2003 Small Business Server support clustering and if not would you suggest a 3rd party clustering solution.  The only catch I see is the SBS feature of not letting any other SBS servers in the same domain.” Let me answer these questions with the facts: 1) You can add servers to an SBS domain. You can’t not add another SBS Domain Controller (though a standard DC can be added), but a server running Exchange or SQL is allowed and works nicely. 2) You can’t have another SBS server into the … Continue reading Small Business Server (SBS) Clustering