Friday, December 19, 2014

Session 2 : SQL Server Reporting Services Installation
AnandFriday, December 19, 2014 0 comments


                                 Session 2 : SQL Server Reporting Services Installation


Lets move forward with getting to know how to install sql server 2008 reporting services. Please note, most of the steps are the same for installing sql server reporting services 2005.
Below are the steps to install SQL reporting services 2008 with express Database.

Step 1 :  Download the 64 bit or 32 bit version of SQL 2008 Express with advances services from here .

Step 2:  Right Click on the downloaded file and "Run as Administrator".


Step 3: The files will extract itself.



Step 4: In case you get a pop-up saying "This program has compatibility issues", click Run Program.




Step 5: You should be getting a progress screen.

Step 6: The SQL server Installation Center should fire up.



Step 7 : Select installation on right hand tab and click on "New SQL server stand -alone installation"


Step 8: SQL server will load the setup files.


Step 9 : Click OK, it should take you to next page.


Step 10 : Click Install.


Step 11: Click next, then again next.



Step 12 : Click next


Step 13 :  In feature selection, make sure you select 'Database Engine Services' and 'Reporting Services'

Step 14 :   Next, select Named Instance and give it any name (you can also choose Default instance)

Step 15 : Click next


Step 16 :  Select Mixed Mode --> enter in any password --> and specify SQL server admins.


Step 17 : Click next, and select 'Install, but do not configure under Reporting Services configuration.


Step 18 : Click Next


Step 19 : Click Next



Step 20 :  Click Install.

Step 21: After Installation is done, click next


Step 22 : Click Next.


Your installation is almost complete. In order to start using SSRS, you need to perform a few more steps.

Step 23: Click Start --> All programs --> Microsoft SQL 2008 --> Configuration Tools --> Reporting Services Configuration --> select your instance

Step 24 : Click web service URL on the left hand side and click the apply button.

Step 25 :  Click database on the left hand side, select change database --> create a new report server database and complete the steps.

Step 26 : Click report manager URL and click apply (Note down the URL displayed. It should be of the form http://machinename/reports)

Step 27: open IE and hit the noted down URL

Step 28 : You should get a screen like this.


That's all. We are all set. Let's install some sample databases and get started learning SSRS 2008
In Category :
About The Author Anand Anand is a Microsoft Certified MCITP (Business Intelligence Infrastructure Using Microsoft SQL Server 2008), MCTS (SQL Server 2008, Business Intelligence Development and Maintenance) with 8 + years of experience in the Finance , Education, Healthcare, Banking and Insurance, Telecom domain focused on delivering software design, development, and data migrations from diversified data sources using Business Intelligence analysis tools..

0 comments

Post a Comment