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

From: Bassel Tabbara [MSFT] (basselt_at_online.microsoft.com)
Date: 04/27/03 

Date: Sun, 27 Apr 2003 13:17:43 GMT

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

Relevant Pages

  • Re: Nearest Common Ancestor Report (XDb1s $1000 Challenge)
    ... but even MORE generic than the XDb1 implementation, ... disadvantage that 'john', 'John' and 'JOHN' are treated as three distinct ... Since this is the default collation, I assume that your database will use ... I have SQL Server on my desktop; ...
    (comp.object)
  • Re: Cant Start Local Instance
    ... Perhaps the Password for the service Account did expire ... > Manager and click on Start I get an error message "The service did not ... >> If you get a login failure message, saying tht the password is not right ... >>>I installed SQL Server 2000 on my local WinXP Pro box. ...
    (microsoft.public.sqlserver.setup)
  • Re: View Type of Protocol
    ... Thanks a lot for the feedback John. ... information about the type of authentication being used. ... some reason Kerberos is not available. ... they are not authenticated and the SQL Server login fails. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Rights needed to restore DB
    ... Have you tried to login with the service account and access the path? ... Dejan Sarka, SQL Server MVP ... This message does not imply endorsement from Solid Quality Learning, ...
    (microsoft.public.sqlserver.security)
  • Re: update index in background not running.
    ... John, ... event log that SQL Server 2000 FT Indexing success & failures are recorded. ... exec sp_defaultdb N'NT Authority\System', N'master' ...
    (microsoft.public.sqlserver.fulltext)