I’m having trouble connecting to a named instance on an MSSQL Server.
I’m using Dremio v. 4.0.0-201909121834570395-c7a5071
Named instance on: SQL Server 2016 Enterprise
To my knowledge named instances (non-default) do not use the standard MSSQL port TCP/1433 rather instead uses a dynamic port. I also tried TCP/1434 with no luck)
Looking at a tail of the server.log file i see failed connection attempts for the ports that I am specifying (1433, 1434). The interesting part comes when i specify the dynamic port that the SQL instance is listening on (found via netstat on the computer running SSMS).
Port 1433/1434 error:
2020-03-05 18:34:39,827 [Plugin Startup: SERVERNAME] ERROR c.d.e.store.jdbc.JdbcStoragePlugin - Connection is not valid.
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host SERVERNAME, port 1433 has failed. Error: “Connection refused (Connection refused). 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.”.
Dynamic Port error:
2020-03-05 18:51:03,245 [qtp447691425-64145] INFO c.d.exec.catalog.CatalogServiceImpl - User Error Occurred [ErrorId: 1aa82392-3a26-46bb-a475-bafb80d8c44e]
com.dremio.common.exceptions.UserException: Failure while configuring source [SERVERNAME].
Caused by: java.util.concurrent.TimeoutException: null
I should note that I can connect fine using SSMS.
Has anyone been able to connect to a named instance on a SQL server running on a dynamic port? Is this supported? Does a static port need to be assigned to the instance? Any plans to have Dremio support the RPC-EPMAP functionality?