Upgrade of SQL Express 2005 Failed to install SQL Express BKUPEXEC instance with error 28115 in the installation log

Article:TECH51948  |  Created: 2007-01-11  |  Updated: 2014-04-15  |  Article URL http://www.symantec.com/docs/TECH51948
Article Type
Technical Solution

Product(s)

Issue



An upgrade of SQL Express 2005 fails with: "Failed to install SQL Express BKUPEXEC instance with error 28115" in the installation log.


Error



Failed to install SQL Express BKUPEXEC instance with error 28115
 

When upgrading SQL Express 2005, the first node in the cluster upgrades successfully, however, attempts to upgrade the second node fail with the error below: (Figure 1)
 
The Symantec Backup Exec 11d for Windows Servers upgrade process is not complete.
 
The BKUPEXEC SQL server instance did not install properly. Refer to the Backup Exec setup log file for information on the SQL Express installation failure.
 
Figure 1
 
 
 

 
The following error message appears in bkupinst.log:
 
   09-15-2006,21:01:14 : ERROR: Failed to install SQL Express BKUPEXEC
 
instance with error 28115. ***To search for information about this error, click here
 
09-15-2006,21:01:14 : Please review C:\Program Files\Microsoft SQL Server\90
 
\Setup Bootstrap\LOG\Summary.txt for more details.
 
09-15-2006,21:01:15 : Using INI File: C:\WINDOWS\Installer\clusconfig.xml
 

 
Event Viewer and the SQL logs show the following error:
 
Event Type:       Error
 
Event Source:    MsiInstaller
 
Event Category: None
 

 
Event ID:           10005
 
Date:                9/15/2006
 
Time:                9:01:03 PM
 
User:                HRO\Administrator
 
Computer:         ENGIT23
 

 
Description:
 
Product: Microsoft SQL Server 2005 Express Edition -- Error 28115.
 
UpgradeAdvisor blocked Upgrade.
 

 
Message:
 
Database Engine
 
-ExecuteReader requires an open and available Connection. The connection''s
 
current state is closed.
 



 

SQL Express 2005 installation log shows the following error:



--------------------------------------------------------------------------------

Machine         : ENGIT23
Product         : Microsoft SQL Server 2005 Express Edition
Product Version : 9.1.2047.00
Install         : Failed
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_ENGIT23_SQL.log

Last Action     : ValidateUpgrade
Error String    : UpgradeAdvisor blocked Upgrade.
Message:
Database Engine
-ExecuteReader requires an open and available Connection. The connection''s current state is closed.

Error Number    : 28115


Solution



1. Open regedt32 and edit the registry key:

HKLM\\Software\Microsoft\Windows\CurrentVersion\Uninstall\{E09B48B5-E141-427A-
AB0C-D3605127224A}|SystemComponent (Figure 2)

Figure 2

 

Change the value of SystemComponent from 1 to 0. This displays Microsoft SQL Server Desktop Engine (MSDE) again in Add/Remove programs.

Note: The GUID may not always be the same. Therefore, to ensure that you are editing correct the registry key, check the value of Display Name, which should be Microsoft SQL Server Desktop Engine (BKUPEXEC)

2. After editing the registry, refresh Add/Remove programs to see SQL MSDE again.

3. Uninstall MSDE.

4. Run a repair on Backup Exec through Add/Remove programs with only the Disk resource online, in the cluster on the affected node.

 
Warning: Incorrect use of the Windows registry editor may prevent the operating system from functioning properly. Great care should be taken when making changes to a Windows registry. Registry modifications should only be carried-out by persons experienced in the use of the registry editor application. It is recommended that a complete backup of the registry and workstation be made prior to making any registry changes. 

Supplemental Materials

SourceError Code
Value28115
Description

Failed to install SQL Express BKUPEXEC instance


SourceETrack
Value799868
Description

IT: Upgrade: SQL upgrade fails with ERROR: Failed to install SQL Express BKUPEXEC instance with error 28115.


SourceEvent ID
Value10005
Description

Product: Microsoft SQL Server 2005 Express Edition -- Error 28115. UpgradeAdvisor blocked Upgrade.




Legacy ID



289045


Article URL http://www.symantec.com/docs/TECH51948


Terms of use for this information are found in Legal Notices