12 Replies Latest reply on Nov 11, 2017 11:53 AM by kkotta RSS
    mfelton Explorer

    Thingworx 7.4 MSSQL Install Errors

    When executing the 'thingworxMssqlDBSetup.bat' file i get an error stating

    "Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server: TCP Provider: No connection could be made because the target machine actively refused it"

     

    Here are the parameters i am using, the database is on the same machine so localhost should be correct.

     

    server=localhost

    serverinstance=SQLEXPRESS

    port=1433

    adminusername=sa

    loginname=twadmin

    database=thingworx

    thingworxusername=%loginname%

    schema=twschema

     

    I have also checked that remote connections are enabled and that TCP/IP is also enabled for the SQL service. Anyone else had this issue?

     

    Specs:

    Windows Server 2012

    Tomcat 8.0.33

    jdk-8u121

    SQL Server Express 2014

    Thingworx 7.4 MSSQL

     

    Thanks