Open topic with navigation

Configuring the Double-Take Reporting Service server

1. Make sure you have inserted your Reporting Service server into your console. See Adding servers.
2. From the Manage Servers page, double-click your Reporting Service server to open the server's details.
3. From the View Server Details page, click the Edit server properties link.

4. The Reporting Service properties identify the SQL database configuration, the data collection configuration, and the Double-Take servers you are collecting from.

   

   • Database server name—Specify the name of the SQL server that contains your SQL database that will store the collected Double-Take data.
   • Database name—Specify the name of the SQL database that will store the collected Double-Take data.
   • Database instance name—If necessary, specify the database instance name of the SQL database that you specified.
   • Use reporting service credentials—Select this option if you want to use the credentials the Double-Take Reporting Service is running as.
   • Use database credentials—Select this option if you want to specify SQL database credentials.
   • Test—This button will test the specified credentials and check to see if the tables exist in the specified database. If they do not exist, they will be created. The database user role membership must be db_owner and public to create the tables. If the tables already exist, they will be updated to the correct version, if necessary. Once the test (and therefore the table creation or verification) is complete, the database user role membership can be changed, if desired, to db_datareader, db_datawriter, and public.
   • Collection interval—Specify the amount of time to wait between data collections.
   • Retention interval in days—Specify how long to retain the collected data. Data older than the specified number of days will be deleted from the database.

   • Identify the servers to collect data—Only the servers in your console session will be listed. Highlight the servers you want to collect data from and click Add >. If you want to add all of the servers click Add >>. If the server you want to collect data from is not listed, you need to add it from the Manage Servers page. See Adding servers.

     If you need to remove a server from the Collect data from list, click < Remove. If you want to remove all of the servers, click << Remove.

5. When you have finished your Reporting Service server configuration, click OK to return to the Manage Servers page.