Thingworx 7.4 MSSQL Install Errors

[mfelton]

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

[supandey]

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 ?

[mfelton]

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.

[supandey]

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.

[mfelton]

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?

[supandey]

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.

[mfelton]

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

[mfelton · Accepted solution]

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!

[supandey]

Interesting! Glad it has worked!

[pagrawal-2]

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

[adrianpet]

Hi,

     If you did restart the SQL service after you did the changes that Matthew suggested and it still doesn't work, just change the status of the TCP/IP protocol from the SQL Server Configuration Manager from Disabled to Enabled, restart the service again and try. For me it worked like that

Thanks

[vguevaraperez]

its this solution for ThingWorx-Platform-Mssql-8-1-0? I have same error message?

[Kishore_K]

Thank you Matthew, you saved my day!!!