Feb 18, 2014

How to install SSRS


28 Steps to install SSRS


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

No comments:

Post a Comment