Community Starter Kit

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

dotnetruler — Wed, 04 Nov 2009 00:37:49 GMT

Check here

http://devilswork.wordpress.com/2009/01/28/login-failed-for-user-networkservice/

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

MasterV23 — Wed, 07 Oct 2009 18:20:04 GMT

Check your SQL DB and make sure under your DB instance > Security > Logins > Right Click > Properties of that USER. Then under server roles, make sure that "sysadmin" is check.

Next try your website again and see if it fixes the problem.

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

vkkreddy — Wed, 07 Oct 2009 07:57:23 GMT

Hi, I have the same Problem. I had a Web Application. It was developed in ASP.NET , C# , VS 2008 and SQL Server 2008. I am using connection string as

"Data Source=xxxx;Initial Catalog=xxx;Integrated Security=True".

It is working fine, when I run it from the Visual Studio. When I run it from the Internet Exlporer(After Creating Virtual Directory), I am able to access the Home Page. When I provide the User name and Password in that page and click on Login Button, i.e., at the time when it is hiting the Data Base, I am getting the Same Error. The Error is as Follows

Server Error in '/SriVariVevaCell' Application.

Login failed for user 'NT AUTHORITY\IUSR'.

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\IUSR'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Login failed for user 'NT AUTHORITY\IUSR'.]
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4844759
   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, String srcTable) +92
   System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1297
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +19
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +142
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73
   System.Web.UI.WebControls.GridView.DataBind() +4
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
   System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +72
   System.Web.UI.Control.EnsureChildControls() +87
   System.Web.UI.Control.PreRenderRecursiveInternal() +44
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842

Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053

I think the Problem was in Connection String. I using the SQL Server Windows Authentication. Please Help me ASAP.

Thanks in advance.

kiran

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

madanmohan2k6 — Tue, 16 Jun 2009 17:22:22 GMT

for the error "Login failed for user 'SERVERNAME\IUSR_WEB-SERVER'" do following settings to work fine

Start-->Run-->inetmgr-->right click on your application and select Properties--> Directory Security -->click edit for "Authentication and access control" ---> uncheck the check at "Enable the anonymus access"--> click ok and apply that's it.

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

madanmohan2k6 — Tue, 16 Jun 2009 17:12:45 GMT

It helped me a lot

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

madanmohan2k6 — Tue, 16 Jun 2009 16:41:58 GMT

it worked for me Thanks a lot..

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

rmsohaila — Thu, 04 Dec 2008 06:23:47 GMT

Thanks a lot it works.

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

poddar_himanshu@yahoo.co.in — Fri, 29 Feb 2008 09:44:08 GMT

Hi Shaukat,

Hope u hv checked ur IIS setting and is fine.

Next see the database u r using has 'sa' dbo Login Name which is created at the time of database creation.

This will be under databasename>users.

Regards.

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

shwaqar — Thu, 28 Feb 2008 16:58:25 GMT

I have the same issue. I tried using the above code in web.config. Nothing happens. Any help please......?

Regards

Shaukat

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

poddar_himanshu@yahoo.co.in — Sat, 08 Dec 2007 07:46:16 GMT

hi all,

when i run my application on local pc or local host it runs fine but when i put it on server and try running from IP of server "Login failed for user 'NT AUTHORITY\NETWORK SERVICE'" error come,

i made changes as suggested above in <System.web> now the error changes to "Login failed for user 'SERVERNAME\IUSR_WEB-SERVER'".

can any one help....i have been using same web.config with same code in other project too...but without error.

please tell me the possible source of error.

thanks

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

user2008 — Mon, 10 Sep 2007 20:56:26 GMT

Hi, One doubt with this! If the configuration is hardcoded with username and password of one user, how will other users be able to authenticate through those credentials??

Thanks,

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

geoDenver — Fri, 17 Aug 2007 01:38:07 GMT

Just an addendum. If you exclude the usernName="" and password="", it uses the authenticated user's permissions. That way you can customize permissions based on the Windows users or groups and you're not stuck with only one account.

Thanks so much for your post, it helped solve a very nagging problem.

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

saxroots — Thu, 13 Nov 2003 19:44:34 GMT

Thank you so much - I had the same problem and your solution worked perfectly - thanks!

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

foo73 — Wed, 25 Jun 2003 13:36:35 GMT

I added this using a local account and it worked beautifully. Thanks for your help.

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

bentomkins — Wed, 25 Jun 2003 13:07:20 GMT

try putting this inside your web.config file inside the <system.web> tag...

<system.web>

<identity impersonate="true" userName="xxxxx" password="xxxxx" />

<.system.web>