I have a sql 2000 instance that I can connect to via a windows 10 odbc connection. I also created a udl that works. On my sql2014 enterprise manager, I'm trying to create a linked server to the 2000 instance. I installed the sqlncli_amd64.msi that installs an older protocol.
Named Pipes Provider: Could not open a connection to SQL Server [53]. OLE DB provider "SQLNCLI11" for linked server "sql2000" returned message "Login timeout expired". OLE DB provider "SQLNCLI11" for linked server "sql2000" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible.
I've tried a few different protocols and odbc connections and even used the connection string created by the udl. But none work.
I was able to connect to my sql 2008 but not 2000. I can even connect to the sql 2000 instance via windows10 odbc driver and get data from a table.
Help !