September 28, 2014 at 9:10 pm
Hey everyone,
I'm having a nightmare trying to get a linked server from 2012 to 2005, I'm starting to read that this is not supported, so perhaps I am looking for a workaround?
I installed Native SQL client on the 2012 machine, but when setting up the LINKED Server, I seem to be getting SQLClient11 error messages. I can connect from 2005 to 2012 great, but it needs to be the other way around.
I can successfully create an ODBC connection from 2005 to 2012 but I am not sure how to use this in the Linked Server configuration.
This is driving me nuts, is there anything I can do to make it work?
PS: I can also connect from 2008 R2 without issue.
Thank you for any help, and I am of course more than happy to provide further details if this is not enough.
Regards,
D.
September 29, 2014 at 8:58 am
Hi Duran,
I don't see any issues creating a linked server from 2012 to 2005. As far as I know it's not applicable for legacy 2000 servers. I've even tested it out...it works pretty well.
Try checking msdn books online for more details.
September 29, 2014 at 7:38 pm
Hi faisalfarouqi,
Thanks for the repy, the (possibly) crucial bit of info I missed out was that the 2012 was not using the standard ports.
In the end I created an alias for the 2005 machine and worked without issue, so if anybody else had this issue, maybe it will help them.
So to summarise, 2005 on default port, 2012 on non-default port, both default instances, needed to create an alias for the 2005 machine on the 2012, to create a linked server connection from 2012 to 2005.
Regards,
D.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply