PDA

View Full Version : Multiple SQL Logins in Basic MSI



DanCla
11-30-2009, 05:44 PM
I am working on an IS2008 Basic MSI project and I am trying to implement multiple SQL Logins. The SQL Logins will have different Servers, Databases, Authentications, Usernames and Passwords. I have tried this How-To: http://kb.flexerasoftware.com/selfservice/viewContent.do?externalID=Q111493
On step 11 when I change IS_SQLSERVER_AUTHENTICATION property to a new property on the imported dialog, it wipes out the radio buttons on the original dialog.
Is there a workaround for this issue?

hidenori
12-02-2009, 10:43 AM
Try deleting the SQLLogin dialog and importing C:\Program Files\Macrovision\IS2008\Support\SQLLogin.isd, and see if it fixes the issue.

DanCla
12-03-2009, 06:16 PM
Thanks that fixed the issues with the diappearing radio buttons but now I have runtime issues like:
- Radio buttons on second dialog do not enable username and password fields
- Browse buttons do not populate servers list or database list correctly

hidenori
12-04-2009, 04:32 PM
- Radio buttons on second dialog do not enable username and password fields


You also need to update the control conditions of the SQLLogin2 dialog to rely on the Authentication Type property for the second connection as follows:


Select the Behavior node under the SQLLogin2 dialog in the Dialogs view.
Select the Conditions tab in the right-lower pane.
Modify all of the conditions to change IS_SQLSERVER_AUTHENTICATION to the property you created for the second connection.



- Browse buttons do not populate servers list or database list correctly

Please make sure that you have the following event for the BtnDbBrowse and BtnSQLBrowse controls of the SQLLogin dialog before the DoAction event.

[IS_SQLSERVER_CONNECTIONS_TO_VALIDATE] <Connection1> 1

where <Connection1> is the name of the first connection you want to validate.

Also, make sure that you have the following event for the BtnDbBrowse and BtnSQLBrowse controls of the SQLLogin2 dialog before the DoAction event.

[IS_SQLSERVER_CONNECTIONS_TO_VALIDATE] <Connection2> 1

where <Connection2> is the name of the second connection you want to validate.