April 30, 2012 at 9:51 am
I would like to link from a SQL 2008 instance to another server with SQL 2012 installed. Do I need to install the SQL 2012 Native Client on the server with SQL 2008 already installed or is there another way?
April 30, 2012 at 10:14 am
A linked server should work. Haven't had a chance to try it yet, but it should be easy enough to set up. Will that do what you need?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 30, 2012 at 10:22 am
I tried that, and it failed because the provider to connect to SQL 2012 (SQLNCLI11) is not available on my SQL 2008 instance. The server with SQL 2008 is Windows 2003 SP2 and does not meet the requirements to install SQL 2012 Native Client.
April 30, 2012 at 11:17 am
I think I finally identified the problem...the server with SQL 2012 is new to our network and it was not added to the DNS servers correctly. I found this on a website when researching the issue.
3) Make sure the server machine is reachable, e.g, DNS can be resolve correctly, you are able to ping the server
When I tried to ping the server with 2012 from the server with 2008, it failed.
After the DNS was fixed, voila! 😛
May 1, 2012 at 6:10 am
BarbW (4/30/2012)
I think I finally identified the problem...the server with SQL 2012 is new to our network and it was not added to the DNS servers correctly. I found this on a website when researching the issue.3) Make sure the server machine is reachable, e.g, DNS can be resolve correctly, you are able to ping the server
When I tried to ping the server with 2012 from the server with 2008, it failed.
After the DNS was fixed, voila! 😛
Makes sense. Well done on fixing it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply