SQL connection by domain account

[mschenk]

Hi, 

due to some legal requirements im not able use login by local account to SQL database (this way work perfektly), I need set connection based on Domain account, but if I use domain\user and password, each time im getting error 

"Unable to Invoke Service Test on test domain connection_II: null"

Any Idea how to solve

(as thing template Im using JDBC_MSSQLServer)

[posipova]

You have to authenticate with a username (enabled login SQL options).

[mschenk]

Hi, I make it (if I used SQL management studio I can use windows authentication), but issue is same, I checked log in SQL and there is 

Login failed for user 'eu\xxx. Reason: Attempting to use an NT account name with SQL Server Authentication.[CLIENTxxxxxx]

Error: 18456, Severity: 14, State: 6.

[rosharma]

if you are using windows authentication try using SQL Server User credentials

or try with using sa user in configurations on ThingWorx entity

[slangley]

Hi @mschenk.

If one of the previous responses has answered your question, please mark it as the Accepted Solution, for the benefit of others who may have the same question.

Regards.

--Sharon