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

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

  • Next message: HaukiDog: "Re: Converting CryptAcquireContext -> System.Security.Cryptography.SymmetricAlgorithm" 
    Date: Sun, 27 Apr 2003 16:21:14 -0700

    Hi Bassel,

    Thank you. That worked. I was looking for "NT Authority/Network Service"
    as a local user, and did not realize that a user can show up in a group
    without showing up as a local user. Of course this is true because these
    "hidden" (to me) users show up elsewhere. Thanks for educating me.

    John

    ""Bassel Tabbara [MSFT]"" <basselt@online.microsoft.com> wrote in message
    news:Kq2Rn9LDDHA.2032@cpmsftngxa06.phx.gbl...
    > Hello John,
    > You can add a login to SQL Server for that NT AUTHORITY\NETWORK
    > SERVICE account, which I believe you'll find in the local group
    > IIS_WPG. You can do this in SQL Server Enterprise Manager under
    > Security|Logins. Make sure also to give it the required database
    > access and permissions
    >
    > Please let me know if this works for you.
    >
    > Thanks,
    > Bassel Tabbara
    > Microsoft, ASP.NET
    >
    > This posting is provided "AS IS", with no warranties, and confers no
    rights.
    >
    >
    > --------------------
    > | From: "John Lau" <johnlau@olc.ubc.ca>
    > | Subject: Asp.Net "login failed for user 'NT Authority/Network service'"
    > | Date: Fri, 25 Apr 2003 09:49:54 -0700
    > | Lines: 14
    > | X-Priority: 3
    > | X-MSMail-Priority: Normal
    > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
    > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
    > | Message-ID: <eOvZ0q0CDHA.1600@TK2MSFTNGP10.phx.gbl>
    > | Newsgroups: microsoft.public.dotnet.framework.aspnet.security
    > | NNTP-Posting-Host: adsl-64-170-117-230.dsl.snfc21.pacbell.net
    > 64.170.117.230
    > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
    > | Xref: cpmsftngxa06.phx.gbl
    > microsoft.public.dotnet.framework.aspnet.security:4927
    > | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.security
    > |
    > | 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
    > |
    > |
    > |
    >
    >

  • Next message: HaukiDog: "Re: Converting CryptAcquireContext -> System.Security.Cryptography.SymmetricAlgorithm"

    Relevant Pages

    • RE: Problems executing DTS package
      ... I deleted the local user and now am ... > But, I dont, nor have a ever had a HGAC login on either server. ... then it hits "Audit logout" and stops. ... > Why does SQL Server think that I am trying to login as 'HGAC'? ...
      (microsoft.public.sqlserver.dts)
    • Login/connection problem
      ... mixed mode. ... I log on using a local user name belonging to the ... SQL Server connection. ...
      (microsoft.public.sqlserver.server)
    • Re: Simple question about security setup....
      ... remote user with the same username and password and under the same workgroup. ... remote machine using Windows authentication to connect to SQL Server Express, ... Server did not recognize my remote user as a local user but a guest. ... user - be sure the account name and password are the same on both machines. ...
      (microsoft.public.sqlserver.security)
    • Re: ASP & Windows Scripting
      ... BigFellow wrote: ... > I've got a windows script which add a local user to a server, ... > to a specific database on the sql server. ...
      (microsoft.public.scripting.wsh)
    • Re: database connection erro
      ... > Go to SQL Server Manager and expand the server, databases, MantisSQLDB. ... > Right click Users and choose new database user. ... or if your in a workgroup environment add the local user ...
      (microsoft.public.windowsxp.embedded)