SQL Server 2000

Deploying SQL Server 2000 onto Windows 2003 clusters with more than 4 nodes

Wednesday, June 11th, 2008

So you’re deploying a clustered instance of SQL Server 2000 onto two nodes in a Windows 2003 cluster. The installer runs to completion, but all of the resources in your newly created cluster group are in the offline state, and any attempt to bring the group online results in an unknown failure.
In many cases, […]

What’s wrong with this picture?

Friday, April 11th, 2008

You are about to deploy SQL Server 2000 into “Group 0″ of the following cluster. Can you spot what is wrong with this cluster and why your install is going fail?

If you actually tried to deploy an instance on this cluster, you would start filling out the wizard and, after picking the nodes to […]

SQL Server Common Issues

Wednesday, April 2nd, 2008

Hello there, my name is Devin Heitmueller and I am one of the developers responsible for automating Microsoft SQL Server using GridApp Clarity. Large portions of my day are spent digging through the Microsoft knowledge base, debugging various configurations SQL Server can be deployed in, or identifying and addressing undocumented behavior in the SQL […]