You are here: Managing servers > Editing server properties > Reporting Service properties

Reporting Service properties

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.