Re: Impersonation problem.

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 03/29/05 

Date: Tue, 29 Mar 2005 12:55:57 -0600

On Tue, 29 Mar 2005 07:29:08 -0800, szhang <szhang@discussions.microsoft.com> wrote:

¤ 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.

Is your SQL Server set up for integrated security and is it specified in your connection string?

Paul
~~~~
Microsoft MVP (Visual Basic)

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: 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)
  • 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: 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)