0

I'm using Installshield 2008 express to create an installation package. My application relies on Sql Server 2005 express edition. I know I am able to check the "microsoft sql server 2005 express" prerequisite under the redistributables tab. However, this leaves the installation entirely in the hands of the end user, and if he/she chooses the defaults all the way through, we end up with a installation with the named instance SqlExpress. At the very least, I'd like to have the installation proceed with a MyCompany named instance as the default.

How do I accomplish this?

Do I have to upgrade to a more powerful version of installshield?

Improve this question

2 Answers 2

Reset to default
1

If the express addition supports install script you can use the following bit of code. You need to include the Sql Express redist in your install somewhere

LaunchAppAndWait(SRCDIR+"\SQLEXPR32.EXE", "INSTANCENAME="+ instName + " SECURITYMODE=SQL " + "DISABLENETWORKPROTOCOLS=0 SQLAUTOSTART=1 ADDLOCAL=SQL_Data_Files SAPWD=" + sapass /qb" , LAAW_OPTION_WAIT);

In the above code instName is the name of the instance. If you are using Windows Authentication only you can ommit the secuirty and password options.

Check the MSDN docs for other command line options

I sure this could be ported to VB or could even use one of the built in MSI action types

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

I have not used InstallShield Express. InstallShield Professional allows you to define the command line that is passed to the SQL Server installation. This allows you to define an instance name along with other parameters such as 'quiet' mode.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.