September 27, 2017 at 12:44 pm
I would like to create linked server for SQL 2000 from SQL 2012.
I tried to use Microsoft OLE DB Provider for SQL Server as Provider to create linked server but it doesn't work. any idea?
Please provide steps?
September 27, 2017 at 1:33 pm
kk_tech - Wednesday, September 27, 2017 12:44 PMI would like to create linked server for SQL 2000 from SQL 2012.
I tried to use Microsoft OLE DB Provider for SQL Server as Provider to create linked server but it doesn't work. any idea?
Please provide steps?
You need to use an older version of the SQL Server Native Client. If you don't have SQLNCLI10 on the 2012 server, you can install in from the 2008 Feature Pack. It can be installed side by side with SQLNCLI11. Then in the Provider drop down for the linked server, select SQL Server native Client 10.0. If you are scripting the creation, specify the provider as SQLNCLI10
You can download the 2008 Feature pack from this link:
Microsoft® SQL Server® 2008 R2 SP2 Feature Pack
Sue
September 29, 2017 at 3:45 pm
I don't have an option to install additional driver, however I was managed to create linked server using ODBC driver and it worked successfully. Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply