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

Problem

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

Error Message

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. 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)