Cisco Cisco TelePresence Management Suite (TMS) Version 15
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.
Best practices for deployment
Upgrade endpoints to the latest software
Prior to installation and deployment of Cisco TMSPE, we recommend upgrading all endpoints to the latest
software version available.
software version available.
This ensures that the configuration template schemas are compatible with Cisco TMSPE and limits the
number of templates and schemas to maintain post-installation.
number of templates and schemas to maintain post-installation.
Cisco TMSPE Provisioning Deployment Guide
Page 9 of 78
Prerequisites and recommendations
Information needed during installation