Hello,I'm having trouble connecting to a SQL Server Database (SQL Server 2008 R2, mix-mode authentication). Using the following JDBC Driver Class Name (com.microsoft.sqlserver.jdbc.SQLServerDriver) returns the following error when I attempt to create a service and selecting SQL(Query)->Tables/Columns :"Thing State is being set to ERROR because it failed during the initialization phase: JDBC Driver Class Not Found: com.microsoft.sqlserver.jdbc.SQLServerDriver".My configuration settings are the following:JDBC Connection String: jdbc:sqlserver://localhost;databaseName=TestDBDatabase username and password set.The Thing's Thing Template is set to "Database".Per a posting I read, it stated sqljdbc4.jar would be located in the Thingworx\WEB-INF\lib folder, though I did not see it there. I then downloaded the sqljdbc4.jar from the Microsoft site and added it in myself. However this did not solve the error message I am getting.Have I missed a step or are my configuration settings not correct? Any help would be appreciated.

1-Visitor

Question

SQL Server Configuration

Forum|Forum|11 years ago
August 20, 2014
1 reply
2572 views

Hello,

I'm having trouble connecting to a SQL Server Database (SQL Server 2008 R2, mix-mode authentication). Using the following JDBC Driver Class Name (com.microsoft.sqlserver.jdbc.SQLServerDriver) returns the following error when I attempt to create a service and selecting SQL(Query)->Tables/Columns :

"Thing State is being set to ERROR because it failed during the initialization phase: JDBC Driver Class Not Found: com.microsoft.sqlserver.jdbc.SQLServerDriver".

My configuration settings are the following:

JDBC Connection String: jdbc:sqlserver://localhost;databaseName=TestDB
Database username and password set.

The Thing's Thing Template is set to "Database".

Per a posting I read, it stated sqljdbc4.jar would be located in the Thingworx\WEB-INF\lib folder, though I did not see it there. I then downloaded the sqljdbc4.jar from the Microsoft site and added it in myself. However this did not solve the error message I am getting.

Have I missed a step or are my configuration settings not correct? Any help would be appreciated.