Asp.Net "login failed for user 'NT Authority/Network service'"

From: John Lau (johnlau_at_olc.ubc.ca)
Date: 04/25/03 

Date: Fri, 25 Apr 2003 09:49:54 -0700

Hello,

My SQL Server 2000 is on the same machine as IIS 6 on a Windows 2003 Server.
I've added the ASPNET user to SQL Server, and have given it db_owner rights
to the database. I'm using integrated security SSPI. I'm getting the above
error message when I try to connect to SQL Server to authenticate the user.

I've already installed this on a Windows 2000 Server with IIS 5. I don't
know if I've missed a step or if there is something different in Windows
2003 Server/IIS 6? Any help would be greatly appreciated.

Thanks, John

Relevant Pages

  • Using aspnet user to sql server
    ... use the aspnet user to connect to sql server. ... configurations run in the context of the machine/ASPNET user either using ... I also created a local ASPNET user on the sql server machine and then ... Server connection. ...
    (microsoft.public.dotnet.framework.aspnet)
  • aspnet user and interated security (SQL Server)
    ... I have been attempting to persuade our systems admin staff to allow us ... to use integrated security by adding the aspnet user to SQL Server. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: sql server and asp.net problem
    ... set to the ASPNET users password. ... I reset the ASPNET user password manually. ... I've configured my test sql server with a local ASPNET user and set this ... Server connection. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Trying to get a VB.net sample working with SQL Server.
    ... Very impressed Greg thanks - that worked a treat! ... I had the ASPNET user on my system in the "users" group but not in the ... the database connection trying to use the ASPNET user was a DATABASE user ... is used for the SQL Server connection and how does VB.net know the correct ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Error : Login failed for user MACHINEASPNET :/
    ... It has nothing to do with the directory permissions within the app. ... you're using a trusted connection to talk to the SQL server. ... That meas that the ASPNet user account is the one logging into the SQL ...
    (microsoft.public.dotnet.framework.aspnet)