Looks like I did forget to put the error in there. Its a general ODBC error, server not found. Reconfiguring the ODBC using just the servername "servername\instance" to "servername.companyname.com\instance,1433" fixes...