Cisco Cisco TelePresence Management Suite (TMS) Version 15 Installation Guide
Prerequisites and recommendations
Cisco TMSPE Provisioning Deployment Guide
Page 9 of 88
Cisco TMS
Member of the Site Administrator group in Cisco TMS. We
recommend creating a service account for this purpose either
locally or in Active Directory.
recommend creating a service account for this purpose either
locally or in Active Directory.
Manually creating the database on the MS SQL server
If the Cisco TMS tmsng database is located on an external SQL server, the database administrator must do
the following prior to installation:
the following prior to installation:
n
Create an empty database tmspe in the same instance as tmsng.
n
Apply collation Latin1_General_CI_AS.
n
Create a user with the db_owner role for use during installation of Cisco TMSPE. The same user will be
utilized for operations.
utilized for operations.
Information needed during installation
Username and password
The Cisco TMSPE installer asks for the username and password of a user that belongs to the Site
Administrator group in Cisco TMS. These credentials will be used by Cisco TMSPE to request data from
Cisco TMS.
Administrator group in Cisco TMS. These credentials will be used by Cisco TMSPE to request data from
Cisco TMS.
The credentials will also be added to the corresponding fields in the Cisco TMS Connection settings, which
can be viewed and modified after installation by going to
can be viewed and modified after installation by going to
Administrative Tools > Configuration >
Provisioning Extension Settings
.
Database information
The installer detects where the Cisco TMSSQL database (tmsng) is located and recommends installing its
SQL db (tmspe) to the same location and instance. In this case, the administrator needs to know the
following about the tmsng database:
SQL db (tmspe) to the same location and instance. In this case, the administrator needs to know the
following about the tmsng database:
n
SQL server name
n
SQL server instance
n
SQL server credentials with adequate privileges
Database location
During installation, the installer offers the possibility of storing the tmspe database to another location and
instance. However, we recommend storing the tmspe database in the same location as the tmsng
database. Note that the database name must be tmspe in lowercase.
instance. However, we recommend storing the tmspe database in the same location as the tmsng
database. Note that the database name must be tmspe in lowercase.
If desired, the installer also offers the ability to use separate SQL credentials for tmspe to operate in. Select
Use separate SQL Credentials for the TMS Provisioning Extension during the installation to change
these credentials. See the
Use separate SQL Credentials for the TMS Provisioning Extension during the installation to change
these credentials. See the
section for appropriate operation permissions.