Solved: How to configure dbconnect version 2 with sql serv... - Splunk Community

All Apps and Add-ons

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

1 Solution

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

View solution in original post

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

Get Updates on the Splunk Community!

Agentic SOC Triage: Investigating Splunk ES Notables with MCP Server and a Local LLM

The Problem: Too Many Alerts, Too Little Context Security operations teams running Splunk Enterprise Security ...

All Work and No Play? Not at .conf26! Unwind at These Evening Events

Between hands-on technical sessions, keynote reveals, and diving into live architectures, .conf26 is packed ...

Join the Hackathon at .conf26 and build a No-Code AI agent

Join us for the AI Agent Buildathon, an in-person, three-hour hands-on Hackathon where you’ll use Splunk Agent ...