Linked server from sql 2012 to sql 2008 r2 not compatible?
we have a linked server set up from sql 2012 to sql 2008r2 . After 2days the credentials are lost and if i query from sql 2008r2 to sql 2012 and vice versa i get the NTAUTHORITY/anonymous logon. I have to reboot my PC and the creditials will work for another 2days and again the same problem appears. I am wondering is this anything to do with compatibility issue? Linked server from sql 2008r2 to sql 2012 works well but not the other way around. Can somebody please help me on this.