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.
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).