January 3, 2013 at 12:10 pm
I am trying to create a linked server between SQL Server 2005 and SQL Server 2008 but when I try to query the database table that is on SQL Server 2008 I get following error message:
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI" for linked server "sqldev" does not contain the table ""esdev"."dbo"."alerts"". The table either does not exist or the current user does not have permissions on that table.
Interestingly, I created another linked server on a different SQL Server 2008 instance that queries exact same table on SQL Server 2008 and it works.
I am wondering why this may be the case. Has anyone created a linked server between from SQL 2005 to SQL 2008?
Thanks
January 4, 2013 at 8:44 am
I do not have an environment to test but I thought I would throw this out there. SQLNCLI is the SQL Native Client (i.e. the OLE DB driver) for SQL Server 2005. SQLNCLI10 is the OLE DB driver for SQL Server 2008. In your SQL 2005 instance, in Object Explorer, under Linked Servers > Providers, do you have an entry for SQLNCLI10? It could be that you need to install the 2008 driver and then reference SQLNCLI10 to create your Linked Server instead of SQLNCLI.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply