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

How to do SQL Server UserName, Password validation in InstallScript poject

I am trying to validate the username and password in the Database Server Wizard. It is showing the connected SQL servers by clicking the browse button, but not validate the Username and Password if we enter the wrong. 

I am calling below function to do it..

Dlg_SQLServer:
SQLRTInitialize2 ();
nResult = SQLServerSelectLogin2( szConnection, svServer, svUser, svPassword, bvWindowsAut, svCatalog, bShowCxnName, bShowDBCatalog );
if( nResult = BACK ) goto Dlg_SdFeatureTree;

How to validate the username and password from the InstallShield wizard..

Please share your comments

0 Kudos
2 Replies
deepakdp
Level 3

Can anyone please help me on this..

0 Kudos
Jenifer
Flexera Alumni

Hi @deepakdp ,

 

There is no predefined method for validation,you have to write your own method.Then add/link it on Next-button's click or wherever you want it to be.The below link has some sample code to help you through with different scenario of checking database existence.

http://msicreation.blogspot.com/2010/09/check-if-database-exist.html

 

Hope it helps,

Thanks,

Jenifer

0 Kudos