SQL: Are your linked servers secure?
I recently wrote about the most common misconfiguration that I see for linked servers. It greatly affects performance.
The second most common linked server misconfiguration is related to security. I can’t tell you how many times I’ve seen this when reviewing SQL Server systems for clients.
The issue you need to consider is that when your local SQL Server connects to the remote SQL Server, which identity is used for the connection?
2025-05-22