.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

PassThrough authentication fails: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :SharePoint
I've tried it with every AuthenticationMode! But no one seems to work correctly in my case. I thought that PassThrough should work with a preset User ID and password. This would be enough for the moment, but even this doesn't work!! With WindowsCredentials I get the following error: The Property with name 'SsoApplicationId' is missing on the LobSystemInstance. SsoApplicationId I tried to set this with the SharePoint SSO but I've no such services. How can I set this just for the current WindowsCredentials (of the current Sharepoint user)? With RevertToSelf I get the following error: "An error occurred while retrieving data from MyLOBInstance. Administrators, see the server log for more information." The server log contained no useful information for me. With PassTrough I get the following error: "Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: <local machine>]" Why are the lines <Property Name="RdbConnection User ID" Type="System.String">MyDomain\Administrator</Property><Property Name="RdbConnection Password" Type="System.String">mYpAssWoRd</Property> being ignored? Everything (MOSS, SQLServer,...) is on a single machine, so I don't need to activate Kerberos, do I? <LobSystemInstance Name="SEPInstance1207">   <Properties>    <Property Name="DatabaseAccessProvider" Type="Micros

View Complete Post

More Related Resource Links

Need Help in this 'Login failed for user 'NT AUTHORITY\NETWORK SERVICE'


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:

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\NETWORK SERVICE'.]
  System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5009598

OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\LOCAL SERVICE'




I need help with a problem: When trying to process a analysis services project, I receive the following error message -


OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\LOCAL SERVICE'.; 28000; Cannot open database "DocumentDB" requested by the login. The login failed.; 42000.


I am using the service account for impersonation for the datasource. One suggestion I received from the data-access forum was to grant privileges to the local service for the database. I am not clear about the procedure to do that. Can someone please guide me through this? I am posting this question in thi

Linked server fails -Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. with SQL2008R2


Hi, Kerberos seems to be malfunctioning with SQL2008R2.


I have a new dev SQL2008R2 server called BDSDEV2 and an upgraded(in-place) SQL2008R2 server BDSTEST2.

From BDSDEV2 , I can successfully issue a linked server query to BDSTEST2

select * from bdstest2.eis_prod.dbo.wcs_agent


But from my client in SSMS, connected to BDSDEV2  , the double hop is failing to BDSTEST2 for same query 

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.


I have another BDSDEV1 server, which is SQL2008 and there double hop IS WORKING

From my client in SSMS, connected to BDSDEV1  ,I can successfully issue the query to BDSTEST2 .


The service accounts  for MSSQLSERVER are both local admins on their servers and sa's

I have confirmed SPN is OK 

This is from BDSDEV2 - sql2008r2 server.

C:\Program Files (x86)\Resource Kit>setspn -L tsqlssvc

Registered ServicePrincipalNames for CN=TSQLSSVC,OU=SvcAcct,DC=corp,DC=saif,DC=c


Error: 18456, Severity: 14, State: 16 Login failed for user 'NT AUTHORITY\SYSTEM'

Hi,   can someone help me with this error. Error: 18456, Severity: 14, State: 16 Login failed for user 'NT AUTHORITY\SYSTEM' [CLIENT:<local machine>] I've found several Threads but not with the NT AUTHORITY\SYSTEM.   Thanks for help.   Jens

login failed for user nt authority/system

Please help on This error, I'm Using sql 2005 , windows authentication Event viewer,application: source :mssgl server,id 18456,servirty 14 state 16, logine failed for use "nt Athority/system,client: local machine , this error i'm gatting frequently Regards Asif

SQL Error with Login: Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: ]

<!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman";} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {mso-style-noshow:yes; mso-style-priority:99; color:purple; mso-themecolor:followedhyperlink; text-decoration:underline; text-underline:single;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt;} @page Section1 {size:612.0pt 792.0pt; margin:70.85pt 3.0cm 70.85pt 3.0cm; mso-header-m

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'



We are building a web part to fetch data from SQL Server. The Sharepoint application and SQL database are on two different servers. But when i am trying to access the database from the web part it gives the following error

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

 Sharepoint site details:

Windows authentication enabled

IIS->Application Pool Identity,IIS->website->Directory security,crediantial used to access the database ,are same
 (administrator Crediantials)

Any help regarding this issue will be greatly appreciated.



Login failed for user '...\ASPNET' only with parameterized query using SQL Server Authentication


Hi there,

I've narrowed the problem down to the following:

  • Receive "Login failed" for user ASPNET error message
  • SQL Server 2005 is db and IIS is web server (both on same computer)
  • Mixed authentication used on SQL Server
  • I have created user ASPLogin with password that is correctly typed int the web.config:


add name="masterConnectionString" connectionString="Data Source=computername\GMOSERVER;Initial Catalog=Portal;Persist Security Info=True;User ID=ASPLogin;Password=password<

Connecting to MSDB store: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'



I'm trying to connect to SQL MSDB store using ADO.Net SQLConnection class in the windows authentication mode using c#. 

Connection string I'm using is "Data Source=datasource; Initial Catalog=msdb; Integrated Security=True".

When the control reaches connection.open() in the code, it errors out with the message

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

I made sure that I'm an admin on the SQL machine and my 'user' object is mapped to MSDB db .

Any suggestions?





Hi All,

 my SQL 2005 cluster server i'm getting login failed error message.


0000: 18 48 00 00 0e 00 00 00   .H......

0008: 0e 00 00 00 49 00 43 00   ....I..

0010: 54 00 2d 00 53 00 51 00   T.-.S.Q.

0018: 4c 00 44 00 42 00 56 00   L.D.B.

0020: 53 00 30 00 31 00 00 00   S.0.1...

0028: 07 00 00 00 6d 00 61 00   ....m.a.

0030: 73 00 74 00 65 00 72 00   s.t.e.r.

0038: 00 00                     ..      




For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.





Event Id = 18456


[CLIENT:] is my internal moss server ip address. error message is keep on continue each and every minutes. Currently i don't have any application issues. i want to know why i'm getting this error on my sql node.


i know if i disable the cluster server security login audits , this event log will not appear in event viewer. i need a solution why i'm getting error. i like to resolve this issue.

Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: ]



: 18456, Severity: 14, State: 16.
Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]

I am seeing this error in my SQL log and application event every min.

If I restart the mechine this problem could be resolved. Any inputs with out restarting the machine.


Login failed for user IIS APPPOOL\DefaultAppPool


Any Ideas on how to fix this issue?

Visual Studio 2005, Windows 7 64bit, SQL Server 2005 Express

Cannot open database "sql2" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\DefaultAppPool'.

Forms based users being prompted for windows authentication login for My Sites photos in user lists

Here's an issue I didn't see coming for our forms based authentication users. 

We have a web application extended to an external url to handle forms based authentication for users outside of our domain. Our setup looks like this...

Internal Users/Windows Authentication - moss.domain.com
External Users/Forms Based - mossext.domain.com
My Site for Internal Users - mysites.domain.com

When our forms based users are accessing user lists, or discussion pages that display user pictures, they are getting a windows authentication login for our internal users (mysites.domain.com) who have populated their my site with personal photo.

How do we fix this? 

System.Data.SqlClient.SqlException: Login failed for user . Reason: The account is disable


Hi All,

Thank you for advance.

I created a widows service for mail schedule with c#.net and sql server 2005 and it is working fine for past one year.

now sometimes i am getting the "System.Data.SqlClient.SqlException: Login failed for user '<UserName>'. Reason: The account is disabled." error.

then i restarted the windows service manually and working.

what is the problem in my sql server connection and how to fix that issue?

Login Failed for User "XXX" when login from a ETL machine for Sql Server 2005 SP2

Hi Guys, I have a straange issue with Login Failed errors coming intermittently probabaly twice in a week: I have a  production Database on Server A and we have Two ETL servers on Server B and Server C. Sometimes when the ETL's (SSIS) run from SERVER B I do get an error stating login failed for user "XXX" this user is a sql server user. And when I run the same package from Server C it does not give any error and runs smoothly. Both the packages uses the same configuration file to connect to the same database with the same user credentials. Also this error is not a frequent error but comes along once or twice in a weeK. Can anyone shed some light on this and let me know the root cause. Both servers have the same sql client version as well. All servers mentioned above are 64 bit windows 2003 servers. Raju

Login failed for user sa

Hi All, I am using sa login to connect my databse from sqlbrowser.It is logging sucessfully but if i check eventlog it is saying that Login failed for user sa .Password did not match that for the login provided eventid 18456. how i can resolver this issue any ideas/Suggestions.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend