topic Re: Splunk DB connect MSSQL connection params in Splunk Dev

Splunk DB connect MSSQL connection params

wellsajs — Mon, 10 Dec 2012 05:18:12 GMT

I am having issues connecting to a Microsoft MSSQL server using the Splunk DB connect app.
I have tested connectivity from a GUI windows client to the database and it works fine but the connection string maybe the issue in SPLUNK , as I have not seen any examples in the docs that show you how to connect with these params.

Database = SQLSERVER\BETA.ServiceDesk

I have tried many different combinations to try and connect, but cannot get splunk to successfully connect.

In the GUI Client the params below work

Server = SQLSERVER\BETA
Username = test
Password = ********

This takes me straight into the correct database. any help would be greatly appreciated.

Cheers
J

Re: Splunk DB connect MSSQL connection params

ziegfried — Mon, 10 Dec 2012 15:01:50 GMT

Is it a named instance?

Re: Splunk DB connect MSSQL connection params

ziegfried — Mon, 10 Dec 2012 15:06:03 GMT

Also please let us know which values you tried for host and database.

Re: Splunk DB connect MSSQL connection params

wellsajs — Mon, 10 Dec 2012 23:18:48 GMT

I forgot to mention I tried using the host option as well and I also used the port option as well and still could not connect. The error I get is connection refused.

Also I made a slight typo

Server = SQLSERVER\BETA

Database = ServiceDesk

Cheers
J

Re: Splunk DB connect MSSQL connection params

ziegfried — Mon, 10 Dec 2012 23:23:12 GMT

Have you checked that there is no firewall blocking connections from your Splunk instance to you database server?

Re: Splunk DB connect MSSQL connection params

wellsajs — Mon, 10 Dec 2012 23:37:43 GMT

I found a solution to my issue, as MSSQL 2008 was running as a named instance, I needed to find out the dynamically allocated TCP port. The below URL helped me find this information via the Windows Registry.

http://sqlserverpedia.com/blog/sql-server-bloggers/what-tcp-port-is-sql-server-running-under/

I hope this helps out other people who had the same issue as I have had.

Cheers
J

Re: Splunk DB connect MSSQL connection params

Dan — Thu, 17 Jan 2013 00:20:27 GMT

You could also specify a named instance rather than converting to the tcp port http://splunk-base.splunk.com/answers/66459/connect-to-a-non-default-instance-of-ms-sql-server