If you have an old version of TMS (13.0) running on an unsupported Windows Server 2003, here is a very extensive procedure to upgrade it to TMS version 13.2, do Database recovery, restore and conversion, and migration to a new Windows 2012 R2 system running on SQL Server Express 2012. The final step was to upgrade to the TMS version 14.6.
First big issue I ran into was the 2008 SQL Express server “SA” password provided by the previous SQL Administrator was incorrect. The numerous attempts to access the database server locked up the account and the SQL service couldn’t be started from SQL Server Configuration manager. Even if you go to Control Panel and Services, manually start the SQL service, it doesn’t start.
error code 17058 appears from the Event Logs and also look into SQL logs to get more information on the cause of the SQL service not able to start. It revealed that it went through the proper startup procedures and during the last step, there was a message that the supplied account login to the database failed.
First, you have to fix the SQL service startup issue to even be able to do anything.
You need to login as a user with admin rights on the Server. Open SQL Server Configuration Manager ==> click on SQL Server Services ==> then right click on SQL Server ==> choose Properties. A Window show below will appear:
Under the Logon tab, the SQL service was previously configured for “Network Service” which failed to start the SQL service. Under “Built-in Account”, choose “Local System”. You will need to know the local system account username and password. Provide the local user name and password. Now start the service manually and it should work fine.
SQL SA Password Reset and Recovery
Now that SQL service has started, next step is to reset the DB server SA account password. Do the following from the MS-DOS prompt (provide a Strong SA Password):
Make TMS Connect to the TMSNG Database
After changing the SA password, you can either use TMS Tools to reconnect TMS to the DB again or since I needed to upgrade to TMS 13.2, I went ahead and ran the install of TMS 13.2. This is the last version of TMS that supports Windows server 2003. The install will ask for your DB connection settings and this is where you enter the new SQL SA password. After the installation is complete, verify TMS functionality by pulling it up from a Web Browser.
Install TMS Provisioning Extension (TMSPE)
If you are using TMS agent legacy, we need to install TMS Provisioning Extension (TMSPE) in TMS 13.2. TMSPE is required when moving up to the 14.x versions of TMS. Without TMSPE, TMS 14.x install will fail during the install procedure. This will also require a Java Runtime Environment upgrade to at least Java 6 build 33. For more info, please go to Cisco’s Website and see the TMSPE Installation guide.
- Download Java from Oracle site and Install.
- Run the TMSPE Installation.
- After Installation is complete, check the option to run the “Migration Tool” to build the database for Provisioning Extension.
Performing the installation and migration
- Close all open applications and disable virus scanning software.
- Extract the Cisco TMSPE installer from the zip archive to the Cisco TMS server.
- Run the Cisco TMSPE installer.
- Follow the setup instructions:
a.Click Next to initiate the setup.
- Accept the terms in the license agreement and click Next.
- Enter the Username and Password of the user that Cisco TMSPE will use to connect to Cisco TMS. This user must be a member of the Site Administrators group in Cisco TMS. Click Next.
- The installer detects where the TMS SQL database (tmsng) is installed. We recommend installing the Cisco TMSPE SQL database (tmspe) to the same location and instance.
- Confirm or enter the appropriate SQL Server Name and Instance Name. If deploying in a redundant setup, make sure both installations are pointing to the same database location. ii.
- Fill in the necessary credentials.
- Click Next.
- Click Install to begin the installation. Click Back to review or change installation settings.
- When the installation is complete, check Run Migration Tool and click Finish to exit the Setup window. The Migration Tool window opens.
Click Start Migration. Depending on the size of the database, the migration process may take several minutes to complete. When the migration process is complete, the Migration Tool window displays the
results of the migration and provides a migration log.
Enabling Cisco TMSPE
After completing the installation:
- In Cisco TMS, go to Administrative Tools > Configurations > General Settings, set the field Provisioning Mode to Provisioning Extension and click Save. You may need to refresh the browser window or empty the browser cache after making this selection.
- Go to Administrative Tools > Activity Status to verify that the switch is completed.
- Verify that Cisco TMSPE features are now available and functioning.
- Browse to the following pages in Cisco TMS: Systems > Provisioning > Users. If this page reports a problem connecting to User Repository, the database connection is not working.
Systems > Provisioning > FindMe
Systems > Provisioning > Devices
Administrative Tools > Configuration > Provisioning Extension Settings
Go to Administrative Tools > Provisioning Extension Diagnostics, look for any alarms raised and click Run Health Check. If any alarms are raised, click them to see details and perform the corrective actions described. See Troubleshooting the installation [p.71] for further information.
- When browsing to all of the above Cisco TMSPE pages is successful and no alarms are reported in Provisioning Extension Diagnostics
Perform TMS Database backup
You will now notice that the TMS Database size has doubled. This is because of the Provisioning Extension install. It’s now time to backup this database. The easiest way is by command line:
You will now find the DB backup file in this directory: C:\Program Files\Microsoft SQL Server\MSSQL10.SQLTMS\MSSQL\Backup
New 2012 R1 Server Buildout
Size the server hardware by checking Cisco’s deployment guide first. Here are the software requirements to install before installing TMS 14.6:
- .NET framework 3.5 Full (extended)
- .NET framework 4.5.0 Full (extended)
- Microsoft IIS for Windows Server 2012 R2: IIS 8.5
- Apply windows updates
- Microsoft SQL Server 2012 Express Edition (free) if installing a small deployment size of less than 200 endpoints/vtc systems. The install includes SQL Management Studio.
Once SQL server express is installed, do a database restore from the TMS backup file using SQL Management Studio. The db import will do the conversion to SQL 2012 structure.
Once Database is created, you can now run the TMS 14.6 installation.
Creating or upgrading the database
- If the installer does not find an existing Cisco TMS database, but locates a local installation of SQL Server, enter the username and password to allow the installer to create a new database. Click Next.
- If using an external SQL Server, which is required for large deployments, enter all connection details. Click Next.
- If the installer finds an existing Cisco TMS database, the dialog will be pre-populated with the previously specified SQL Server. When prompted, enter the username and password and click Next.
- Click Yes to upgrade the existing database to the current version and retain the existing information.
- We recommend that you back up the database before it is upgraded using the appropriate tools.
- If clicking No, you must proceed to stop the installer and manually remove the database if you wish to use the same SQL Server, before you can install a new Cisco TMS database.
Adding release keys and pre-configuring the network settings
The Release and Option Keys dialog is now displayed, and any existing keys are shown if upgrading.
- A new release key is required if performing a new installation or upgrading to a new major release. If no release key is entered, an evaluation version of Cisco TMS will be installed. This includes support for three systems.
- Option keys enable additional systems, extensions, or features. They may also be added post installation by going to Administrative Tools > Configuration > General Settings.
- For questions regarding release or option keys, contact your Cisco Reseller or Cisco Support.
- Enter the release key if necessary.
- The release key must be entered before adding option keys.
- Enter each option key, then click Add Option.
- Option keys are validated as they are added.
- When done adding keys, click Next.
- The Network Settings screen is displayed.
You can now pre-configure default settings to allow Cisco TMS to immediately start working with a basic network configuration. The settings can be changed after installation.
If upgrading, values from the existing database are displayed.
These should be the major install steps and just follow through the wizard until the install is complete.
Make sure you enable SNMP service. It is disabled by default for new installations of TMS.
Access Cisco TMS for the first time.
Test all General Functionalities.