The latest thing I have tried, which is at least giving me different error messages, is this:
-- 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 .
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