Der deutsche Education Blog

September, 2011

| |

|

Data, Design, and SQL Server

Yet another cause of Kerberos authentication failure connecting to SQL Server

Posted over 2 years ago

by Dimitri Furman
- 3 Comments
Yesterday I was troubleshooting a rather common problem. A query running on an instance of SQL Server (INST1) was using the OPENROWSET function to retrieve a rowset from another instance (INST2). This is known as "double-hop authentication", and Kerberos...