7 Replies Latest reply on Jan 18, 2018 5:45 PM by aallari RSS
    aallari Newbie

    Unable to connect database thing to MSSQL DB



    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.