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.
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.
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)