Hybrid sql server and asp.net windows authentication

From: Onur Gorur (onur_at_gorur.com)
Date: 11/11/04 

Date: Thu, 11 Nov 2004 08:08:03 -0800

I have an asp.net web application that executes stored procedures on SQL
Server 2000 on the backend and displays the results of this stored procs on a
grid. I use integrated windows authentication on IIS, asp.net and SQL Server.
Here is what I want to do:

- When a user starts to use the application I want to get the credentials of
the user. (This can be done by web.config:: <identity impersonate="true">)
- After I get the user info, I would like to run the stored procedures with
a different specific NT user's credentials, one that I will give all SQL
Server accesses. So, I will not give any application user SQL Server direct
query access but only this specific user account. (This can be done by
impersonating this specific user in the web.config)

I want both of this, but I could not find a way to accomplish both. One
method I thought would be having one asp.net application and another web
service application both running with different credentials: First, with the
logged in user and second with my sql server account)

Any other ideas? Help wanted!

Thanks in advance 

-- 
Onur Gorur, MCSD
Microsoft Turkey
Mid-Market Programs Manager

Relevant Pages

  • Re: Cached Logon
    ... Your browser is caching the credentials, ... be accessed (it's just the ASP page -> SQL Server that doesn't work, ... are you using a common connection string across all three pages (eg is ...
    (microsoft.public.windows.server.general)
  • Re: Cached Logon
    ... Your browser is caching the credentials, ... be accessed (it's just the ASP page -> SQL Server that doesn't work, ... are you using a common connection string across all three pages (eg is ...
    (microsoft.public.sqlserver.connect)
  • Re: Cached Logon
    ... Your browser is caching the credentials, ... be accessed (it's just the ASP page -> SQL Server that doesn't work, ... are you using a common connection string across all three pages (eg is ...
    (microsoft.public.sqlserver.server)
  • Re: Cached Logon
    ... Your browser is caching the credentials, ... be accessed (it's just the ASP page -> SQL Server that doesn't work, ... are you using a common connection string across all three pages (eg is ...
    (microsoft.public.win2000.networking)
  • Re: Cached Logon
    ... Your browser is caching the credentials, ... be accessed (it's just the ASP page -> SQL Server that doesn't work, ... are you using a common connection string across all three pages (eg is ...
    (microsoft.public.inetserver.iis)