Cannot initialize the data source object of OLE DB provider "SQLNCLI10" for linked server

Post date: Apr 26, 2011 3:07:29 AM

It depends on how you are doing the linked server. If you do it via the SQL Server or Other Data Source option.

Try using SQL Server, and the linked server name should be in the form of

ServerName\InstanceName

An example is attached.

Linked Server

Here is the security settings and also the select statement to show that it is working with the linked server.

Security

Results

-Courtesy amenkes: