DB Connect Not fetching the schema of mssql server

[theouhuios]

Hello

I am trying to connect DB Connect to a MS SQL server and facing few issues with it.

2014-02-06 11:03:20.774 main:INFO:MicrosoftSqlServer - Registering JDBC driver=net.sourceforge.jtds.jdbc.Driver
}
2014-02-06 11:07:00.710 dbx8201:INFO:DatabaseInfoCommand - Fetching schemas for database=XXX_YY

I have the database.conf config as

[XXX_YY]
database = XXX_YY
host = abc
isolation_level = DATABASE_SETTING
password = xxxxxx
port = 1433
readonly = 1
type = mssql
username = xyz

Any ideas on where I am making a mistake. It works fine with oracle DB's. Is _ creating a problem?

[sroback_splunk]

Hi. There is a known issue (DBX-215) with a space in the database name causing parsing errors with DB Connect commands. See http://docs.splunk.com/Documentation/DBX/latest/DeployDBX/Releasenotes - Not sure if this pertains to names with _ as well.

[theouhuios]

I will test it out without a _ later. For now looks like my issue is more with firewall rules than the issue with configs 🙂 Thanks for your time sroback