Creating a connect to the Linked Server within SQL Server, however it fails with following error. “The linked server has been created but failed a
Tag: Kerberos
Service Principal Names for SQL Server
Service Principal Names (SPN) get used for Kerberos authentication. SQL Server require that all instances have SPNs configured, if not Kerberos authentication fails. By default
Cross-Domain Authentication for SQL Server
How to setup and configure cross domain service principal names.
Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’ with SQL Server Reporting Services
How to setup Kerberos delegation to avoid anonymous logon failure messages.
SQL Canada (SQLCAN) 