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;
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;