Could anyone else test this as well? It's driving me crazy. I've been asked to test if Named Pipes can now be used for Linked Servers.
http://technet.microsoft.com/en-us/library/ms191153.aspx
So I can specify TCP:<MyRemoteServer>\<MyInstance>
And running:
select * from sys.dm_exec_connections where session_id=@@spid
Would show auth_method as KERBEROS
As soon as I connect via NP:<MyRemoteServer>\<MyInstance> it always defaults to NTLM.
Keep in mind that I've created the SPNs correctly and according to the technet above. I also see no errors in the security events log. It seems to chose straight away NTLM and not really a failover situation.
Can any DBA/Dev with 2 SQL 2008 boxes test as well?