Linked Server Error - Login failed for user NT AUTHORITY\ANONYMOUS LOGIN
-
Hi.
I am trying to setup a linked server. I am using an AD account to setup the connection, the AD Account is part of an AD Group which has full access on bother servers.
I am getting the below error.
Does anyone know what this caused by?
The Linked Server is also Sql server
-
I believe the issue is the Service Principal Names (spn) on one or both of the servers in question is not set up, so the Windows credentials do not get passed through. the service account the SQL service is running under must have permissions to set that. you can look in the SQL error logs on each server and see if you have something like this in the log, or if there was an error.
Post reply
The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/LowellsServer.MyDomain.org:1433 ] for the SQL Server service.Kerberos is constantly making my want to cry due to this all the time. even when it's set up correctly, i don't trust it any more.
this article helped me out previously:
https://www.mssqltips.com/sqlservertip/4875/script-to-check-and-auto-generate-spns-for-sql-server/Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply