Monthly Archives: July 2015

Zero-Cost Highly Available Reporting Services within a Failover Cluster

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

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