Linked Server Anonymous Error
Contents |
Active 2 0 Sign into vote ID 2162206 Comments 5 Status Active Workarounds 1 Type login failed for user nt authority anonymous logon linked server 2008 Bug Repros 1 Opened 12/23/2015 7:38:35 AM Access Restriction Public Description nt authority anonymous logon sql server 2012 I have SQL2012 server running (version 11.0.5613.0). Linked server (to another SQL machine) is configured and linked server windows authentication working FINE when using Mgmt Studio 2012. When using Mgmt Studio 2014 I get error 'Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.' Msg 18456, Level 14, State
Login Failed For User 'nt Authority Anonymous Logon' Windows Authentication
1, Line 1 This is the same linked server ?? The only difference is the later version of Mgmt Studio ?? 12.0.4213.0 (all running as vm under vmware) DETAILS ATTACH A FILE EDIT THIS ITEM Assign To Add User Display Name: Save Comments (5) | Workarounds (1) | Attachments (0) Sign in linked server login failed for user to post a comment. Please enter a comment. Submit Posted by Kwenix on 2/17/2016 at 12:33 AM feel free to close this item... Posted by Kwenix on 2/17/2016 at 12:31 AM opened support case: issue is solved.Had nothing to do with bug.Was so-called 'double hop issue' (see https://sqlbadboy.wordpress.com/2013/10/11/the-kerberos-double-hop-problem/) Posted by Kwenix on 1/20/2016 at 12:21 AM In my case it's something different (intellisense on or off makes no difference). (again, this procedure works FINE in Mgmt Studio 2012, but the error is in Mgmt Studio 2014)I use object explorer to 'browse' linked server:Server objects -> linked servers -> server in question -> catalogues -> default -> tables -> KABOEM...Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Microsoft SQL Server, Error: 18456)===================================Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476------------------------------Program Location: at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request re
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn what is nt authority anonymous logon more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges
Spn Registered
Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills
Login Failed For User Nt Authority Anonymous Logon Iis
and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the https://connect.microsoft.com/SQLServer/feedback/details/2162206/linked-server-false-error-login-failed-for-user-nt-authority-anonymous-logon-management-studio-2014 top How can I get my linked server working using Windows authentication? up vote 8 down vote favorite I'm trying to get a linked server to ServerA created on another server, ServerB using "Be made using the login's current security context" in a domain environment. I read that I'd need to have SPNs created for the service accounts that run SQL Server on each of the servers in order to enable Kerberos. I've done that and both http://dba.stackexchange.com/questions/44795/how-can-i-get-my-linked-server-working-using-windows-authentication now show the authentication scheme to be Kerberos, however, I'm still facing the error: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'". In Active Directory, I can see that the service account for ServerB is trusted for delegation to MSSQLSvc, but I noticed that the service account for ServerA does not yet have "trust this user for delegation" enabled. Does the target server also need to have that option enabled? Is anything else necessary to be able to use the current Windows login to use a linked server? sql-server sql-server-2008 linked-server authentication kerberos share|improve this question asked Jun 18 '13 at 21:29 Christopher Garcia 2593510 add a comment| 1 Answer 1 active oldest votes up vote 9 down vote Every machine in the chain from your desktop to the server you are calling has to be Kerberos enabled for the trust to advance past the first hop. So, yes the server needs to trust the user for delegation. The "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'" almost always indicates a delegation problem. Your Windows Account must have access to both ServerA and ServerB. You must not have the setting "Account is sensitive and cannot be delegated." Both ServerA and ServerB must have their own SPN registered. The servers must be TCP/IP or named pipes connected. The SQL Server Books Online article that offers some more detail is "Configuring Linked Servers fo
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us http://stackoverflow.com/questions/12462674/sql-server-returns-error-login-failed-for-user-nt-authority-anonymous-logon Learn more about Stack Overflow the company Business Learn more about hiring developers http://www.sqlservercentral.com/Forums/Topic1206923-1526-1.aspx or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQL Server returns error “Login failed for user nt authority 'NT AUTHORITY\ANONYMOUS LOGON'.” in Windows application up vote 28 down vote favorite 4 An application that has been working without problem (and has not had any active development done on it in about 6 months or so) recently began failing to connect to database. Operations admins cant say what might have changed that would cause the problem. The client application uses a hardcoded connection string with Integrated nt authority anonymous Security=True, but when the applications attempts to create a connection to the database, it throws an SQLException saying "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON". I can log on to the database through Management Studio on this account without problem. All of the things that I have seen for this issue are for ASP.NET projects and it is apparently the "Double Hop Problem" which being a client application darned well better not be a problem. Any help would be greatly appreciated. Edit The client machine and server machine as well as user accounts are on the same domain. This occurs when Windows Firewall is off. Leading theory is: Server was restarted about a week or so ago, and failed to register Service Principal Name (SPN). Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. sql-server security sqlconnection share|improve this question edited Sep 17 '12 at 16:57 asked Sep 17 '12 at 15:41 CodeWarrior 4,51732966 29 If you are going to downvote me, please give me a reason why you are doing it. This will do two things, it will give me constructive criticism which will allow me to better frame
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2008 » Security (SS2K8) » Linked Server Error: Login failed for user... Linked Server Error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Rate Topic Display Mode Topic Options Author Message winston Smithwinston Smith Posted Wednesday, November 16, 2011 9:47 AM SSC Eights! Group: General Forum Members Last Login: Tuesday, September 27, 2016 1:58 AM Points: 927, Visits: 2,033 I am setting up a linked server between two servers on my domain.I am using impersonate, so that its my own account that is used on the linked server.I set up both servers to use kerberos and confirmed its working (both servers running under domain accounts).im logged into my desktop pc, via my domain account.Now, when i try to query tables via the linked server i get the error:Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.I set up kerberos initially to get over this yet its still an issue. anyone able to help here?Thanks. Post #1206923 DevDev Posted Wednesday, November 16, 2011 10:02 AM SSCommitted Group: General Forum Members Last Login: Saturday, August 8, 2015 4:20 AM Points: 1,932, Visits: 1,598 It was a BUG in SS2K5 and MS claims it to be fixed. Time to re-open the defect I guess http://support.microsoft.com/kb/925001 Dev*** Open Network for Database Professionals ***http://www.linkedin.com/in/devendrashirbad Post #1206941 winston Smithwinston Smith Posted Wednesday, November 16, 2011 1:31 PM SSC Eights! Group: General Forum Members Last Login: Tuesday, September 27, 2016 1:58 AM Points: 927, Visits: 2,033 Would a bug of this scale ( its pretty big IMO that you cannot use linked servers with Windows Logins over Kerberos) go unfixed since sql server2000? Im using sql server 2008 R2 enterprise. Post #1207094 K. Brian KelleyK. Brian Kelley Posted Wednesday, November 16, 2011 1:48 PM Keeper of the Duck Group: Moderators Last Login: Friday, September 16, 2016 11:44 AM Points: 6,639, Visits: 1,905 Kerberos authentication was likely set up. Was Kerberos delegation configured? T