Let’s say you’ve got a SQL Server (KIRK) containing a linked server against another SQL Server (SCOTTY)  and you’re connecting the KIRK from remote client machine (SPOCK) using SQL Server Management Studio and receiving the error message below when you executed a query involving the linked server :  “Error 18456: Login failed for user ‘NT […]

Read More → How to set up a Kerberos Authentication Scenario with SQL Server Linked Servers