cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Thingworx 7.4 MSSQL Install Errors

SOLVED
Level 1

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

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Thingworx 7.4 MSSQL Install Errors

Found the solution.

In the Configuration Manager -> SQL Server Network Configuration -> Protocols for *instancename* -> TCP/IP Properties -> Ip Addresses.

On all the available IPs i had to define the port was 1433 as seen below, after that, no problem!

12 REPLIES 12

Re: Thingworx 7.4 MSSQL Install Errors

Matthew, is the Mixed mode enabled for the authentication on that particular instance? Are you able to authenticate on that instance via SQL Management Studio using SQL Server Authentication, apart from the default Windows authentication ?

Re: Thingworx 7.4 MSSQL Install Errors

Yes on both counts, I log in via SQL Server Authentications using the 'sa' account on the management studio which logs me in correctly without error.

Re: Thingworx 7.4 MSSQL Install Errors

Strange, i haven't had such an issue. Could you please try telnet something like this from the command prompt telnet <yourLocalIP> 1433

also please ensure that the SQL Server Browser Window's service is running

If this still doesn't help I would test by disabling the firewall/antivirus application, despite it's on local machine, just to ensure that somehow its not blocked. And if this would help add the exception to the firewall manually before switching it back on.

Re: Thingworx 7.4 MSSQL Install Errors

so i cant connect via telnet, but wouldn't i need a telnet server running?

Also the only services i have running SQL related are

Is this correct?

Re: Thingworx 7.4 MSSQL Install Errors

Yes SQL Server Browser looks fine, I think yes you will have to enable/install at least the Telnet client. You can enable it from the Server Manager > Manage > Add Roles and Features then go to Select Features -  i think enabling Telnet client will be sufficient for testing.

Re: Thingworx 7.4 MSSQL Install Errors

Yeah i had already enabled both the client and the server, and the command couldn't connect

Re: Thingworx 7.4 MSSQL Install Errors

Found the solution.

In the Configuration Manager -> SQL Server Network Configuration -> Protocols for *instancename* -> TCP/IP Properties -> Ip Addresses.

On all the available IPs i had to define the port was 1433 as seen below, after that, no problem!

Re: Thingworx 7.4 MSSQL Install Errors

Interesting! Glad it has worked!

Re: Thingworx 7.4 MSSQL Install Errors

Hi Guys,

I am facing same problem and I am not getting any luck with the proposed solutions.

This is what I am getting:

I have entered that 1433 port in every IP as well.

But still I am getting this problem!!!!!!
Please help me.......Thanks