Getting Data In

How to configure DB Connect app to avoid login fail errors connecting to my SQL server?



I'm trying to connect to my SQL SERVER using DB CONNECT and i receive this following error:

Error connecting to database: java.sql.SQLException: Cannot open database "MSSQLSERVER" requested by the login. The login failed.

Look my form:

Field Username:
(Use a value in the form of DOMAIN\USERNAME to enable Integrated Windows Authentication.)

I don't have a Windows user only my SQL user. Do I need to put anything before my username? Example: Xx\Admerp



Are you providing the same DB credentials on the Splunk end? also you have to give permissions for the instance to connect on the DB. I had similar issue couple of months ago.

0 Karma
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Get the T-shirt to Prove You Survived Splunk University Bootcamp

As if Splunk University, in Las Vegas, in-person, with three days of bootcamps and labs weren’t enough, now ...

Wondering How to Build Resiliency in the Cloud?

IT leaders are choosing Splunk Cloud as an ideal cloud transformation platform to drive business resilience,  ...