Prerequisites -> SQL Express 2008 -> BUG?

[mike1983]

I tried to install the SQL 2008 Express via the Prerequisite of IS2010 PRO.
When the INSTANCENAME is default (SQLEXPRESS) everything is ok,
but... When I used a different name I received an error Installation failed

Is this a SQLExpress bug?

[hidenori]

The built-in Microsoft SQL 2008 Express prerequisite is designed to install the default instance, SQLEXPRESS. If you want to install other instance, you need to change the condition of the prerequisite using the Prerequisite Editor in order to check if the desired instance is installed successfully.

Hope that helps.

[bigdavelamb]

Mike

This is what I am doing at the moment, on the Installshield menu:

Application Data > Prequisites , Right click on the SQL Express prerequisite and Select 'Prequisite Editor' then select 'Application to run tab' on the specify the command line text paste in something like:

/qs /ACTION=Install /FEATURES=SQLENGINE /INSTANCENAME=INSTANCENAME /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /NPENABLED=1 /TCPENABLED=1 /ADDCURRENTUSERASSQLADMIN="True" /INDICATEPROGRESS

Replace the bit above 'INSTANCENAME' with whatever name you wish to call the instance.

You can specify loads of different parameters for installing SQL Express, have a look at this guide: http://msdn.microsoft.com/en-us/library/ms144259.aspx

Regards,
David

[mike1983]

🙂 thanks!