Dec 11, 2019 10:10 PM|jjkatz|LINK
Thanks for your reply. I already have Windows Authentication set up in SSMS, and it's working fine. I'll try to explain further. My app is internal to my company, only accessible from inside our network. Our users log into the web app using their own employee
ID and password. That connects them to the web application. The web app is a front end to a SQL Server database. The users do not log directly into that. The app connects to the database via the web.config file. This is invisible to our users and none of them
know the credentials for that connection. I need to keep it that way. So - I need the web.config file to connect to the database using Windows Authentication, but NOT with the username of the person who just logged in. It has to connect with a specific account
name and password. The impersonation link you provided may work. I'll read up on it some more and post back once I've had a chance to try it out.