Database Connection Configuration Tool - Metasys - LIT-1201528 - General System Information - Metasys System - 10.1

Security Administrator System Technical Bulletin
Product
Building Automation Systems > Building Automation Systems > Metasys System
Document type
Technical Bulletin
Document number
LIT-1201528
Version
10.1
Revision date
2020-01-21

The Database Connection Configuration Tool (DBCCT) is used to synchronize the SQL server login accounts and passwords embedded in the connection strings used by the Metasys components to connect to their respective SQL Server hosted repositories. The synchronization is necessary when the SQL server accounts are modified in SQL server, typically for security reasons. While you can use different SQL Server login account names, we do not recommend this practice. Using different SQL Server login account names may break other work flows, such as Metasys upgrades. The Metasys system is not tested with modified account names. Use the following workflow to change the accounts after installing the Metasys server.

Note: The ADS uses non-interfering SQL Login accounts and Windows services. Stop the ADS services for the ADS version of DBCCT.
  1. Stop the required Metasys services.
  2. Run the DBCCT to update the database connection strings of the components that use the modified accounts.
  3. In the SQL Server Management Studio, modify the password of the desired SQL Server login accounts.
  4. Reboot the server to restart the system.

See Using the DBCCT for more information about Steps 2 and 3.