Ok Sorted it was the redirection to a different server. had the wrong Driver info in new connection string

DRIVER=SQL Server;
instead of
DRIVER=SQL Server Native Client 11.0;