Step 1 - Set up a Service Account for Cisco TMS SQL Server Database
The service account required will be added to the appliance’s SQL Database with read-only privileges. You must determine where the appliance’s SQL Server Database is located in your environment; whether it is on the TMS appliance or located on a separate SQL server. Once this has been identified, you will require an Administrator account to the server to add the required service account. This may require the assistance of a SQL Server Administrator in your organization to provide server access or to add the account manually.
For all instances where the TMS SQL databases are hosted on a separate SQL Server please consult with your organization’s SQL Server DBA to create the required database read-only account.
There are two ways to identify where your TMS database are located:
1. RDP to the TMS server as an administrator and run the ‘TMS Tools’ application configuration utility from Start > Programs > Cisco TelePresence Management Suite. Please note that this is the recommended option as it highlights the connection port.
2. Log in to the TMS Web UI as an administrator and navigate to Administrative Tools > TMS Server Maintenance. Click on ‘Database Files and Size Info’ to view the database server in use. If the database server is ‘(local)\SQLTMS’ then your database resides on the actual TMS server. Your database could also use the name of the actual server, e.g. ‘TMSPROD\SQLTMS’. If the server name matches your TMS server then your database resides on the TMS server.
The read-only database account should be titled vyopta_svc which has the ‘db_datareader’ and ‘public’ roles as well as access to the ‘tmsng’ database. For SQL databases residing on the TMS server (atypical), please contact Support for assistance with the TMS Preparation Installer.
If you need assistance from support, please Submit a ticket
Note: You will need to make sure that you obtain the assigned password and also the appropriate TCP/IP port for database access. The default for this is 1433 but other ports can be configured.
Step 2 - Add a TMS Connector
To add a connector for Telepresence Management Suite (TMS) you will need to prepare by completing the following prerequisites:
- Confirm access to the FQDN/IP address of the server hosting the SQL Database from the Vyopta Data Collector.
- Obtain credentials for the Microsoft SQL Server Database Read-only Account.
- Identify whether a static or dynamic SQL port is used. (If dynamic, please identify and record the dynamic port value within Microsoft SQL Configuration Manager.)
- Verify that TCP/IP is enabled for the SQL Server within SQL Configuration Manager.
- Enter the infrastructure name and description of TMS. This will be the name displayed for the video device in CPM. This can include the device type, location, and other unique identifiers.
Note: We recommend using hostname rather than IP as IP addresses are subject to change. It is also helpful to name the infrastructure in a 'friendly' or easily understood way.
- Enter the Database Server Address (either hostname or IP address). If the SQL Server Instance Name is not the default name MSSQLSERVER, you will have to add the SQL Server Instance Name as a suffix to the Hostname or IP address as per below or specify the instance name in the field below.
<Device Hostname>\<SQL Server Instance Name>
- Enter the username and password created on the SQL Server.
- Leave the Database Server Port Number and Name blank, it will use the default port numbers. If you have verified that the default port or database is not used, enter in the custom port number or database name.
- For Authentication, select either Database or Windows.
- Click Validate to ensure connectivity to the video device.
- If the connection to the video component succeeded, click the Save button.
Cisco TelePresence Management Suite (TMS) Reference Table
Cisco TelePresence Management Suite (TMS)
TMS version 13.2 or above
Server IP/FQDN that hosts the SQL ‘tmsng’ database
While the TMS application server can host the SQL database this is typically not implemented in an enterprise environment. Please consult with your organization’s DBA for more information.
Local DBA read-only user account that has access to the ‘tmsng’ database
Vyopta Data Collector outbound to the SQL databases
Note: Your SQL DBA may have set a separate TCP port other than the default. Please consult with your organization’s DBA for more information.
Please sign in to leave a comment.