The latest thing I have tried, which is at least giving me different error messages, is this:

EXEC sp_addlinkedserver

@server='statler',

@srvproduct='',

@provider='SQLNCLI',

@datasrc='np:statler',

@provstr='Integrated Security=SSPI'

-- Then I try this:

select net_transport, auth_scheme from statler.master.sys.dm_exec_connections where session_id=@@spid

/*

Getting closer, but still fails:

OLE DB provider "SQLNCLI" for linked server "statler" returned message "Login timeout expired".

OLE DB provider "SQLNCLI" for linked server "statler" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".

Msg 5, Level 16, State 1, Line 0

Named Pipes Provider: Could not open a connection to SQL Server [5].

OLE DB provider "SQLNCLI" for linked server "statler" returned message "Invalid connection string attribute".

*/

This might have something to do with enabling names pipes, but I can connect via sqlcmd from server A to server B like this:

WALDORF 🙂 Sqlcmd.exe /E /Snp:statler

If I don't used named pipes, and just do:

New Linked Server

Server Type: SqlServer

Security: be made using the current login's security context

I get this:

Login failed for user NT AUTHORITY\ANONYMOUS LOGIN