Splunk Search

What's wrong from jdbc config?

hjs123
New Member

Hi.
I want to collect for the ms-sql data.
but, the following error occurs.
I do not know the cause.
What's wrong ?

++++++++++++++ query.properties ++++++++++++++++++++++++++++++++++++++++++++++++++++++
connectionString=jdbc:sqlserver://10.1.1.10;instanceName=STEST;databaseName=master;
username=t_test
password=test123
driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver

++++++++++++++ error log ++++++++++++++++++++++++++++++++++++++++

2012-07-17 11:32:18,941 0 [main] ERROR com.splunk.jdbcscriptedinput.Main - com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the named instance has failed. Error: java.net.SocketTimeoutException: Receive timed out.

Tags (1)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

Verify the connectionString. AFAIK, SQL Server no longer uses instance names. Instead server instances are specified by port number (sqlserver://10.1.1.10:10100).

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Accelerating Observability as Code with the Splunk AI Assistant

We’ve seen in previous posts what Observability as Code (OaC) is and how it’s now essential for managing ...

Integrating Splunk Search API and Quarto to Create Reproducible Investigation ...

 Splunk is More Than Just the Web Console For Digital Forensics and Incident Response (DFIR) practitioners, ...

Congratulations to the 2025-2026 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...