5 Replies Latest reply on Nov 1, 2017 4:40 PM by supandey RSS
    aallari Newbie

    Unable to connect database thing to MSSQL DB

    Hi

     

    We have installed thingworx with mssql database. We created one Thing and selected "Database" as "ThingTemplate",  now in configuration tab we have filled the options as below :

     

    jDBCConnectionURL =  jdbc:sqlserver://localhost:1433;databaseName=thingworx;

    jDBCDriverClass = com.mysql.jdbc.driver

     

    But the connection is not getting established, the property "isConnected" is showing as false only.

    We can able to connect to the database through persistence provider with the same jDBCConnectionURL, so I think the problem is with the jDBCDriverClass.


    we have tried DriverClass as below also:

    jDBCDriverClass =  com.microsoft.sqlserver.jdbc.SQLServerDriver

     

    Please let us know if we are missing any thing or using wrong driver class name for mssql.