MID Server SQL Query and NT Authentication

Community Alums · ‎01-07-2016

I've created a JDBC data source to query an SQL database on our network (via MID Server) to load data into Service Now. We have done this before successfully, though in the past we used local SQL accounts, as opposed to domain accounts. In this particular case, we setup a domain account (which tested fine using SQL Management studio), but returned an authentication error when configuring the data source. I asked our DBA to check the SQL logs, and here is the error returned:

Login failed for user 'xxxxxxx'. Reason: Attempting to use an NT account name with SQL Server Authentication

It works fine using a local SQL account to do the query. Anyone else come across this error? Is it possible to do the query using NT authentication?

truzicki · ‎06-02-2016

Hi Tim. I realize you posted this a while back, but the answer to your question can be found at here. Specifically, look under the "User Name" where it says "Enter the user name for authentication on the database server. The user name provided for the JDBC connection must be associated with an account on that database server; it cannot be a Windows Domain account." We just ran into this problem today, and I'm completely dumbfounded. We've opened an incident with SN, but I doubt we'll see a resolution to the issue. Anyhow, I hope this helps!

Best Regards,

-Tim Ruzicki,

Senior Engineer, REI

ashton_sheppard · ‎04-26-2017

I just ran into the same issue today. What we determined made an impact:

"Use integrated authentication" = enabled -> means use the Mid Server service account (using NT authentication)

= disabled -> means use local SQL account as specified in UserName / Password

Hope this gets you on your way.

Ashton

Praveen Mariapp · ‎09-10-2021

Hi Ashton,

I am facing the same issue as explained here.

Please can you confirm where we can find this option 'Use integrated authentication' in order to set this to enabled/disabled.

Thanks

Praveen