user impersonation

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Itai Raz (do_not_reply_because_at_this.email.is.fake)
Date: 11/09/04 

Date: Tue, 9 Nov 2004 14:39:30 +0200

This used to work for us under Windows 2000 server, but doesn't seem to work
with Windows 2003.

We are accessing an SQL Server using integrated security from ASP.Net. For
some reason it seems like the user that ASP.Net is using to connect to the
DB is domain\machineName$. I don't understand why that is, since I have an
account set up for the IIS app to run under, and i have impersonation set to
true in the web.config file for the app. My understanding is that if
impersonation is true in web.config, then the user under which my app is
supposed to run is the IIS user.

What am I doing wrong? 

-- 
--itai

Relevant Pages

  • ADO.NET 2.0 & MSDE & Win98
    ... Framework 2.0 which must be deployed on Windows 98 platform. ... The MSDE will ... be installed on Win98 as the SQL Server to which the app will connect. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SqlExpress distribution and access rights
    ... Is this app with SQL Server Epxress a server app or a desktop app? ... Since you want useraccess the SQL Server with Windows integrated security, and you, of course, do not know what user account the user is using when developing the app. ... you can also incorporate the Windows local user group setup into your installation package. ...
    (microsoft.public.sqlserver.msde)
  • Re: Bizzare SQL Network Error
    ... The bizzare thing is that, the same connection string, the same code to ... In a windows APP it works fine, in a Web APP I get ... >>I am trying to connect to a default instance of SQL Server 2000 Enterprise ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Bizzare SQL Network Error
    ... Your ASP.NET request is not being run under the same windows ... account your ASP.NET requests are being run under. ... >I am trying to connect to a default instance of SQL Server 2000 Enterprise ... I take the same connection string from the web app, ...
    (microsoft.public.dotnet.framework.adonet)
  • Deployment issue - Error 26
    ... The target environment is a dedicated server running SQL Server 2005 Standard ... and client machines running the VS2005-developed code on Windows XP. ... testing looked OK after changing the connection string in the app config file. ... It built a connection string and stored it in the Project settings for the data ...
    (microsoft.public.dotnet.framework.adonet)