[wix-users] Letting end user give userName and Panssword and test SQL server connection

[John Cooper]

It depends on where the information is stored.  For the products I support, it is always in an encrypted section of the web.config or app.config.  In that case, I use ConfigurationManager to read and parse the encrypted section and return the data.  I used to do that early in the MSI run, but now I'm switching to doing it directly in the managed bootstrapper.

--
John Merryweather Cooper
Senior Software Engineer | Integration Development Group | Enterprise Notification Service
Jack Henry & Associates, Inc.® | Lenexa, KS  66214 | Ext:  431050 |JoCooper at jackhenry.com




-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of Rastogi, Utkarsh
Sent: Monday, March 21, 2016 7:59 AM
To: wix-users at lists.wixtoolset.org
Subject: [wix-users] Letting end user give userName and Panssword and test SQL server connection

The e-mail below is from an external source.  Please do not open attachments or click links from an unknown or suspicious origin.

Hi All,

 I need to setup a SQL connection based on SQL authentication process, So I need to get userName and password from end user and provide the end user with option to test check the connection.

any suggestions  how/ what should i begin with?


Thanks &  Regards,
 Utkarsh Rastogi

____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/

NOTICE: This electronic mail message and any files transmitted with it are intended
exclusively for the individual or entity to which it is addressed. The message, 
together with any attachment, may contain confidential and/or privileged information.
Any unauthorized review, use, printing, saving, copying, disclosure or distribution 
is strictly prohibited. If you have received this message in error, please 
immediately advise the sender by reply email and delete all copies.