Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

[Ibrahim Mohamed El-Ganady]

Mr :
I have proplem with Visual stdio 2003 and Windows2003
Enterprise Server , when I developed web application
using ASP.Net (VB) that establish connection to SQL Server
database the following error appeared.


Server Error in '/WebApplication1' Application.

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

Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and where
it originated in the code.

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

Source Error:


Line 97: Private Sub Page_Load(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
MyBase.Load

Line 98: 'Put user code to initialize the page here

Line 99: Me.SqlDataAdapter1.Fill(DataSet11)

Line 100:

Line 101: End Sub




Source File: d:\inetpub\wwwroot\WebApplication1
\WebForm1.aspx.vb Line: 99

Stack Trace:


[SqlException: Login failed for user 'NT AUTHORITY\NETWORK
SERVICE'.]

System.Data.SqlClient.ConnectionPool.GetConnection
(Boolean& isInTransaction) +474

System.Data.SqlClient.SqlConnectionPoolManager.GetPooledCon
nection(SqlConnectionString options, Boolean&
isInTransaction) +372

System.Data.SqlClient.SqlConnection.Open() +384

System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection
connection, ConnectionState& originalState) +44

System.Data.Common.DbDataAdapter.FillFromCommand(Object
data, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
+304

System.Data.Common.DbDataAdapter.Fill(DataSet dataSet,
Int32 startRecord, Int32 maxRecords, String srcTable,
IDbCommand command, CommandBehavior behavior) +77

System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38

WebApplication1.WebForm1.Page_Load(Object sender,
EventArgs e) in d:\inetpub\wwwroot\WebApplication1
\WebForm1.aspx.vb:99

System.Web.UI.Control.OnLoad(EventArgs e) +67

System.Web.UI.Control.LoadRecursive() +35

System.Web.UI.Page.ProcessRequestMain() +731

 

[Stefán Jökull Sigurðarson]

Your SQL Server is propably configured to use Windows Authentication, and as
a default that User does not have access. You can use SQL Enterprise manager
to add this user to the list of allowed users.

This should also give you a little more information on the source of the
problem:
http://support.microsoft.com/default.aspx?scid=kb;en-us;247931&Product=sql2k