Error when creating linked server in SQL Server 2008R2

Question

When I create a linked server in SQL Server, it causes an error

Cannot create a instance of OLEDB provider SQLNCLI10 for linked server 'linked server name '(microsoft sql server error 7302)

How can I rectify this error?

Answer 1

The OLEDB provider may not properly installed. What you chose is the SQL Server native client. Do you have SSMS installed on server? This should come with sql native client OLE DB.

Answer 2

I would like to share an experience when I faced following error

Cannot create an instance of OLE DB provider "xxx.YYYY" for linked server "test". Error 7302.

I observed this message from a failed SQL Server job. On analysis it is found that Allow Inprocess was not enabled for the provider. When this is enabled, everything worked fine for me.

Server Objects --> Linked Servers --> Providers

Also refer following

1. "Cannot create an instance of OLE DB provider" error as Windows Authentication user

2. Linked Server Properties (Provider Options Page)

3. Configuring OLE DB Providers for Distributed Queries