Servoy 8.3.1 and SQL2017 Developer Edition

[dean]

The standard MS SQL driver 4.2 just doesn't work and using the JAR for 8 and 10 still doesn't allow Servoy to access the database.
The error says that a TCP/IP connection can't be initiated over port 1433. Yet SQL Configuration shows TCP/IP active and the system's firewalls are turned off.
Excel and other third party applications can access the SQL server (we used AdventureWorks as a test DB) but Servoy just refuses.

[kwpsd]

I have not tried connecting to SQL 2017 but will attempt to help.

What are your connection parameters? They should look like the below sample:

Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

URL: jdbc:sqlserver://localhost:1433;DatabaseName=<your_database_name>;SelectMethod=cursor

User name: sa

Also, using MS-SMS, create a systems admin account (sa) and use it to connect Servoy to the SQL server. The other items you mentioned, most likely, use a Windows account to connect.

[jcompagner]

you can always try to use the latest 7.x driver of MS:
https://docs.microsoft.com/en-us/sql/co ... erver-2017

We updated the driver also for the next servoy release (just delete the old driver and extract the new one from that download)