Connecting to RC-Archive databases
RC-Reporter must be configured to connect to one or more RC-Archive databases.
RC-Reporter users with Admin Access permissions can set up connections to multiple RC-Archive databases on multiple servers.
When you go to the Manage Databases page, RC-Reporter automatically lists the Microsoft SQL Server host computers containing RC-Archive databases that are available on the network. You can also use the left pane to enter connection parameters to manually connect to database servers that are not easily discoverable on the network.
If a SQL Server host computer does not appear in the list of available servers, there may be a communication issue, such as an incorrectly configured firewall, or a database server that is not available on the network.
The following information describes the actions that you can perform on the Manage Databases page.
Use the following steps to connect to a listed database server:
- Click Data > Databases.
- In the Add Server pane, click the database server name to open the Add New Server dialog box.
The database server includes the SQL Server instance containing the RC-Archive database. The User Name and Password boxes display the default settings for the RC-Archive database. Modify these settings if required. - In the Add New Server dialog box, click Add.
Use the following steps to connect to a database server by entering parameters:
- Click Data > Databases.
- In the Add Server pane, click the Add Server
icon. - In the Add New Server dialog box, complete the following:
- Server — Enter the server name.
- User Name — Enter user name for the database server.
- Password — Enter the password for the database server.
- Click Add. You can now view the database names available on the server.
Use the following steps to connect to a database:
After you connect to a database server, you can view and connect to one or more databases.
- Click Data > Databases.
- On the Manage Databases page, click the Add
icon in the Databases column for the database server to open the list of databases. - In the list of database names, select one or more databases to use for report data.
- Click outside the list to include your selections and update RC-Reporter. If you previously connected to a database and it has been updated, wait a few minutes for RC-Archive to be updated, then click Batch Actions > Refresh Points and the new data is available for use in reports.
Use the following steps to remove a database:
- Click Data > Databases.
-
On the Manage Databases page, only databases where none of the points are in use can be deleted, and an X is beside the database name. Click the X to delete the database.
Use the following steps to remove database servers:
- Click Data > Databases.
- On the Manage Databases page, select the database servers to disconnect.
- Click Batch Actions > Remove Selected.
- Click OK.
© 2019 Reliable Controls Corporation. All rights reserved. Published October 29, 2019