Thomasian
asked on
InstallShield Skip SQL Login Page
I created an installer which will also install sql server express as a prerequisite. And after installation, it will run some sql scripts to create a database.
Everything works fine except that during the installation, the user is prompted an sql login page. Is there a way to skip/remove the login page since I already supplied all the required info to connect to sql server (i.e. instance name, authentication name/pass)?
Everything works fine except that during the installation, the user is prompted an sql login page. Is there a way to skip/remove the login page since I already supplied all the required info to connect to sql server (i.e. instance name, authentication name/pass)?
ASKER
Actually, I was able to supply the login, password. But the problem is, the user is prompted a login page which allows the user to change the values I provided.
What I wanted to know is how to skip/remove the login page during the installation.
What I wanted to know is how to skip/remove the login page during the installation.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I was able to make it work without changing anything but the "New Dialog" property of the dialog previous to "SQL Login" dialog.
What does "ISSQLServerValidate" do and is it really required to make it work properly?
What does "ISSQLServerValidate" do and is it really required to make it work properly?
It may not be required for you, I believe it is simply a property telling Installshield to call a validation custom action using the provided SQL connection information.
Here's a reference page for Installshield custom actions...
http://kb.flexerasoftware.com/doc/Helpnet/installshield12helplib/Ref-ISCustomActions.htm
ISSQLServerValidate is a custom action that is called by pressing button "next" in sqllogin dialog, and which obviously validates if the values entered by the user on sqllogin dialog are correct. Since you skip the dialog, you don't have to worry about it.
Note that whenever you visit sql scripts page in Installshield, it will reinsert sqllogin dialog.
Note that whenever you visit sql scripts page in Installshield, it will reinsert sqllogin dialog.
ASKER
Does it automatically validates whether the login is valid or do I have to write my own code to do the tests?
>on the page "sql scripts", when you create sql connection, you can specify login, password, etc. Good practice is to
>use [PROPERTYNAMES] rather than hardcoded values, and you will find them on the tab "advanced".
I actually hardcoded the server instance name and login info. Can you explain how to use [PROPERTYNAMES]? I looked at the Advanced tab but I don't see anywhere I can enter those info.
>on the page "sql scripts", when you create sql connection, you can specify login, password, etc. Good practice is to
>use [PROPERTYNAMES] rather than hardcoded values, and you will find them on the tab "advanced".
I actually hardcoded the server instance name and login info. Can you explain how to use [PROPERTYNAMES]? I looked at the Advanced tab but I don't see anywhere I can enter those info.
The custom action will validate that it can connect, but won't run any specific commands. If you hard coded the correct user/password then validation seems like overkill to me. But you could check it if you think you want to.
If you have your scripts in the install correctly, then everything should be working? or is there something in addition to the skipping of the dialog? Based on the question, I assumed that everything was already running properly and you were just trying to save showing a step?
If you have your scripts in the install correctly, then everything should be working? or is there something in addition to the skipping of the dialog? Based on the question, I assumed that everything was already running properly and you were just trying to save showing a step?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
jmcmunn,
Yes, everything actually works fine. I just want to skip the login page since I don't really want the users to change anything and it could confuse them.
vadimrapp1,
Do you mean that I can just enter the server name, user name, etc.. at the property manager and just leave them blank at the sql connection under sql scripts?
Yes, everything actually works fine. I just want to skip the login page since I don't really want the users to change anything and it could confuse them.
vadimrapp1,
Do you mean that I can just enter the server name, user name, etc.. at the property manager and just leave them blank at the sql connection under sql scripts?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Both of you have been very helpful.
Thanks.
Thanks.
Capture-02-24-00002.png