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.