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 !
query to get unmatched data from two tables in sql
How To Drop A Table From A Stored Procedure Only If It Exists
Easy way to manage full database name in stored procedures and triggers?
Hiding the login sa to one of the users
When upgrading sql server 2000 to sql server 2008 changes affected by the current databases?