This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Install SQL Server Express 2008 if feature selected
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 11, 2010
04:40 PM
Install SQL Server Express 2008 if feature selected
Hello
I am trying to figure out the best way to install SQL Server Express 2008 if the user selects a feature or maybe an option in a custom dialog.
I then wish to run some SQL scripts (which include creation of a database) on the new instance or existing instance(depending if they chose to install SQL Server or not). I do not want to use prerequisites as they may have SQL 2008 installed but wish to put our scripts into a new instance and therefore I need the option to install SQL Server Express or use an existing instance.
It would be handy to install the Management Studio as well but not essential at this point! Any help would be brilliant as I have been scratching my head all day thinking what would be the best way to accomplish this (I am using MSI Basic, but could switch if it makes things easier).
Thank you.
David
I am trying to figure out the best way to install SQL Server Express 2008 if the user selects a feature or maybe an option in a custom dialog.
I then wish to run some SQL scripts (which include creation of a database) on the new instance or existing instance(depending if they chose to install SQL Server or not). I do not want to use prerequisites as they may have SQL 2008 installed but wish to put our scripts into a new instance and therefore I need the option to install SQL Server Express or use an existing instance.
It would be handy to install the Management Studio as well but not essential at this point! Any help would be brilliant as I have been scratching my head all day thinking what would be the best way to accomplish this (I am using MSI Basic, but could switch if it makes things easier).
Thank you.
David
(6) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 11, 2010
07:40 PM
You may want to consider using Feature Prerequisites in order to accomplish your requirement. You can use the standard feature selection dialog or you can have a custom dialog to change the feature state so that a new instance of Microsoft SQL Server 2008 will be installed based on your end user's input.
Hope that helps.
Hope that helps.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 12, 2010
06:03 PM
Hi hidenori
You are correct, I did not know you had all that control on prerequisites on what conditions to launch under. Thank you for the help.
David
You are correct, I did not know you had all that control on prerequisites on what conditions to launch under. Thank you for the help.
David
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 13, 2010
10:27 AM
Hi
As part of this prerequisite, I am running SQL installer with additional command line syntax however I would like to replace the instancename with a name that the user types in via a textbox dialog, I have tried:
/qs /ACTION=Install /FEATURES=SQLENGINE /INSTANCENAME=%MYTEXTBOXPROPERTY% /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /NPENABLED=1 /TCPENABLED=1 /ADDCURRENTUSERASSQLADMIN="True" /INDICATEPROGRESS
However the value %MYTEXTBOXPROPERTY% remains the same and never gets replaced, is this actually possible?
Thanks.
David
As part of this prerequisite, I am running SQL installer with additional command line syntax however I would like to replace the instancename with a name that the user types in via a textbox dialog, I have tried:
/qs /ACTION=Install /FEATURES=SQLENGINE /INSTANCENAME=%MYTEXTBOXPROPERTY% /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /NPENABLED=1 /TCPENABLED=1 /ADDCURRENTUSERASSQLADMIN="True" /INDICATEPROGRESS
However the value %MYTEXTBOXPROPERTY% remains the same and never gets replaced, is this actually possible?
Thanks.
David
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 13, 2010
06:08 PM
%MYTEXTBOXPROPERTY% will be expanded as an environment variable. In order to specify a property, you need to enclose the name with square brackets as follows:
/qs /ACTION=Install /FEATURES=SQLENGINE /INSTANCENAME=[MYTEXTBOXPROPERTY] /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /NPENABLED=1 /TCPENABLED=1 /ADDCURRENTUSERASSQLADMIN="True" /INDICATEPROGRES
/qs /ACTION=Install /FEATURES=SQLENGINE /INSTANCENAME=[MYTEXTBOXPROPERTY] /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /NPENABLED=1 /TCPENABLED=1 /ADDCURRENTUSERASSQLADMIN="True" /INDICATEPROGRES
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 14, 2010
01:14 AM
what about the default instance -> http://community.flexerasoftware.com/showthread.php?t=192186
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 14, 2010
04:49 AM
Thank you hidenori - works a treat!
![](/skins/images/D60DF682EA37BF37032955CE10F3F0BB/responsive_peak/images/icon_anonymous_message.png)