Cisco Cisco TelePresence Management Suite (TMS) Version 15 Maintenance Manual
Troubleshooting the Cisco TMS components
Cisco TMS Administrator Guide
Page 35 of 37
5. Click Ok.
6. Click Delete Files.
7. Select all check boxes.
8. Click Ok.
9. Click Ok.
10. Click Ok.
Remove old or duplicate Java clients from Internet Explorer.
1. Click
Tools
in the Internet Explorer menu
2. Click the
Programs
tab
3. Click
Manage Add-ons
4. Disable all old or duplicate Java plug-ins
Remove Google Desktop. We have seen issues where Google Desktop is conflicting with the
Java plug-in and significantly increasing the loading time of Java applets. Other desktop search
engines such as MSN Search do not produce the same symptoms.
Java plug-in and significantly increasing the loading time of Java applets. Other desktop search
engines such as MSN Search do not produce the same symptoms.
If using Java Runtime Environment (JRE) version 6, update 15 or later, you will need to de-select
Enable the next generation Java plug-in… under
Enable the next generation Java plug-in… under
Advanced
on the Java Control Panel to
make the Graphic and Map Monitor work as expected.
The database
The database is where all information in use by Cisco TMS is stored except software files for system
upgrade and the services’ log files. The database is called tmsng and can run on SQL 2005 or 2008
servers. During the installation of Cisco TMS you must specify an sa account password to create and
access the database. A different account can be specified by choosing the Custom installation. The
account used to run and upgrade Cisco TMS must have db_owner permissions to the tmsng
database, while a user that also has access to master.mdf is required for creating the tmsng database
the first time.
upgrade and the services’ log files. The database is called tmsng and can run on SQL 2005 or 2008
servers. During the installation of Cisco TMS you must specify an sa account password to create and
access the database. A different account can be specified by choosing the Custom installation. The
account used to run and upgrade Cisco TMS must have db_owner permissions to the tmsng
database, while a user that also has access to master.mdf is required for creating the tmsng database
the first time.
Symptoms
Cisco TMS does not load and/or you get a stack trace error stating that the SQL server is unavailable:
SQL Server does not exist or access denied is displayed
SQL Server does not exist or access denied is displayed
How to fix
Make sure that the SQL server is running. This can be done by checking the SQL agent of the
server, or going into services and verify that the MSSQLSERVER service is running.
server, or going into services and verify that the MSSQLSERVER service is running.
Run an osql script towards the database and see if it returns any data. This script will return the
number of systems in the Cisco TMS database:
•
number of systems in the Cisco TMS database:
•
Depending on the SQL configuration, run one of the commands below from the Cisco TMS
server itself.
•
server itself.
•
osql -E -d tmsng -Q "select count(*) from objsystem"
•
osql -E -S .\SQLTMS -d tmsng -Q "select count(*) from objsystem"
Verify that the information Cisco TMS uses to connect to the database is correct. This information
was historically only stored in the registry, but is now also stored encrypted in the web.config file.
It is therefore recommended to use the Cisco TMS Tools application, found under Cisco
TelePresence Management Suite in the Start menu of the Cisco TMS server, to change and verify
this information.
was historically only stored in the registry, but is now also stored encrypted in the web.config file.
It is therefore recommended to use the Cisco TMS Tools application, found under Cisco
TelePresence Management Suite in the Start menu of the Cisco TMS server, to change and verify
this information.