Cisco Cisco TelePresence Management Suite (TMS) Version 15 Installation Guide
Product
Version
Additional notes
SQL Server
Browser
Browser
Must be running when using a named instance on a separate server for the
database.
database.
Configuration and permissions
The default SQL language must be set to English.
Authentication modes
For installation and upgrading, SQL Server and Windows Authentication mode (mixed mode) must be
enabled on the database server.
enabled on the database server.
After installation is completed, mixed mode can be disabled and Windows Authentication enabled until the
subsequent upgrade.
subsequent upgrade.
or the web help.
User and database creation
When installing or upgrading Cisco TMS and using an existing SQL Server, the installer prompts for a SQL
database user and password. The default is to enter the server sa (system administrator) username and
password.
database user and password. The default is to enter the server sa (system administrator) username and
password.
If the sa account is not available, use one of the following:
n
Use automatic setup, but with security limited role.
a. Ask your SQL server administrator to create an SQL user and login that has the dbcreator and
securityadmin server roles.
This account will be the service account for Cisco TMS.
This account will be the service account for Cisco TMS.
b. When prompted for SQL Server credentials during installation, enter the username and password for
that account.
Cisco TMS will create the tmsng database automatically using the server defaults, assign itself as
the owner and continue to use the supplied account to access the database after installation.
Cisco TMS will create the tmsng database automatically using the server defaults, assign itself as
the owner and continue to use the supplied account to access the database after installation.
n
Ask your SQL server administrator to manually create the database with a maximum security limited user
role:
role:
l
A database named tmsng with database collation Latin1_General_CI_AI (case insensitive and accent
insensitive).
insensitive).
l
An SQL user and login to use for the Cisco TMS Service account and grant the user the dbowner role for
the tmsng database. This permission must be kept after installation for Cisco TMS to function.
the tmsng database. This permission must be kept after installation for Cisco TMS to function.
Snapshot isolation
The following snapshot isolation settings are configured automatically for tmsng by the installer, and must
remain set as follows:
remain set as follows:
n
ALLOW_SNAPSHOT_ISOLATION must be set to ON
n
READ_COMMITTED_SNAPSHOT must be set to OFF
Client software requirements
All users including administrators access Cisco TMS using the web interface.
Cisco TelePresence Management Suite Installation and Upgrade Guide (14.5)
Page 11 of 56
Prerequisites