Passthrough authenication w/ SQL trusted connection

From: Steve Kallal (stevekallal_at_newsgroups.nospam)
Date: 03/23/04 

Date: Mon, 22 Mar 2004 15:31:08 -0800

I have been searching for an answer to this in vain. Currently we have a hard coded SQL account for all of our ASP .NET applications. We want to use an SQL Server trusted connection instead. In the documentation I find that I can map all users to a single domain user such as the following:

<identity impersonate="true" userName="domain\username" password="password"/>
 
However this is not what I want. For example, if domain\janedoe is using the web app, then I would want domain\janedoe to be passed to SQL Server using a trusted connection. It is not acceptable to have all users mapped to a single domain account.

I am currently using Windows Authentication in the Web App. Anonymous access is turned OFF for the app in IIS.

Thanks in Advance!

Relevant Pages

  • audit tables, delete triggers and sql server authentication
    ... i have a web app connecting to a sql server using sql server ... the web app however, is using windows authentication. ... i have an updatedby and an updatedate. ... how can the trigger know ...
    (microsoft.public.inetserver.asp.db)
  • DirectoryServices
    ... A system that is being designed will use ActiveDirectory to store ... userinformation for a SQL Server 200 base web app. ... to AD after getting the windwos user account from SQL Server. ...
    (microsoft.public.dotnet.framework)
  • creating .mdf in ASP
    ... I've been writing Windows apps for years now but to become familiar with web apps I'm working my way through some instructions to build a web site using a SQL database. ... Connections to SQL Server filesrequire SQL Server Express 2005 to function properly. ... I expect that the production system is being seen as the default SQL Server by my pc and consequently the web app is trying to connect to it to create the database. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Login failed for user NT AUTHORITYNETWORK SERVICE.
    ... If so you should either create an account for the web app on the sql server and use that account to connect or if you must use windows auth to connect to the sql server then you need to enable impersonation in iis and your web app so that it accesses the db with the credentials of the user that's using the web app through IE. ...
    (microsoft.public.sqlserver.security)
  • inserting Turkish chars into sql server
    ... I have ASP.NET web app and SQL Server 2k database. ... The same results are produced when I run the query from the query analyzer. ...
    (microsoft.public.dotnet.framework.adonet)