Posted on: 12/10/2014 3:51:31 PM | Views : 446

Hello,
I have an asp.net application which connects to a SQL Server Database.  I would like to connect to the database with windows authentication or sql server authentication.  When my app starts I prompt for the user to select a database and then enter their database userid and password, or they can click on connect which should use windows authentication to the database.  Based upon their response I setup the connect strings:
Windows Authentication:  connect_string ="Trusted_Connection=Yes;Data Source=vcamadev1\camadev;Initial Catalog=DEV;Integrated Security=True"
SQL Server Authentica ...

Go to the complete details ...