Install from C# Setup Project

Question

I am trying to run sql server 2008 setup from a C# Visual Studio Setup project. One of the C# setup actions is to run a C# winforms project which installs SQL server but I am encountering errors. I think it might be due to the MS Installer being run to install the SQL Server as part of it's setup.

Here are there errors I am receiving. Does anyone have any idea how to work around this?

Running Action: MsiTimingAction
----------------------------------------------------------------------
Running Action: Install_sql_engine_core_shared_Cpu32_Action
Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
Sco: Attempting to open registry subkey
Sco: Attempting to open registry subkey SOFTWARE\Microsoft\VisualStudio\9.0
Sco: Attempting to get registry value InstallDir
Target package: "C:\Documents and Settings\me\Local Settings\Temp\S
QLEXPRESS2008\x86\setup\sql_engine_core_shared_msi\sql_engine_core_shared.msi"
InstallPackage: MsiInstallProduct returned the result code 1618.
Watson Bucket 1
 Original Parameter Values

Parameter 0 : 10.0.2531.0

Parameter 1 : 10.0.1600.22

Parameter 2 : sql_engine_core_shared.msi

Parameter 3 : 0x2D2816FE

Parameter 4 : 0x1618

Parameter 5 : Install_sql_engine_core_shared

 Final Parameter Values

Parameter 0 : 10.0.2531.0

Parameter 1 : 10.0.1600.22

Parameter 2 : sql_engine_core_shared.msi

Parameter 3 : 0x2D2816FE

Parameter 4 : 0x1618

Parameter 5 : Install_sql_engine_core_shared

Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Serv
er to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\2009050
4_083326\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVer
sion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap
\Log\20090504_083326\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstal
l.reg_
Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to fil
e C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090504_083326\
Registry_SOFTWARE_Microsoft_MSSQLServer.reg_

Watson bucket for Msi based failure has been created
Retry-able MSI return code detected: 1618
Sleep 120 seconds before retry attempt.....

Answer 1

Hi,

 

Am also facing the same issue, even am doing the same thing what stumple was doing (adding sql setup as custom action to an MSI)

here is the error am getting

Slp: ----------------------------------------------------------------------

Slp: Running Action: MsiTimingAction

Slp: ----------------------------------------------------------------------

Running Action: Install_SqlSupport_Cpu32_Action

Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine 

Slp: Sco: Attempting to open registry subkey 

Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\VisualStudio\9.0

Slp: Target package: "d:\bdba8adefe4dabd751c476a40463\PCUSOURCE\x86\setup\1033\SqlSupport.msi"

Slp: InstallPackage: MsiInstallProduct returned the result code 1618.

Slp: Watson Bucket 1 

Original Parameter Values 

 

Slp: Parameter 0 : 10.0.2531.0 

 

Slp: Parameter 1 : 10.1.2531.0 

 

Slp: Parameter 2 : SqlSupport.msi 

Slp: Parameter 3 : 0x2D2816FE 

Slp: Parameter 4 : 0x1618 

Slp: Parameter 5 : Install_SqlSupport 

 

Slp: 

 Final Parameter Values 

 

Slp: Parameter 0 : 10.0.2531.0 

 

Slp: Parameter 1 : 10.1.2531.0 

 

Slp: Parameter 2 : SqlSupport.msi 

 

Slp: Parameter 3 : 0x2D2816FE 

 

Slp: Parameter 4 : 0x1618 

 

Slp: Parameter 5 : Install_SqlSupport 

 

Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file c:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20110602_102836\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_

Slp: Sco: Unable to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file c:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20110602_102836\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_, Win32 error 2

Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file c:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20110602_102836\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_

Slp: Watson Bucket 2 

and so on.......... up to

Spl:Watson Bucket 2044

 

Can anyone help me on this, its very urgent, already i have spent 3 days trying to rectify this error.

---

Please mark the post as answer if it is helpfull to you - Hiran Repakula

Answer 2

Hi,

 

I don't remember exactly what I did since this was over a year ago. I think the problem is that when you are inside of an installer you can not launch another installer. Just try doing this with two installs. Launch the first and then launch a second. You will get some sort of error saying that another installer is running. Now, I do not know this to be the answer but I moved on and made my winforms project a stand alone.  Since I have a custom installer then I just call this file to install it.

 

This option may not be available to you so here is something else I did. I made the sql install a pre-requisite. There is a tool out there somewhere that helps you make custom pre-requisites. For this you have to use the setup.exe part of your installer though. Look around and you will find the program on the forums.