I have a similar problem, (linking to MSSQL2008 from MSSQL2014), but it wasn't fixed by using a local user.

see screenshot - SQLNCLI11 should support an SQL2008 server, right? Any idea...