470,636 Members | 1,453 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,636 developers. It's quick & easy.

perplexing impersonation/SQL issue

Hello,
I am battling a long term problem regarding integrated authentication and
impersonation. I have an intranet that uses only integrated authentication to
validate my users. The web site is built in asp.net 2.0 and is running under
IIS6 with impersonation enabled. The web site interacts with a SQL 2000
database running on a separate member server. Authentication works fine
between my clients and the website, but I am running into problems with pages
that need to access the database. Problem is, when a user navigates to a page
that queries the database, things run fine at first and all the pages open.
After 10 minutes or so of idle time, however, the users begin seeing the
dreaded "Login failed for user '(null)'" error when trying to access a
database related page. All other pages that require integrated authentication
on the site are still accessible - it is only the database credentials that
are getting somehow dropped. I have researched this issue again and again,
and I have not been able to find a rational explanation as to why the DB
connection works at first and times out after idle periods. The only way for
my users to regain access to the DB related pages is for them to close their
browser and wait a few minutes before trying again.

Most of the articles I have read indicate that I need to use delegation in
this type of setup. I have not set up delegation, however. I figure if it
works at first, then I shouldn't need delegation in my environment. Anybody
have any suggestions or ideas?
Thanks,
JS
Sep 11 '06 #1
0 1093

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Jim Heavey | last post: by
26 posts views Thread by andrew_webby at hotmail | last post: by
27 posts views Thread by vipleo | last post: by
11 posts views Thread by Phil | last post: by
reply views Thread by filosofer | last post: by
reply views Thread by jasonheath.net | last post: by
1 post views Thread by Korara | last post: by
???
reply views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.