Impersonation problem.

From: szhang (szhang_at_discussions.microsoft.com)
Date: 03/29/05

  • Next message: Joe Kaplan \(MVP - ADSI\): "Re: Security permissions for Win32 LogonUser call." 
    Date: Tue, 29 Mar 2005 07:29:08 -0800

    When I enable impersonation in web.config and show User identity in .aspx
    page, it is the user IIS authenticates. But when I try to access Sql server,
    I get an access denied error message. It looks like asp.net does not
    impersonate it at sql server side. I can impersonate a specific user in
    web.config without problem. Is this a bug or by design? I need to give users
    permissions based on their Windows login and I have a lot of users, but they
    are not going to access these web pages at the same time.

  • Next message: Joe Kaplan \(MVP - ADSI\): "Re: Security permissions for Win32 LogonUser call."

    Relevant Pages

    • Re: Impersonation ASPNET SQL Server
      ... I think you need to impersonate those user accounts in asp.net ... !Subject: Re: Impersonation ASPNET SQL Server ... Authentication, and Secure Communication is just one ...
      (microsoft.public.dotnet.framework.aspnet.security)
    • Re: Impersonation problem.
      ... When I enable impersonation in web.config and show User identity in .aspx ... it is the user IIS authenticates. ... But when I try to access Sql server, ... impersonate it at sql server side. ...
      (microsoft.public.dotnet.framework.aspnet.security)
    • Re: Connecting to SQLServer 2000 from ASP.NET
      ... Integrated windows authentication or Forms authentication) and it should ... with a developer's domain account. ... It should be OK to have the impersonate settings in machine.config ... meant to be a remedy in the development enviroment, whereby the SQL Server ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Active Directory and SQL Server Connection
      ... I went into my SQL server added a user "Test", ... > I would look up MSDN help on WindowsIdentity. ... > Your connection string is fine, it simply says that windows authentication ... your code needs to impersonate that particular ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: SQL Server windows authentication issue
      ... How to troubleshoot connectivity issues in SQL Server ... Impersonate SQL Server users. ... then to Impersonate a client after authentication. ... then go to the Local security policy and add users there. ...
      (microsoft.public.sqlserver.security)