question

johnnyGrill avatar image
johnnyGrill asked

how do I create a link to a sql 2000 from sql2014

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 !

sql-server-2000sql2014linked server
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.