SQL Server - Deploying Reporting Services in Local Machine

Asked By Krishna T on 09-May-12 10:51 AM
How to Deploying Reporting Services in Local Machine?

Please give me step by step procedure.
Vikram Singh Saini replied to Krishna T on 09-May-12 12:24 PM
Step-by-step procedure for deploying reporting services on local machine can be found at:

http://www.accelebrate.com/sql_training/ssrs_tutorial.htm

where author explains deployment of services via different methods along with their testing way on local system. It's nice article which needs to follow and you get desired results.
[)ia6l0 iii replied to Krishna T on 09-May-12 01:05 PM
A little search on MSDN revealed this. 

Start with the MSDN article titled "How to Configure Reporting Services" at http://msdn.microsoft.com/en-us/library/aa545752(v=cs.70).aspx and read the follow up article titled "How to: Start Reporting Services Configuration" at http://msdn.microsoft.com/en-us/library/ms159644(v=sql.90).aspx

Hope this helps.
Somesh Yadav replied to Krishna T on 10-May-12 01:57 AM

To start Reporting Services Configuration

  1. Click Start, point to All Programs, point to Microsoft SQL Server 2012 , and then point to Configuration Tools.

    If you want to configure a report server instance from a previous version of SQL Server, open the program folder for that version. For example, point to Microsoft SQL Server 2008 instead of Microsoft SQL Server 2012 to open the configuration tools for SQL Server 2008 server components.

  2. Click Reporting Services Configuration Manager. The Connect to a Report Server Instance dialog box appears so that you can select the report server instance you want to configure.

  3. In Server Name, specify the name of the computer on which the report server instance is installed. The name of the local computer appears by default, but you can type the name of a remote SQL Server instance if you want to connect to a report server that is installed on a remote computer.

  4. If you specify a remote computer, click Find to establish a connection.

  5. In Report Server Instance, select the SQL Server Reporting Services instance that you want to configure. Only report server instances for this version of SQL Server appear in the list. You cannot configure earlier versions of Reporting Services.

  6. Click Connect.

    for more information refer to the below link,

    http://msdn.microsoft.com/en-us/library/ms156305.aspx

Jitendra Faye replied to Krishna T on 11-May-12 01:33 AM
For this first You must have SQL Server 2005 Reporting Services already installed on the computer.

after that you can configure your reporting service.

Now follow these steps-

1 Click Start, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then, 2 click Reporting Services Configuration. and fill required details.
3 Click Connect.

4 In the left pane of the Configure Report Server window, click Report Server Virtual Directory, and then, in the   right pane, click New.

5 In the Create a New Virtual Directory
6 Click OK.

7 In the left pane of the Configure Report Server window, click Web Service Identity, and then, in the right pane, on the Report Server line, click New.

8 In the New Application Pool fill required details.
9 Click OK.

10 In the Report Manager box, select ReportingAppPool as the Application pool, and then, click Apply.

11 In the SQL Server Connection Dialog dialog box, select Current User- Integrated Security from the drop down box.    Click OK.

For complete reference folloe this link-

http://msdn.microsoft.com/en-us/library/aa545752%28v=cs.70%29.aspx

Hope this will help you, for any help let me know.