cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
DKroll76
Pilgrim

Installing SQL Hangs

I have a basic msi project. I'm trying to install SQL Server 2012 Express from a custom action. I am calling the SQL setup and passing a bunch of command line parameters. During the install, it hangs at:

Invoking QueryServiceStatus Win32 API
Sco: Attempting to open SC Manager

I can run this manually from a command prompt and it works fine, but calling it from the custom action always gives this problem.

Any suggestions?
Labels (1)
Tags (2)
0 Kudos
16 Replies
PlinyElder
Pilgrim

Re: Installing SQL Hangs

What version of SQL are you installing?

Is it SQL Express?

I have successfully installed SQL Express 2008 r2 and SQL Express 2012 via installscript by using LaunchApplication()
0 Kudos
DKroll76
Pilgrim

Re: Installing SQL Hangs

Yes, SQL Express 2012. My project is a basic MSI project and I'm seeing that the problem is trying to launch SQL's MSI installer from an MSI installer and that's not supported. Have you installed SQL from within an MSI?
0 Kudos
PlinyElder
Pilgrim

Re: Installing SQL Hangs

Hmm, actually i am seeing this exact problem that you are with 2012. I forgot that when i had it working before it was as a prereq for SQL 2012.

Wonder why its breaking, works perfectly with 2008. More testing i guess
0 Kudos
DKroll76
Pilgrim

Re: Installing SQL Hangs

I read that starting with either 2008 or 2008 R2, MS changed the install to MSI based, that's why it doesn't work anymore. Thanks for your help!
0 Kudos
PlinyElder
Pilgrim

Re: Installing SQL Hangs

Any luck so far?
0 Kudos
DKroll76
Pilgrim

Re: Installing SQL Hangs

No. I'm thinking of just trying to use an Installscript project, that would allow me to run the SQL installer without having the MSI conflicts.
0 Kudos
PlinyElder
Pilgrim

Re: Installing SQL Hangs

Ive read it works fine with the Suite/Advanced UI project. If you are available to use that
0 Kudos
DKroll76
Pilgrim

Re: Installing SQL Hangs

If this doesn't work, I may have to check that out.
0 Kudos
DLee65
Pilgrim

Re: Installing SQL Hangs

You are correct about SQL Server 2012 Express. However if you can distribute SQL Server 2012 SP2, it should solve the problem but you have to add an extra command line parameter to skip checking install conditions.
The other solution, which I used, will be to use a Suite/Advanced UI installer to manage installing SQL Server 2012.

See my post here https://community.flexerasoftware.com/showthread.php?218500-SQL-Server-2012-prerequisite-fix
0 Kudos