View Full Version : Determine if the SQL Server 2008 R2 Express SP2 prerequisite completed successfully

10-21-2013, 12:31 PM

I'm trying to use the SQL Server 2008 R2 Express SP2 (x86) prerequisite and it appears to install successfully but after the prerequisite setup completes I get a message that says:

"The installation of the Microsoft SQL Server 2008 R2 Express SP2 (x86) appears to have failed. Do you want to continue the installation?"

I've used some other prerequisites before and I don't get this message. I've reviewed the SQL Server setup logs on the machine and I can't find any errors logged by the setup.

How does IS determine if the prerequisite has completed successfully?

The command line in the SQL Server 2008 R2 Express SP2 (x86) prerequisite is:


Is there something I'm missing?


10-21-2013, 01:28 PM
Make sure that you have updated the registry condition of the prerequisite to test the TESTINST instance installed successfully. The original condition is designed to test the default named instance called SQLEXPRESS.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLEXPRESS\MSSQLServer\CurrentVersion

Change to:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\TESTINST\MSSQLServer\CurrentVersion

Hope that helps.

10-21-2013, 03:39 PM
Hi Hidenori,

You are a genius! That did it. My SQL Server Express installed and then my setup started just like I want. :)

On a somewhat related topic, do you know if it's possible to control the inclusion of the SQL Server 2008 R2 Express SP2 (x86) prerequisite programatically? I have a program that uses the IS COM interface to programatically turn on and off different features in the application before I actually do a build and I'd like to have the same control over the SQL Server 2008 R2 Express SP2 (x86) prerequisite. I haven't been able to find anything in the documentation about this. Is that even supported? Oh and my IS project is an IS InstallScript project type.