I'm running into an issue linking SQL servers. The servers I have are:
Server A - SQL Server 2008 R2
Server B - SQL Server 2014
I can set B as a linked server on A with no problem, but setting up A as a linked server on B gets me the error:
Cannot write property UseRemoteCollation.This property is not available on SQL Server 7.0. (SqlManagerUI)
Is this just an issue with the two servers being different versions? Is there anything I can do to get around this issue?