The error is as below:

Server Error in '/ProjectTracking' 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 81:             da.SelectCommand = cmd; Line 82:             //da.MissingSchemaAction = MissingSchemaAction.AddWithKey; Line 83:             da.Fill(ds); Line 84:             conn.Close(); Line 85:             cmd = null;

Source File: c:\Inetpub\wwwroot\WEBSETUPPM\ProjectTracking\App_Code\PopulateControlsCls.cs Line: 83

Stack Trace:

[SqlException (0x80131904): Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.]    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846887    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392    System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35    System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +144    System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +342    System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221    System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189    System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185    System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31    System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +433    System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66    System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499    System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65    System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117    System.Data.SqlClient.SqlConnection.Open() +122    System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +31    System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +112    System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +287    System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +94    ProjectTracking.PopulateControlsCls.LoadDataSet(String SQLquery) in c:\Inetpub\wwwroot\WEBSETUPPM\ProjectTracking\App_Code\PopulateControlsCls.cs:83    _Default.Page_Load(Object sender, EventArgs e) in c:\Inetpub\wwwroot\WEBSETUPPM\ProjectTracking\Default.aspx.cs:22    System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14    System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35    System.Web.UI.Control.OnLoad(EventArgs e) +99    System.Web.UI.Control.LoadRecursive() +50    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.507

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Deepak Sharma14y ago
Hi,

try adding

inside web.config file

http://forums.asp.net/t/1264863.aspx
0
B M Suchitra14y ago
Hi Deepak,

I check and followed the steps in the link you had given and i am now facing some new problem.
I have selected the digest type of authentication method for windows domain server.. But i still have problem with it...
Though i have included all the dll/assembly while adding the output to the webset up project i get this error below:
Compiler Error Message: CS0234: The type or namespace name 'Linq' does not exist in the namespace 'System' (are you missing an assembly reference?)
0
Deepak Sharma14y ago
Hi Suchitra,

It seems problem is not with the installer but with database connectivity.
You can try 2nd answer of the following link :

http://stackoverflow.com/questions/2251839/login-failed-for-user-nt-authority-network-service
0
B M Suchitra14y ago
Hi,

My system is configured as a domain.
Note:
I have IIS6 with windows server 2003

@Mukesh,
That article did not help me much. Infact i have followed the same steps to create set up
0
Mukesh Kumar14y ago
hi ,

refer this link : http://codeissue.com/articles/a04df930da62eb1/create-asp-net-deployment-package-using-web-deployment-and-web-setup-project
0

B M Suchitra14y ago

Deepak Sharma14y ago
Hi,

Can you post exact error you are getting
0
B M Suchitra14y ago
Deepak,

I did the same but it gives a server error.. I do not know much about it.. Can you please guide
0
Deepak Sharma14y ago
Just right click on the folder and click on browse. It should launch your home page
0
B M Suchitra14y ago
Yes Deepak,

In IIS i can see the folder created.. But how do i use this to access my application? Or how to browse this?
0
Deepak Sharma14y ago
Hi,

Web setup does not create shortcuts like Windows setup. So, if you have installed correctly a virtual directory should have been created in your IIS under Default Web Site node with the name of your web setup project.
0

How to create a set up for web site?

Server Error in '/ProjectTracking' Application.

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