cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
bmcmaster
Level 2

SQL Script after feature prerequisite SQL Server

Hello,
I have 2 features, one that includes SQL Server express and one that does not. I also have SQL Scripts I want to be installed AFTER the sql server is installed as a feature prerequisite.

The other problem I am facing is the SQL login for the sql scripts comes up directly after starting the install, instead of after SQL server pre-req install in the optional feature.

Any help would be appreciated!

Thanks!
Labels (1)
0 Kudos
(1) Reply
hidenori
Level 17

In order to run a SQL script depending on a feature state, you need to specify the Script Condition setting available in the Runtime tab. For example, the conditional expression "&MyFeature=3" evaluates to True only if MyFeature is changing from its current state to the state of being installed on the local computer, INSTALLSTATE_LOCAL.

Also, you may want to try sequencing the SQLLogin dialog with the forementioned condition after the ISInstallPrerequisites action in the InstallUISequence table so that the dialog is displayed after the SQL Server pre-req install.

Hope that helps.
0 Kudos