Hello,
I have a question about impersonation in ASP.NET applications and Windows Authentication with a remote account.
I had developed an ASP.NET application using a database with SQL Authentication. Recently, the system administrator has switched the database's authentication scheme over to Windows Authentication only.
I researched a bit and found that I could still access the database using impersonation. I added the following section to my web config:
<authentication mode="Windows"/>
<identity impersonate="true" userName="xyz" password="***"
Then, I compiled and attempted to debug the application. I was informed that the username and password were bad.
This lead to me spending an hour trying to figure out what was wrong. I ended up figuring out that it was looking for a local account named [xyz] ...
Go to the complete details ...