Home Forums Reporting Services Reporting Services Replacing the SSRS server, but not the DB server, how to migrate reports? RE: Replacing the SSRS server, but not the DB server, how to migrate reports?

  • On the current application server where your reporting services is installed,

    do the following

    http://www.mssqltips.com/sqlservertip/1453/sql-server-reporting-services-configuration-tool/

    http://prajwaldesai.com/deploying-sccm-2012-part-12-installing-and-configuring-reporting-services-point/

    start Reporting Services Configuration

    1.Click Start, point to All Programs, point to Microsoft SQL Server 2008 R2, 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 2005 instead of Microsoft SQL Server 2008 R2 to open the configuration tools for SQL Server 2005 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.