Showing results for 
Show  only  | Search instead for 
Did you mean: 
Level 3

Validation with SQLServerSelectLogin2

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?

Labels (1)
0 Kudos
(2) Replies
Flexera Alumni

Hi @kmisniak ,


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


More details you can find from:

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,



0 Kudos
Level 13

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.

0 Kudos