BULK INSERT, Kerberos, and Delegation
Pesky Kerberos and BULK INSERT The T-SQL commands, BULK INSERT and OPENROWSET(…), offer great ways to import data from a file into a table in SQL Server. However, getting BULK INSERT Kerberos security setup correctly…
Enable Kerberos Authentication without rebooting SQL Server
What is this Kerberos thing, anyway?! Kerberos Authentication1 allows SQL Server to impersonate Active Directory users to other services via double-hop-authentication. This is commonly used to provide access to data through a web-site via Windows…