Endpoint Protection

 View Only
  • 1.  Repoint SAV10 Reporting Server to a new database server

    Posted Jul 14, 2010 04:04 PM
    We're having an issue with our SAV SQL database server and would like to move the SQL reporting instance to a new server. After the database has been moved to a new SQL server is there any way to repoint the current Reporting Server to the old database that is located on this new SQL server. We're thinking reg hacks or something should allow us to repoint the reporting server without having to do a new install reporting server and then point it to the new SQL server.

    Any input would be greatly appreciated.


  • 2.  RE: Repoint SAV10 Reporting Server to a new database server

    Posted Aug 20, 2010 01:47 PM

    Note: The new SQL server and Reporting server must meet the requirements listed in SAV reporting installation guide.

    Detach the Reporting database

    If you are using SQL 2000, detach through SQL 2000 Enterprise Manager. If you are using SQL 2005, detach through SQL Server Management Studio.
    After the Database is detached, navigate to the appropriate data folder where the existing SQL server data files are stored - e.g. C:\Program Files\Microsoft SQL Server\MSSQL\xxxx\DATA OR C:\Program Files\Microsoft SQL Server\MSSQL\DATA.
    Copy the following database files to the data folder for the new server housing your new SQL DB
    The File names for the database files would be - <Reporting.mdf; and Reporting_log.ldf>
    On the new server where you want to move the existing SQL DB for Reporting Server, Right click on the Database instance, and click on Tasks / All Tasks and click on ATTACH DATABASE.
    Give the path to the <db_name.MDF> file, and the wizard shall automatically pick up the other .NDF and .LDF files.


    Reinstall reporting server pointing to the new SQL server.

    Note: When installing, it is not necessary to specify the reporting instance since it is already in the SQL database. Specifying the reporting database instance may cause the install to fail.