Sql Server 2008 Reporting Service Configuration

Sql Server 2008 Reporting Service Configuration

Please go through following steps:

1. In the start menu go to Microsoft Sql Server 2008 R2 -> Configuration Tools, then click Reporting Service Configuration Manger.


 

 

 

 

 

 

 

 

 

2. In Reporting Service Configuration Connection, Select or Enter Server Name and Report Server Instance, then click on Connect.

3. In Report Server Status verify that the Service Status is set to Running. If it is not started, click on Start, and then click on Apply.

4. In Service Account Pane, you can set service account like Local System, if you want it to run only in local system or Network Service, if you want it to run on your Network.

5. In Web Service URL Pane, specify the name which you want to call the virtual directory created by Reporting Services or you can use the default Report Server or you can select the IP-address, the port and SSL setting you want to use. When done click on Apply.

6. In Database Pane, select existing Report Server Database or You can also create a new Report Server Database.

7. In Report Manager URL Pane, specify the name which you want to call the virtual directory created by Reporting Services or you can use the default Report Server or you can select the IP-address, the port and SSL setting you want to use. When done click on Apply.

8. Email settings are not mandatory but you can configure if it is necessary for you.

9. Execution Account is necessary to configure if you will be running unattended reports. Optionally apply credentials and Click Apply.

Congratulations! We have successfully configured Sql Server 2008 Reporting Services.

4 thoughts on “Sql Server 2008 Reporting Service Configuration

  1. This work on “Sql Server 2008 Reporting Service Configuration” was an intelligent job and surely deserves a appreciation and applaud to the time dedicated & ur industrious labour to such a useful, lucid & edible job; which can produce a jelly image in readers’ mind & encourage to do the same…

    Hop & expect further enlightenment…
    Gud job

Leave a Reply to apurv Cancel reply

Your email address will not be published. Required fields are marked *