Connection of MS SQL server 2014 with thingworx

[bmarimuthu-2]

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.

[supandey · Accepted solution]

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?

[bmarimuthu-2]

problem with my credentials. sorted out now.

Thanks!!

[posipova]

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?

[bmarimuthu-2]

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

Thanks!!