Author Archives: sqlx86

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


Building Windows Domain and Installing SQL server and Windows Cluster

This is the first of a multi-part article on how to run a SQL test lab on a laptop. To begin, we must first enable Windows’ hyper-V feature. Hyper-V is included with Windows 10, however it is turned off by default. We can utilize the GUI, PowerShell, or the command line to enable HyperV.

Keep On Reading

Setting up a SQL Server Lab on your laptop using Hyper-V

With the Cloud at our disposal and a myriad of virtual Labs available, setting up a lab in this day and age is like reinventing the wheel. (MSDN membership, AWS free credits, additional offers) Both Azure and AWS provide free credits up to the tune of $150/mo or $100/mo to test their products, but sometimes your desire to build from the ground up takes over and you plunge in without a second thought.

Keep On Reading