A great and related reference to what we will discuss in this blog post is this one: https://thesqldude.com/2011/12/30/how-to-sql-server-bulk-insert-with-constrained-delegation-access-is-denied/ Linked Servers in a sentence or two: Linked servers in SQL Server are connection definitions from one data source to another (or same instance) so that queries can be written joining tables spanning the multiple data sources. Although … Continue reading SQL Server: Curse Of Linked Server Security And The Fix: Pass-through Authentication
You try to login to SQL Server and you get a really nasty message: The key data in the error message At first glance, it appears to be utterly useless. The only useful message seems to be “Login failed for user 'myuser'.” but what we really need to know is “why?”. That information is somewhat … Continue reading SQL Server – Login failed for user ‘[username]’ – How to troubleshoot?