Jan 29, 2019 05:38 PM|jhackney01|LINK
In our webforms app we presently have our database username/password information directly in the connection string in the web.config file. We want to change this and begin using Integrated Security so we changed the connection string to look like this:
<add name="LocalSqlServer" connectionString="Data Source=xxx;Persist Security Info=True;Initial Catalog=xxx;Integrated Security=true" providerName="System.Data.SqlClient" />
While this works fine when a person logs in as themselves, the database connection fails when we attempt to login using the username/password of any of our test accounts. It fails because instead of using the Windows account credentials, it is using
the credentials of the account information input into the login form.
What do we have to do so that regardless of what information is input into the login form, the database will use the Windows account credentials? Only the database though because the app itself needs to be able to recognize the username/password information
input into the form due to permission levels.