This entry applies to the following:
- Moving the TMCM database from one Microsoft SQL server to another.
- Importing a TMCM database to the SQL server and configuring TMCM to use the new database.
- Changing the TMCM database name.
- Changing the username and/or password of the account that the TMCM server uses.
Do the following:
- Configure TMCM to use a different database.
This includes the following:
- Using the same database, but on a different SQL server
- Using a different database on the same SQL server
- Using a different database on a different SQL server
- If you are moving the TMCM database to another SQL server, then follow the steps in this article:
- Set an account to be part of the DBO scheme for the TMCM database.
It is possible that while moving to another server, the account associated with DBO is no longer available.
Make sure to set the following permissions:
- Mixed-mode and Windows authentication
- The SQL account assigned for TMCM should have:
- dbcreator permission for the server role is needed during installation
- Db_owner permission and DBO user account for the database role to the db_controlmanager database
- Make sure that the latest TMCM patch is installed.
- Open a command prompt.
- Change the directory to the ..\Control Manager\Dbconfig folder.
- Run the Dbconfig.exe tool.
Usage: DBConfig [options]
Use this tool to modify the database settings.
- DBName="database name" database name.
- DBAccount="database account" database account.
- DBPassword="database password" database password.
- Mode="SQL" authentication mode. SQL or WA.
- DBHost="ip address/hostname" database ip address/hostname.
- Owner change owner to dbo.
DBConfig -DBName="db" -DBAccount="sqlAct" -DBPassword="sqlPwd" -Mode="SQL" -DBHost="10.1.152.124"
DBConfig -DBName="db" -DBAccount="winAct" -DBPassword="winPwd" -Mode="WA" -DBHost="(local)"
DBConfig -DBName="db" -DBAccount="sqlAct" -DBPassword="sqlPwd" -Mode="SQL" -DBHost="(local)\SQLEXPRESS"
- Default Mode is the SQL authentication mode. Mode="WA" is necessary when configuring for Windows authentication.
- TMCM 3.5 only has SQL authentication.
- Windows account must belong to Administrators group.
- Change the username and/or password of the account that TMCM uses to access the database.
- Set a DBO account for the TMCM database.
- If you will use a new account, and will use "Windows Authentication" for SQL Login, make sure that the Windows account is a member of the built-in Local Administrators group. "Log on as a Service" and "Log on as a Batch Job" user rights are also needed. These are set in Step 3.
- Use the DBConfig tool to configure the new username and password.
DBConfig -DBName="db" -DBAccount="sqlAct" -DBPassword="sqlPwd" -Mode="SQL"
- This action/step will change the connection strings in ASP.net to local.
- Make sure to specify the DBO account associated with the database when using the DBConfig tool.
- The DBConfig tool is case-sensitive. Make sure to follow the parameter and values exactly.
- Make sure that DBName is specified as DBName, not "dbname". Also, if the database name on the SQL server is db_ControlManager, it should be specified as db_ControlManager, not "db_controlmanager".