Skip to main content
M
mschenk1-Visitor
1-Visitor
October 22, 2018
Question

SQL connection by domain account

  • October 22, 2018
  • 4 replies
  • 1617 views

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

P
posipova20-Turquoise
20-Turquoise
October 22, 2018

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

M
mschenk1-VisitorAuthor
1-Visitor
October 24, 2018

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.

 

R
rosharma16-Pearl
16-Pearl
October 24, 2018

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

or try with using sa user in configurations on ThingWorx entity

 

Terms & ConditionsAccessibility statement