So, I've got an intranet site I'm developing where I'm being told to
integrate a few pages that require me to query a remote MSSQL server.
That server's owner says authentication on his server is Windows based
(no SQL ID/password combos will be assigned, it has to be domain login
credentials), but I can only get him to permission one account.

AFAICT, that requires me use an <identity impersonate...> in the
web.config file for it to be able to run this particular set of
queries for all the users who might visit my intranet site.  Problem
is that I have my own security items based on Windows login
credentials.

Based on what I've read and the result of my own testing, once I put
in that <identity impersonate...> statement, all users start using
that identity's login credentials and it overrides their own.  So,
making it possible for my site to pass through his security breaks my
security.

Is there any way to set an identity impersonation for just a single
page or directory and not have it mess up user identities elsewhere
within the site?