Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

• volcano_1956

  SSC Enthusiast

  Points: 125

  More actions

  May 13, 2009 at 8:32 am

  #204611

  Hi,

  I'm fairly new to SQL programming.

  Here is my situation.

  I am using MS SQL Server 2005 on MS VISTA business OS and Visual Studio 2008 and IIS 7.0.

  I am creating a basic web form to access information on a table I built in SQL Server using ASP.NET 3.5.

  When I test the connection, I get the message "Connection succeeded"

  I am using Windows Authentication.

  Here is my problem.

  When I go to view the page in a browser, I get a Login Failed for user

  'NT Authority\Network Service"

  Here is my config file:

  Here is my web form source file:

  <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

• Adam Wilbur

  SSCertifiable

  Points: 7001

  More actions

  May 13, 2009 at 4:38 pm

  #994195

  Networkservice is likely the default service account for ASP.NET service? Maybe change this to a domain account?

  
  
  A.J.
  DBA with an attitude

• volcano_1956

  SSC Enthusiast

  Points: 125

  More actions

  May 13, 2009 at 6:42 pm

  #994228

  How and where do I change it to a domain Account?

  Thanks,

  Paul