Linked server - cannot create an instance of OLE DB provider “SQLNCLI11”

Nadeem Ahmad 1 Reputation point
2021-02-24T17:04:01.143+00:00

I have created linked server and made sure "allow inprocess" is checked and still get and error. I can telnet to the other server and sql serer 2017 is 64bit and the SQLncli11 is both 32bit and 64bit. Any ideas71703-snap.jpg

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CarrinWu-MSFT 6,856 Reputation points
    2021-02-25T03:32:20.267+00:00

    Hi @Anonymous ,

    According to the information what you provided, please refer to You encounter error messages when you execute linked server queries without the required providers installed, see below:
    • The installed OLEDB provider's bitness does not match the bitness of SQL Server. For example, you may have installed 32 bit version of the provider but SQL Server is running in 64 bit mode.

    If it is not work, could you please provide the error log (C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log)? You can search "error" in error log to get the details. And also, please provide the version of SQL Server and the server which you would like to link (select @@VERSION).

    Best regards,
    Carrin

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments