Category Archives: SQL 2008

Zero-Cost Highly Available Reporting Services within a Failover Cluster

Posted on July 7, 2015 by admin_sqlgrinder

This solution is for anyone that has a SQL failover cluster and wishes Reporting Service to be highly available and have failover capabilities. The solution I implemented seems the most natural and how Reporting Services should work right out of the box – but … Continue reading →

Posted in Failover Cluster, SQL 2008, SQL 2012, SSRS | Tagged , , , | 5 Comments

Accessing Multiple Cluster Instances without Instance Names

Posted on July 1, 2015 by admin_sqlgrinder

Since I was installing a dual instance cluster, I had setup two virtual SQL database names with different IP address and the second instance required a non-default instance name. However, I wanted to access both instances using the virtual name … Continue reading →

Posted in Failover Cluster, SQL 2008, SQL 2012 | Comments Off on Accessing Multiple Cluster Instances without Instance Names

SQL Setup Checklist – Because SQL Defaults Suck!

Posted on June 24, 2015 by admin_sqlgrinder

When installing SQL, it is too easy to click next and accept all the default settings. Kevin Boles has preached for years that SQL Server defaults suck! Joseph D’Antoni has also addressed bad default settings in Building Perfect SQL Servers … Continue reading →

Posted in SQL 2008, SQL 2012 | Comments Off on SQL Setup Checklist – Because SQL Defaults Suck!

Gotchas: Installing SQL 2008R2 on Windows Server 2012R2 Cluster

Posted on June 13, 2015 by admin_sqlgrinder

I was building a new cluster with a dual instance of SQL 2012 and SQL 2008R2. Everything went easy with the SQL 2012 but not so well with the SQL 2008R2 install. As many have found out installing SQL 2008R2 … Continue reading →

Posted in Failover Cluster, SQL 2008 | Tagged | Comments Off on Gotchas: Installing SQL 2008R2 on Windows Server 2012R2 Cluster