You just need to specify the SQL address, and account details that has access to the tmsng database. No need to enter the tmsng database name, as the installer is hardcoded to use this database name.
successfully migrated TMS and the database to new servers last night. The installation of TMS15.6.1 on the new Windows Server 2016 was simple. The only thing you need to specify is the new database server's DNS name or IP address (migrate the TMS database to the new SQL server 2016 before installing TMS15.6.1 on the new server), and the service account and password used for TMS to talk to the database server. the rest information is auto-populated (Release key, options keys, server settings, email settings, etc.) as it is stored in the database. You do need to manually enter the Encryption key ( you can copy the key from the old TMS server using the TMS Tools).
I run into a problem during testing. I couldn't book video conference in Outlook (booking in TMS directly worked but not in Outlook). Logged into TMSXE server and checked the TMS connection details using the TMSXE Configuration tool. I got an error "Cannot connect to Cisco TMS using the details below" (I confirmed that the TMS server address, username, password and domain were correct). After some checking, I unchecked "Use HTTP" under the Cisco TMS tab on TMSXE Configuration and then saved again. It worked, and I was able to schedule video conference in Outlook. I still don't know why I need to uncheck that checkbox for TMSXE to connect to TMS.
yes, I can access TMS using HTTP and HTTPS. We use a self-signed cert issued by TMS itself for HTTPS connection. Communication Security is set up Medium.
so I guess TMSXE couldn't reach the new TMS server through HTTPS when I run into the problem? I unchecked Use HTTP under Cisco TMS using TMSXE Configuration, which resolved the issue. what I need to do to make HTTPS works between TMSXE and TMS?
...what I need to do to make HTTPS works between TMSXE and TMS?
According to your description, you unchecked "Use HTTP", which means communication between TMS and TMSXE is using HTTPS. So, it is working like you want, it is using HTTPS.
If you really mean why can't it use HTTP, I'm not sure to be honest, did you include the protocol http in front of the server address, as this should be left off.
Yes, you are right, To correct. got the following error when "Use HTTP" was checked.
After unchecked the checkbox and resaved, it started working.
Under Server Address, I use the FQDN of the TMS server. I also tried IP address of TMS and it didn't work either. Not sure why HTTP doesn't work.
I'm about to do the migration, and Cisco recommend me to upgrade upgrade the SQL to 2016, but keeping the version 15.4 once is completed, then upgrade to 15.6, the password for the sa user, should be the same as the actual database has.
thanks for this useful topic. we will soon be moving our TMS and TMSPE from 2012 to 2016 server. it has a separate SQL server. Unfortunately I cannot use the same hostname for the new server, I can use the same IP range. Where do I have to take care when i'm using another hostname?