How to configure dbconnect version 2 with sql server using sql server instance without port?

[cdo_splunk]

How to configure dbconnect version 2 with sql server using sql server instance without port?

[cdo_splunk · Accepted solution]

1/Install dbconnect version 2.1.1.

2/modify the jdbc url
jdbc:sqlserver://;databaseName=;selectMethod=cursor

3/Set the host to [Server][Instance] leaving the port blank.

JDBC article showing the proper URL string: http://www.codejava.net/java-se/jdbc/connect-to-microsoft-sql-server-via-jdbc