Archive

Archive for the ‘Installations’ Category

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

December 23, 2013 1 comment

Hi ALL,

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 !!!

Enjoy

 

Advertisements

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

or

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 –> 

http://technet.microsoft.com/en-in/evalcenter/dn205286.aspx

 

download_ISO_file

2>  SQL Server 2012 –> 

http://www.microsoft.com/en-us/download/details.aspx?id=29066

OR

3> SQL Server 2014 CTP2 –>

 http://technet.microsoft.com/en-US/evalcenter/dn205290.aspx

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

  https://my.vmware.com/web/vmware/info/slug/desktop_end_user_computing/vmware_workstation/10_0

                                                                                               OR

 –> 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 ..

                                                                             1> 

 

                                                                            2> 

 

                                                                           3> 

 

 

                                                                         4>

 

 

                                                                        5>

 

 

                                                                     6>

 

 

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 –>  http://sirsql.net/blog/2012/11/15/issues-with-slipstreaming-service-pack-2-on-to-sql-2008-r2.html

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 ..

1

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

2

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

3

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

4

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

5

6> confirm the features selected

6

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

7

Notes:

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 🙂

great links about slipstream drop .. SQL 2008 R2

May 20, 2012 Leave a comment

Hey ..

           I justed happen to come cross some cool sites discussing about abt slipstream ..

          it helps you to do your original sql server installation and SP at ONCE — talking about SQL 2008 and highher ..

          below are the links …

        1>  http://www.littlekendra.com/2009/11/10/are-you-slipstreaming-the-very-best-way-to-install-sql-server/

        2> http://blogs.msdn.com/b/petersad/archive/2011/07/13/how-to-slipstream-sql-server-2008-r2-and-a-sql-server-2008-r2-service-pack-1-sp1.aspx

      3> http://blogs.msdn.com/b/petersad/archive/2009/02/25/sql-server-2008-creating-a-merged-slisptream-drop.aspx

        Thanks for reading ….

Categories: Installations