Regarding the error, first I’d ensure there is no connectivity issues between the source and the Denodo server.
I’d also strongly recommend you to use JDBC driver instead of ODBC to connect to MS SQL Server. It is faster even if the underlying data source is the same. For this, please take a look at the following section of the Administration Guide: [JDBC Sources](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources).
There you can find further information around working with Denodo and JDBC Sources.
Hope this helps!