Category Archives: SQL Server 2008 R2

Updating SQL Server Instance Collation without rebuilding Master Database

Whether a SQL Server DBA is a newbie or an experienced, rebuilding the master database is one of the most dreaded tasks.

It’s similar to the fear of walking into the unknown without knowing what’s on the other side of the road.

Continue reading

SQL Server 2008 R2: Adding SSRS to already existing SQL Cluster Installation

In most cases, adding any service, such as SSAS, SSRS, or a database engine, to an existing installation is not possible, and such additions require a named Instance installation.

This problem first appeared in 2013 on a SQL server 2008 R2 that was running on Windows Server 2008 R2.

Keep On Reading