Skip to main content
mschenk1-Visitor
1-Visitor
Oct 22, 2018 11:30 AM UTC
Question

SQL connection by domain account

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)

4 replies

posipova20-Turquoise
20-Turquoise
Oct 22, 2018 7:38 PM UTC

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

Translate
mschenk1-VisitorAuthor
1-Visitor
Oct 24, 2018 7:49 AM UTC

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.

 

Translate
rosharma16-Pearl
16-Pearl
Oct 24, 2018 10:58 AM UTC

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

or try with using sa user in configurations on ThingWorx entity

 

Translate
Terms & ConditionsAccessibility statement