cancel
Showing results for 
Search instead for 
Did you mean: 
kmisniak
Flexera beginner

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 Jenifer
Flexera

Re: Validation with SQLServerSelectLogin2

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/helplib...

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

0 Kudos
Highlighted
rguggisberg
Active participant

Re: Validation with SQLServerSelectLogin2

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