Home > installation, Installations, service pack > how to Slipstream SP2 or SP1 for SQL 2008 R2 – part 2 – installing reporting services along with database engine

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

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 🙂

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: