TMS Installation Fails with due to failure of Microsoft SQL 2008 installation

Introduction

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.

Background Information

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:

Problem

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.

Cause

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.

Solution

Complete these steps in order to fix the issue:

1. 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.
   
   
2. Delete the Microsoft SQL server folder under C:\Program Files (x86).
   
   
3. Reboot the System.
   
   
4. 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

   
   
   

   

   
   
   
5. Double-click Debug programs.
   
   

   

   
   
   
6. Click Add User or Group and select the user who performs the installation.
   
   

   

   
   
   
7. Click Apply.
   
   

   

   
   
   
8. Reboot the system and run TMS installer again. This time, your installation should be succesful.