3

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?

Improve this question
1

2 Answers 2

Reset to default
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.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

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

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.