Cisco Cisco TelePresence Management Suite (TMS) Version 15 Maintenance Manual
Configuration
Database Connection Settings
This is where you specify the location of the Cisco TMS or Cisco TelePresence Management Suite
Provisioning Extension (Cisco TMSPE) SQL databases, and the credentials Cisco TMS uses to connect to
them.
Provisioning Extension (Cisco TMSPE) SQL databases, and the credentials Cisco TMS uses to connect to
them.
Cisco TMS Database Connection
Prerequisites for Windows Authentication and the Cisco TMS database
If you intend to use Windows Authentication, ensure that the following accounts have db_owner rights to
the database before you edit the Cisco TMS database settings:
the database before you edit the Cisco TMS database settings:
n
The account you use to log into the Cisco TMS server.
n
The account that the TMS services log on as.
n
The IIS AppPool account.
Before selecting Windows Authentication in Cisco TMS Tools, complete the following steps for Cisco
TMS to use Windows authentication towards the SQL database:
TMS to use Windows authentication towards the SQL database:
1. Create a new Active Directory service account, for example tms-databaseservice.
2. In SQL Server, create a new login for tms-databaseservice.
3. In SQL Server, create a new user for the tmsng database.
a. Associate the user with the tms-databaseservice login.
b. Assign the user db_owner permissions.
b. Assign the user db_owner permissions.
4. In SQL Server, create a new login for the user account that runs Cisco TMS’s IIS App pool.
The default account is IIS APPPOOL\TMSNet40AppPool.
You can verify which user account Cisco TMS’s IIS App pool runs under by opening its log-web file;the
first entry will contain the Cisco TMS version number followed by the user account in brackets.
You can verify which user account Cisco TMS’s IIS App pool runs under by opening its log-web file;the
first entry will contain the Cisco TMS version number followed by the user account in brackets.
5. In SQL Server, create a new user for the tmsng database.
a. Associate the user with the login you created in step 4 above.
b. Assign the user db_owner permissions.
b. Assign the user db_owner permissions.
6. Change all six TMS services so that they log on as tms-databaseservice, and restart them.
7. Restart IIS.
You can now disable SQL Server authentication in SQL Server, so that it uses Windows Authentication only.
Note: You must re-enable SQL authentication in SQL server, if you chose to disable it, and set authentication
back to SQL in Cisco TMS Tools before upgrading Cisco TMS.
back to SQL in Cisco TMS Tools before upgrading Cisco TMS.
Cisco TelePresence Management Suite Administrator Guide (14.4)
Page 297 of 331
Cisco TMS Tools
Configuration