I am attempting to create a linked server in SQL 2012.
The 2 x SQL Instances are on 2 x different clusters on the same network and are both running SQL Server 2012.
I have a default Service account Contoso\ServiceAccount that is has Sysadmin permissions on both instances.
If I try to create the linked server the connection returns the following.
The test connection to the linked server failed.
An exception occurred while executing a Transact-SQL statement or batch.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Microsoft SQL Server, Error: 18456)
I can confirm that the Firewall is disabled on both clusters and across all nodes.
I have also logged onto both instances in SSMS using the Contoso\ServiceAccount service account with no problems.
When i configure the Linked Server I Select the SQL Server Server Type.
Under the Security page I add the Contoso\ServiceAccount and i have selected to Impersonate.
I have also selected Be made using the login's current security context which has worked for me in the past.
Any help would be appreciated.