You can download “Microsoft Kerberos Configuration Manager for SQL Server” from here    Microsoft Kerberos Configuration Manager for SQL Server is a diagnostic tool that helps troubleshoot Kerberos related connectivity issues with SQL Server. Kerberos authentication provides a highly secure method to authenticate client and server entities (security principals) on a network.  To use […]

Read More → New tool: “Microsoft Kerberos Configuration Manager for SQL Server” is ready to resolve your Kerberos/Connectivity issues

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