Re: Why is user ASPNET used to login to SQL Server?

From: Willy Denoyette [MVP] (willy.denoyette@pandora.be)
Date: 06/26/02


From: "Willy Denoyette [MVP]" <willy.denoyette@pandora.be>
Date: Wed, 26 Jun 2002 12:41:16 +0200


Did you set impersonate="true" in your web.config file?

Willy.

"Michael Owen" <mike@mikeowen.co.uk> wrote in message news:0d2601c21cf0$f4b92ba0$9de62ecf@tkmsftngxs01...
> I have a production environment set up where the Anonymous
> user is set to user 'TFPC'.
>
> I use the following connection string for my ADO.Net
> connections:
>
> data source=127.0.0.1;initial catalog=TFPC;integrated
> security=SSPI;persist security info=False;workstation
> id=B2B-ADVSERV;packet size=4096
>
> The user 'TFPC' has permissions for the SQL server, yet
> when my code tries to access the DB, I get 'ASPNET' user
> does not have permissions.
>
> So..... Why is user ASPNET, and not 'TFPC, used to login
> to SQL Server?
>
>
> Thanks, Mike.



Relevant Pages

  • Re: Why is user ASPNET used to login to SQL Server?
    ... >> I have a production environment set up where the ... >> user is set to user 'TFPC'. ... Why is user ASPNET, and not 'TFPC, used to login ... >> Thanks, Mike. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Why is user ASPNET used to login to SQL Server?
    ... I have a production environment set up where the Anonymous ... I use the following connection string for my ADO.Net ... The user 'TFPC' has permissions for the SQL server, ... Why is user ASPNET, and not 'TFPC, used to login ...
    (microsoft.public.dotnet.framework.aspnet.security)