Please, show the full connection string that does work and the one that does not (and with what error!)
I guess you can test your connection on a demo server with RESTful interface for SQL data...