#linked servers

In today’s interconnected world, managing data across multiple SQL Server instances is a common scenario for many organizations. Whether for reporting, data aggregation, or monitoring, running the same query across these servers efficiently is paramount. This article explores practical techniques and tools to achieve this, focusing on T-SQL, linked servers, Central Management Server (CMS), and…

Linked Servers Connection Issue – Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’

2020.01.29 — Post moved to “Pending Review” State — Incorrect advice.  Poor grammar.

When setting up Linked Server with in SQL Server you get following error message:

TITLE: Microsoft SQL Server Management Studio —————————— “The linked server has been created but failed a connection test. Do you want to keep the linked server?” —————————— ADDITIONAL INFORMATION:

An exception occurred while…