Archive for the ‘installation’ Category

HOW TO Set up TEST Environment for SQL SERVER 2014 CTP2 or SQL SERVER 2012 PART 2

December 23, 2013 1 comment


for setting up TEST env for Server 2012 and above refer to my First post for initial details and videos from 1 to 6

remaining Videos are as below :: –>

once again CREDITS goes to metamanager  (Check out the Channel and Subscribe to the same)

Video number 7 

Video number 8 

 Video number 9

Video number 10


CREDITS goes to metamanager 

Thanks a lot for checking out the page .. do comment and share !!!



HOW TO Set up TEST Environment for SQL SERVER 2014 CTP2 or SQL SERVER 2012 PART 1

December 23, 2013 2 comments

Hey ALL,

if you are looking forward to set-up a test server for playing around with SQL server 2014 CTP2 release or have some

concepts cleared on always ON on SQL SERVER 2012 .. Follow on ..

Below is the flow of this post ..

1> links for pre-requisite for Setting up SQL server 2014 CTP2 or SQL Server 2012 Environment

2> Video Links for Setting up SQL Server 2012 (Same concepts and set-up is applicable to SQL Server

       2014 CTP2) 

Video links are taken from metamanager  (Check out the Channel and Subscribe to the same)

Credits for Videos goes to metamanager .. Thanks a lot for sharing them … Great for the SQL communities 

Host machine specs

–>  windows 7 ,8 GB RAM,core i5 ,around 150+ GB HD (so anything close to this or higher will be great )

download below ISO Files for

windows SERVER 2012 ,

SQL server 2012


SQL server 2014 CTP2

i have preferred to download ISO file (you may use CAB if you prefer , ALL links are for Evaluation Editions only )

1> Windows Server 2012 –>



2>  SQL Server 2012 –>


3> SQL Server 2014 CTP2 –>

 4>  VMWARE workstation or Hyper-V is required to set-up the Virtual environment


 –> if you are interested in trying out Hyper-V then check out This links  (it is also  present as a feature in Server 2012)

         Once you are done with downloading the OS,SQL Server and VMware (or Hyper-V)

              Follow below Videos to Set-up your Env ..

















REST of the Videos .. i will share in second post ..

once again CREDITS goes to metamanager  (Check out the Channel and Subscribe to the same)

Enjoy 🙂

how to Slipstream SP2 or SP1 for SQL 2008 R2 – part 2 – installing reporting services along with database engine

June 15, 2013 Leave a comment

Hi all,

as promised in my last post .. that I will test a scenario were in .. if we try to install reporting services using a Slipstream SP2 of SQL

server 2008 R2 .. then we may hit issues and installation may fail .. all together for reporting services ..

Nicolas Cain has covered more on this at this site –>

you may refer the post over here how to Slipstream SP2 or SP1 for SQL 2008 R2

below are the step followed for installing SQL reporting services along with DB engine (using Slipstreamed SP2 of SQL server 2008 R2)

my OS was windows 7 SP1 64 bit ..


1>  selected reporting services and database engine on feature selection page ..


2> update setup media compatibility test PASSED .. signifying slipstream installation


3> Giving a named instance for this particular instance ..


4> choosing to install NATIVE mode Default installation for Reporting services


5> verified that our installation is a SLIPSTREAMED installation of SP2


6> confirm the features selected


7> summary log file .. shows success for reporting services feature installation ..



I was able to connect to reporting services using SSMS server name as –> http://machinename:8080/ReportServer_SQL2008R2_INST3

I have tweaked the port no. from 80 to 8080 .. as I have trouble connecting to the same using reporting configuration

also I have recreated the reporting databases using reporting configuration GUI ..

all in all I did not face any particular issues with installation and this issue can be specific to windows OS

do share details .. if you are facing any issues for installation of reporting services using Slipstreamed method ..

Enjoy 🙂

how to Slipstream SP2 or SP1 for SQL 2008 R2

June 4, 2013 1 comment

Hi all,

I was looking for ways to do a slipstream installation for SQL server 2008 R2 SP2 .. I referred to this for some important info .. and below are steps I

followed to achieve the same .. A great THANKS to Peter Saddow (Microsoft)  for his blog …

My mind gets ahead of me ... Five Ways to Be G...

Slipstream allows you to do service pack installation along with the initial installation of SQL server ..

this helps save downtime and avoid any manual installation errors …

Steps as below ..

1> copy your original SQL server setup to a folder named SQL2008R2

2> download the service pack from this location . make sure you download them all 3 (x86,x64 and ia64)

irrespective of the fact you will eventually be using one … but to make sure your SP are complete in every sense ..

3> you need to create a FOLDER named SP2 (or whatever you want to name it ) with in the folder named SQL2008R2

(that is the location where your original installation is placed)

4> extract the 3 downloaded EXE into this newly created FOLDER named SP2 (below are the command)

SQLServer2008R2SP2-KB2630458-IA64-ENU.exe /x:T:\SQL2008R2\SP2

SQLServer2008R2SP2-KB2630458-x64-ENU.exe /x:T:\SQL2008R2\SP2

SQLServer2008R2SP2-KB2630458-x86-ENU.exe /x:T:\SQL2008R2\SP2

remember .. T:\SQL2008R2 contains the original SQL server setup and we created a folder named SP2 within T:\SQL2008R2

5> Robocopy the SETUP.exe file from newly created folder SP2 into original setup .. that we want to replace the setup.exe file of original SQL server setup with SP2 setup.exe

T:\SQL2008R2_SP2>robocopy T:\SQL2008R2\SP2 T:\SQL2008R2 setup.exe

robocopy26> Copy all files not the folders, except the Microsoft.SQL.Chainer.PackageData.dll, in T:\SQL2008R2\SP2\<architecture> to T:\SQL2008R2\<architecture> to update the original files. Here is the Robocop command

T:\SQL2008R2_SP2>robocopy T:\SQL2008R2\SP2\x64 T:\SQL2008R2\x64 /XF Microsoft.SQL.Chainer.PackageData.dll

T:\SQL2008R2_SP2>robocopy T:\SQL2008R2\SP2\x86 T:\SQL2008R2\x86 /XF Microsoft.SQL.Chainer.PackageData.dll

T:\SQL2008R2_SP2>robocopy T:\SQL2008R2\SP2\ia64 T:\SQL2008R2\ia64 /XF Microsoft.SQL.Chainer.PackageData.dll

7> check whether you have DefaultSetup.INI .. at this location .. mostly you should I them .. if not we will create it


T:\SQL2008R2\x86 and


If you have a DefaultSetup.INI at the above locations, add the following lines to each DefaultSetup.INI:


note : SP2 is the folder we created within the original setup files .. if you used a different name .. please use that folder name ..

this tells the installation setup  that service patch files are located within this folder ..

8> If you do not find any DefaultSetup.INI files in a rare case , create one with the following content:

;SQLSERVER2008 R2 Configuration File



and copy to the following locations


T:\SQL2008R2\x86 and


9> run the setup as you would do normally  from with in T:\SQL2008R2 ..

below are the indications that you are doing a slipstream installation …


10> for this … I have only chosen database engine .. in the features ..

install411> confirm tht you see “Update Setup Media Language Rule” as PASSED in the installation rules page

install512> On the Ready to Install dialog, the Action will indicated (“Slipstream”) … this confirms … that we are going right .. till now ..

install613>  PCUSource parameters in the summary log .. states that it picked up the SP2 from the path we pointed it to ..


this confirms that our installation has gone right … do confirm the same by connecting using SSMS


Slipstream has reportedly given issues if we try to do installation of reporting services .. I have not selected the same for now ..

refer this for details

I will try to do a reporting service installation in my next post ….  ENJOY 🙂