Sql Linked Server Login Failed Nt Authority Anonymous Logon
Underlying Error: A connection could not be made to the data source with the Name of '07fcf078-7916-4e68-8852-95a5577a3137'. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.. The exception was raised by the IDbConnection interface. Activity ID: 0df9a08b-9ea2-4f87-86b6-0a9e35709d04 Correlation ID: 3041412f-1eae-eb47-322b-e218a262a5e8
Is linked server configured with windows login Is it configured with imporsenate. You need to check the login which is mapped in linked server should have access on remote server.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' Cause The error occurs when the SQL Server service account on the source instance (InstanceA in the above example) is not properly configured to delegate or forward the Windows credentials to the remote SQL Server instance (Instance B in the above example).
Azure SQL DB - Login failed for user NT AUTHORITY\ANONYMOUS LOGON. Posted on June 15, 2018 by blobeater Now that I have your attention with a powerful title how about some context?
SQL SERVER - Login failed for User 'NT AUTHORITY\ANONYMOUS LOGON' - ERRORLOG Errors related to logins are one of the most searched in this blog. Many of the blogs that talk about these errors are the ones that get viewed often too. This is one of the interesting errors, which you might see in your environments.
Double hop problem with sql server 2008. Ask Question Asked 8 years, Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Specifically, what is listed for the login to use when using the linked server? Catalog views sys.servers and sys.linked_logins are going to be useful here.