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
Tag: Kerberos
SQL Server – Resolve – Cannot generate SSPI context
These links are more for my own reference than anything else to resolve the error: "Cannot generate SSPI context" It is a pesky error message that is related to security setup. All the things you need to check are in the MS article below. How to troubleshoot the "Cannot generate SSPI context" error message In … Continue reading SQL Server – Resolve – Cannot generate SSPI context