Splunk DB connect MSSQL connection params

[wellsajs]

Hi

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

[wellsajs · Accepted solution]

Hi

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

[Dan]

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

[ziegfried]

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

[wellsajs]

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

[ziegfried]

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

[ziegfried]

Is it a named instance?