How to access to SQL with Integrated Security from ASP.Net app

From: Davide Bedin (davide_nospam_at_bedin.it)
Date: 07/24/03


Date: Thu, 24 Jul 2003 17:04:48 +0200


I'm trying to use impersonation for a specific account in order to access
SQL with Integrated Security

This account is member of the domain users and has access to the SQL
database.
The <process model> in machine.config on the server is SYSTEM so I suppose
it has sufficient rights to impersonate a user.

When I try to access the application I get an UnauthorizedAccessException
telling that the user hasn't access to
C:\winnt\Microsoft.net\framework\v1.1.4322\temporary asp.net files\control
codes\5753d30e\430de296\hash.web is denied.

Have I to set any special right to the user I'm impersonating in order to
use the application? If I impersonate a user that is member of the domain
administrators group everything works fine, obviously.

Thanks in advance,
Davide Bedin



Relevant Pages

  • Re: Default groups for IUSR_servername
    ... Mine is a member of Domain Users and Guests. ... ISA 2004 loaded but not SQL. ...
    (microsoft.public.windows.server.sbs)
  • Re: Preventing login as NT AUTHORITYANONYMOUS LOGON
    ... > So the identity impersonate needs to be there so we can connect to sql. ... designated ASP.NET to run under has login credentials to your sql database. ... If one is an external web server and the one that doesn't ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Preventing login as NT AUTHORITYANONYMOUS LOGON
    ... >> So the identity impersonate needs to be there so we can connect to sql. ... > work is an internal web server, maybe you need to impersonate with one ... > grant login rights to your internal web server's account *without* needing ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ADAM and SQL Server
    ... provisioning needs to be done on your account and/or on SQL service account ... > I don't think SQL will impersonate your account when it calls in to ADAM. ...
    (microsoft.public.windows.server.active_directory)
  • Re: How to create file on network share from ASP.NET
    ... You can certainly impersonate a member of any domain, ... >>> asp with password asp which can access shared folder. ... >>> to login to local computer. ...
    (microsoft.public.dotnet.framework.aspnet)