Skip to main content
Anonymous
February 2, 2017
Solved

Connection of MS SQL server 2014 with thingworx

  • February 2, 2017
  • 4 replies
  • 3527 views

Hi!!!

I am connecting my TWX with MS SQL Database.

JDBC Driver Class name: com.microsoft.sqlserver.jdbc.SQLServerDriver

JDBC connection string: jdbc:sqlserver://localhost:1433;databaseName=thingworx

While executing my service i am getting an error as

"Unable to Invoke Service test on sample_thing : Login failed for user ''. ClientConnectionId:1b3f3f02-a405-4e4a-b04e-86618c94cedf"

and also getting error in importing jdbc driver for mssql server from TWX market place.

So this is the whole scenario.

I hope you are getting me.


Best answer by supandey

Hi Bavithraa, what sort of error are you getting while importing the driver? The service seems to be failing on authentication, have you already rechecked the password you are using for the login? Is your Thing showing isConnected=true?

4 replies

supandey5-Regular MemberAnswer
5-Regular Member
February 2, 2017

Hi Bavithraa, what sort of error are you getting while importing the driver? The service seems to be failing on authentication, have you already rechecked the password you are using for the login? Is your Thing showing isConnected=true?

Anonymous
February 3, 2017

problem with my credentials. sorted out now.

Thanks!!

posipova20-Turquoise
20-Turquoise
February 2, 2017

Hi, could you please ensure your credentials for the database? it seems like it reaches the database but not able to authenticate with the credentials provided.

As for the marketplace - the extension provides the ability to build your own jdbc extension, packaging the jdbc driver. Are you experiencing an error trying to import the marketplace extension or the extension that was built by it? What is the error you are seeing?

Anonymous
February 3, 2017

Yup!! It was due to the problem in credentials. It was sorted out now.

Thanks!!

Terms & ConditionsAccessibility statement