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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :SharePoint
 

Hi,

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.

Thanks


ragava_28


View Complete Post


More Related Resource Links

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

  

Hi,

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?

 

 


Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON

  

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                     ..      

 

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 192.168.0.140]

 

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

 

 

user = NT AUTHORITY\ANONYMOUS LOGON 

Source = MSSQLSERVER

Event Id = 18456

 

[CLIENT: 192.168.0.140] 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.


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

om

login failed NT AUTHORITY\ANONYMOUS LOGON

  
Hi, I have an page that runs in the central administration site, and it creates a database.  The way this works is you enter the name of the server, and then you click create database, and it is supposed to go to that server and create the database.  This works fine on a stand-alone server, but on a farm, it is failing if I use an Integrated Security=SSPI connection string, and giving the error of "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."  If I instead use an sql authentication connection string, it works fine.  Can someone explain to me what is going on?  Shouldn't this work fine since sharepoint is able to connect to the sql server?
my blog - Tea Time with Meowkins

'IIS' & 'Kerberos' + SQL Login Failure for user 'NT AUTHORITY\ANONYMOUS LOGON'

  

Hi all,

Have spent hours and hours trying to work out what is goin on with this issue and i still cant figure it out.

Hopefully someone here will be able to help.

A few details to start with...

Win Server 2003 x64

SQL Server 2008

SQL RS 2008

 

Server A

SQL Server

Reporting Services

 

Server B

Reporting Services

 

Server B is scaled out and joined to reportserver DB of Server A.

ASP on both servers. Some apps only run on server B

Server B IIS workgroup ID is running under a domain account.

 

Kerberos Authentication is enabled.

 

I am showing intermittant errors in the RS logs stating that a connection cannot be made to a particular database, using login 'NT AUTHORITY\ANONYMOUS LOGON' even though anonymous logons are disabled in IIS.

 

SQL Server logs state this error as....

Date        19/05/2011 11:11:36
Log        SQL Server (Current - 19/05/2011 11:11:00)

Source        Logon

Message
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access

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

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

  
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

What is causing these Login failed for ANONYMOUS LOGON errors?

  

I have a SQL 2005 SP3 cluster running on Veritas Cluster Server (Storage Foundation HA 5.1 SP1).

The cluster has 2 nodes and is configured with 2 SQL Instances running on seperate virtual servers.

The only SQL services installed on each instance/server is Database Services, each instance has the following SQL Services - SQL SERVER (instancename ), SQL Server FullText Search (instancename ) and SQL Server Agent (instancename ).

We are seeing seemingly random occurances of the error below in the logs for each instance, the client ipaddress specified is that of the alternate cluster node (i.e the server not running the instance):

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: ipaddress ]

This error is preceeded by Error: 18456, Severity: 14, State: 11

These errors are appearing in the logs for both instances.

Having read several articles/discussions regarding this error I see it is commonly related to kerberos/IIS/Reporting services and such, however we are not using any of these services, furthermore the instances are currently empty - hosting nothing but the default system databases.

For both instances all SQL services are running as a named domain user account, there are no SQL processes running as SYSTEM users.

Can anyone give any indication as to

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
  System.Data.SqlClient.TdsParser.

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

  

Hi,

 

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

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

  

Error

: 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.

Thanks,
Sanjeev


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


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?


NT AUTHORITY\ANONYMOUS LOGON

  
Hello everybody, I have this scenario. We on application server and sql server Web application server contains following thinks: IIS 7.0 Windows Server 2008 ASP.net 2.x Sql server: Windows Server 2008 SQL Server 2008 My web application uses following connection string: <add name="AdventureWorksDW2008" providerName="System.Data.SqlClient" connectionString="Data Source=xxx.xx.xx.xx;Initial Catalog=databasename;Integrated Security=SSPI; I got  this error message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. 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\ANONYMOUS LOGON'. 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\ANONYMOUS LOGON'.] Geospatial.Data.DALMap.GetCountries() in C:\Project\old\Geospatial Framework\Geospatial Framework\Geospatial Framework\Data\DALM
Categories: 
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