Re: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

No, is not safe.
Is your web app by chance using windows authentication to connect to the sql server?
If so you should either create an account for the web app on the sql server and use that account to connect or if you must use windows auth to connect to the sql server then you need to enable impersonation in iis and your web app so that it accesses the db with the credentials of the user that's using the web app through IE. The latter method would only work with IE, if another browser is used the user will receive a username and password prompt where s/he must enter his/her windows credentials.

Att.
Fernando Rodriguez, MCPD

"Jack" <Jack@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:C549D695-4AA0-4910-8C05-1F7E5DF0DBA6@xxxxxxxxxxxxxxxx
Hi,
I have written a asp.net application in local machine with personal sql
server 2000. Now I have moved the application to iis6 with sql server 2000 in
windows 2003 server. This machine hosts other web application. When I am
trying to run first page of my web application I am getting the above error.
I found out that this can be solved by running sp_grantlogin 'NT
AUTHORITY\NETWORK SERVICE' to the master database. I am hardly aware of sql
server dba job. So I would like to know if this will be a safe operation.
Thanks in advance. Regards.

.

Relevant Pages

  • Re: VS2005: SQL Debugging "T-SQL execution ended without debugging. You may not have sufficient
    ... > account also must be a member of the sysadmin role in the target SQL ... and the Windows firewall is disabled on both client & server. ... to the remote SQL Server 2005. ... But I'm still getting the "T-SQL execution ended without debugging. ...
    (microsoft.public.vsnet.debugging)
  • Re: Utter madness!
    ... It is just Windows security stuff. ... You can get a trusted connection back to SQL server. ... ASP.NET account (either processModel or app pool identity depending on ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Passthrough authenication w/ SQL trusted connection
    ... separate connection will be used for each security context (each user ... account will have it's own pool). ... if you are using a Windows 2000 Domain, ... backend SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Search services not available
    ... Let me clarify that our SQL server uses Windows Authentication, ... account, even if it was just for now to get it working, that would be easier ... I have configured the Search service to use this ...
    (microsoft.public.sharepoint.windowsservices)
  • connecting to sql server with windows authentication
    ... using windows authentication. ... Use delegation to leverage the current user's account. ... development machine, a live machine, and local installs of IIS for all your ... our DBA wants to keep SQL Server authentication ...
    (microsoft.public.dotnet.framework.aspnet.security)