Category Archives: SQL Clustering

All things to do with SQL Clusters

New 2008 r2 Install SSIS “Failed to retrieve data for this request.”

You might also get: “The SQL Server instance specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer.”  To resolve this…

Posted in SQL Administration, SQL Clustering, SSIS | Leave a comment

Get Alerted when your 2000 SQL cluster fails over

Today, I want to show how to be alerted any time one of your clustered SQL 2000 server fails over.  This will work whether some admin fails it over on purpose, or accidentally. 

Posted in SQL 2000, SQL Clustering | Tagged , , | Leave a comment

» Get Alerted when your 2005 SQL cluster fails over

Today, I want to show how to be alerted any time one of your clustered SQL 2005 server fails over.  This will work whether some admin fails it over on purpose, or accidentally.

Posted in SQL 2005, SQL Clustering | Tagged , , , | Leave a comment