Single TEM Console connecting to multiple TEM Servers.
How do I connect to multiple TEM Servers from a single TEM Console?
Note: The steps in this article pertain only to TEM versions less than 8.2.
In order to connect to multiple TEM Servers from a single TEM Console, the following conditions must be met:
- You must have a database login for each TEM Server. If you do not have a login, you can create one using the TEM Admin Tool that is installed on the TEM Server computer.
- Your network must be configured to allow you to connect to each database using an ODBC connection.
- You must have an ODBC DSN for each of the TEM Servers.
- Go to Control Panel > Administrative Tools > Data Sources (ODBC)
- Under the User DSN (or System DSN) click the 'Add' button
- Choose 'SQL Server' from the list and hit 'Finish'
- Fill in the name field with 'bes_
' ( Note: the TEM Console will only recognize data source names that start with 'bes_')
- Choose the Server that has the TEM Server you wish to connect to (you can fill in the description or leave it blank) then click 'Next'
- Choose 'SQL Server authentication' and enter your 'Login ID' and 'Password' (this is the username and password created using the TEM Admin Tool) then click 'Next'
- Click the check box 'Change the default database to' and select 'BFEnterprise' then click 'Next'
- Click 'Next' again, then 'Finish', and then 'Test Data Source' to verify that everything is working properly
- Open the TEM Console and verify that you can connect to the TEM Server
For x64 Systems
**Note: The TEM Console uses 32-bit DSN's to determine how to connect with the database. On a 64-bit system you must configure the 32-bit DSNs rather than the 64-bit DSN's that can be reached via Administrative Tools.
In order to configure the 32-bit DSN's in the default setup, Run the following command: