I am trying to create a linked server object via SQL Server Management Studio, and I am getting the following errors:
SQL Network Interfaces: Error getting enabled protocols list from registry [xFFFFFFFF]. OLE DB provider "SQLNCLI" for linked server "Foo" returned message "Login timeout expired". OLE DB provider "SQLNCLI" for linked server "Foo" 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.".
This is using "SQL Server" type, but I get it even if I create it via SQL statement. I can connect to the target server "Foo" from other machines without problem. How can I fix this?