Recent Posts

Posts RSS

Configure Report Server in SQL Server 2008

Reactions: 






First you have to install MS SQL Server 2008. Then go to Start – All Programs – Microsoft SQL Server 2008 – Configuration Tools and select ‘Reporting Services Configuration Manager’. After that follow the following 
steps:



STEP:1. Then the following window will come:

Click on ‘Connect’ button and then following window will come:

Note: If the ‘Stop’ button disabled then click on ‘Start’ button to start the server.


STEP:2. Then Select ‘Service Account’ from left side panel and if the following window will come then you are on right way otherwise you should change as shown in figure:

STEP:3. Then Select ‘Web Service URL’ from left side panel and if the following window will come then you are on right way otherwise you should change as shown in figure:

Note: You can give any name in ‘Virtual Directory’ field, but don’t change other fields


And click on that URLs shown bellow to check the server. If you see the following screen in your browser then it’s ok. Otherwise you have to check configuration again.

STEP:4. Then come to the next option ‘Database’ of that left side panel and check whether following screen like window is coming or not. If is not coming then click on ‘Change Database’ button or ‘Change Credential’ button on the right side and configure them.

  
STEP:5. Then come to the next option ‘Report Manager URL’ of that left side panel and check whether following screen like window is coming or not. If its not coming click on ‘Advance’ button and configure for your IP address.

On the above window click on that URLs and it’ll open in your default browser as shown bellow:

Note: The red circle marked things are optional for you. It shows in my case only.
That’s it. Now you can create your report and deploy easily which I’ll discuss in my next post.
Note: If it will not come as above then again repeat the above steps.

kick it on DotNetKicks.com

0 comments: