This document describes an error encountered when you install the Cisco TelePresence Management Suite (TMS) due to failure of installation of Structured Query Language (SQL) 2008. It also details how to troubleshoot this problem.
Cisco TelePresence Management Suite (TMS) stores all its customer data in its SQL database named tmsng. This self-contained storage allows for convenient backup and recovery of customer information.
For new installations, the installer creates tmsng with the SQL server defaults. Upgrades re-use a current Cisco TMS database.
SQL Server Version
One of these server versions is required:
TMS installation fails when you run the installer. In the installation phase when it runs the SQL installation, it halts in between with this error.
When you run the installer again, it detects the partially installed SQL and prompts you to input the sa password. But after you enter it, the error message appears again.
SQL 2008 installation logs can be found here: C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log.
When the installation halts, it creates a specific folder for the installation logs. In the folder, there is a file named detail.txt. When the installation fails for SQL, this error appears.
2014-11-09 06:29:55 Slp: Error result: -2068643839 2014-11-09 06:29:55 Slp: Result facility code: 1203 2014-11-09 06:29:55 Slp: Result error code: 1 2014-11-09 06:29:55 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_ MACHINE, machine 2014-11-09 06:29:55 Slp: Sco: Attempting to open registry subkey 2014-11-09 06:29:55 Slp: Sco: Attempting to open registry subkey Software\Microsoft\ PCHealth\ErrorReporting\DW\Installed 2014-11-09 06:29:55 Slp: Sco: Attempting to get registry value DW0200 2014-11-09 06:30:29 Slp: Submitted 1 of 1 failures to the Watson data repository 2014-11-09 06:30:38 Slp: Detected localization resources folder: 1033 2014-11-09 06:30:38 Slp: Detected localization resources folder: 1033
This error occurs because the user does not have full control of this registry key: HKLM\Software\Policies\Microsoft\Windows\Installer.
Complete these steps in order to fix the issue:
Uninstall the SQL Server 2008 R2. Go to the Control Panel, select the SQL Server 2008, right-click, and select Unistall. Follow this procedure for all SQL Components installed with the installation.
Delete the Microsoft SQL server folder under C:\Program Files (x86).
Reboot the System.
Once the system is up, add the user who performs the installation in this file:
Start | Run | Type: gpedit.msc | OK | Navigate to Computer Configuration\Windows Settings\Security Settings\Local Policies\User Rights Assignment\Debug programs
Double-click Debug programs.
Click Add User or Group and select the user who performs the installation.
Reboot the system and run TMS installer again. This time, your installation should be succesful.