I am doing a POC using the Community Edition of Dremio. Build 1.1.0-201708121825170680-436784e.
I am trying to connect to a SQL Server instance and I need to use the instance host name “MyHostServer\MyHostInstance”. However, the connection fails. I can connect fine using SQL Server Management Studio and the SQL Auth account that has access.
When I look in the logs I see this exception.
2017-09-02 21:54:08,744 [qtp949483950-105] ERROR c.d.e.store.jdbc.JdbcSchemaFetcher - Error listing datasets for My Data Source
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host MyHostServer, port 1433 has failed. Error: “Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.
It seems Dremio is ignoring the “\MyHostInstance” portion of the host name and only using “MyHostServer”.
Is this a bug? Am I doing something wrong?