Clever Geek Handbook

Error while creating linked server in SQL Server 2008R2

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

SQLNCLI10 OLEDB provider cannot be instantiated for linked server linked name to server (Microsoft SQL Server error 7302)

How can I fix this error?

+3


source to share


2 answers


The OLEDB provider might not be installed correctly. You have selected the native SQL Server client. Do you have SSMS installed on your server? It must be related to the standalone OLE DB for SQL client.



+1


source


I would like to share my experience when I encountered the error

Unable to instantiate OLE DB provider "xxx.YYYY" for linked server "test". Error 7302.

I was observing this post from a failed SQL Server task. Upon analysis, it Allow Inprocess

was found that was not included for provider

. When this is resolved everything works fine for me.



Server Objects -> Linked Servers -> Providers

Also see below

0


source






More articles:


All Articles