Validation with SQLServerSelectLogin2

[kmisniak]

Hi, I use SQLServerSelectLogin2 to get Sql Server instance from the user.

Lets say, the user selects sql credentials - login and password.

Is there any way (I mean simple solution maybe in InstallScript?) to validate/check if we connect to selected Sql instance with gathered credentials?

[Jenifer]

Hi @kmisniak ,

How about using function SQLRTTestConnection2 to validate SQL server connection with credentials?

More details you can find from:https://helpnet.flexerasoftware.com/installshield22helplib/Subsystems/installshield22langref/helplibrary/SQLRTTestConnection2.htm#langref_appendixe_619625896_1169203

If you would like to view sample script how it is been used,you can have a look at "EventsConv.rul" file that i am attaching here.It can also be found in <InstallShield INSTALLDIR>\<IS Version>\Script\Iswi\src\EventsConv.rul.

Hope it helps,

Thanks,

Jenifer

[rguggisberg]

You can do with InstallScript as Jenifer suggests. For a Basic MSI project an easier way would be to use ISSQLServerValidate action under 'Behavior' on the 'Next' button in the SQLLogin dialog.