After installing TMS and logging into the webpage, my account only has user rights

[Brandon Williams]

I just migrated TMS from an appliance to a VM.  After install, I go to http://localhost/tms/ in order to confirm all of my information is present and I notice that my account only has user rights.  In the appliance, where I migrated the database that I restored TMS on the VM from, I have Site Administrator (Access to Everything) rights.  I have had a few other users log into the new TMS from their site admin accounts and they get the same basic user access.  All we can see is the booking tab.  Does anybody have any tricks or documentation they can point me to where I can somehow escalate my user rights outside of the web GUI? 

Note:  Our accounts are Microsoft user accounts that are authenticated against Active Directory.  We also have a few user accounts that are TMS only with site admin access that we could not log into.  We have no problem logging into our appliance with none of the accounts.

[Patrick Sparkman]

If you copied the database from one SQL server to another, I'm not sure how the TMS permissions got messed up, but it can be fixed if you can access the database and run a few queries with SQL Server Management Studio or similar program.

The Query below will allow you to put an individual into the Site Administrator group in TMS:

• EMAIL_ADDRESS is the email address of the user you want to update.
• TMS_ID is the Id assigned by TMS to the user within the AclUser table.

SELECT * FROM AclUser WHERE EmailAddress = 'EMAIL_ADDRESS';
UPDATE AclUserGroup SET AclGroup_Id = '1' WHERE AclUser_Id = 'TMS_ID';

Also, if you changed the name of the server hostname, you will need to update the hostname within TMS.  To do this, you use TMS Tools located under Start > Programs > Cisco TelePresence Management Suite.  This will update the hostname for any local account within TMS, and doesn't affect domain accounts.