IIS application connecting to SQL, impersonating logged on user with SSPI
connection string works fine, as long as the connection string is defined in
the web.config, but all the connections defined in code behind pages are
trying to connect (and failing) with anonymous user. I noticed that if
impersonation has userName="domainuser" password="password" specified in the
web.config then code behind connections work.
My application needs to distinguish logged on users and use their
credentials to make the SQL connections to the appropriate SQL servers.

Does anybody know what is the workaround?