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.
- Stop the required Metasys services.
- Run the DBCCT to update the database connection strings of the components that use the modified accounts.
- In the SQL Server Management Studio, modify the password of the desired SQL Server login accounts.
- Reboot the server to restart the system.
See Using the DBCCT for more information about Steps 2 and 3.