So I'm trying to get a JDBC connection running from L7 to a MS SQL server 2016 database.
In the test environment I got it all working. The MS SQL server runs on version 14.0.3257 RTM but I can remember that a colleague noticed that the test ain't a cluster (hope to get answer on it next week).
So I thought this is going to be easy for production. Unfortunately it isn't since its not working. I changed the server name to the production environment and I still get connection issues. I know its running on its own instance but I can't specify the instance. This was also not needed in the Test environment.The specs look almost the same. The only difference is that test is running on the Microsoft SQL server developer edition and production on Microsoft SQL server enterprise edition: core-base Licensing.
The connection string that works in the test environment
jdbc:l7tech:sqlserver://
SERVERNAME:1440;DatabaseName=
databasenameso if I change the severname en database name to production environment i get the following error (connection refused).
Any idea why or how i can troubleshoot what the issue might be? The error is pretty general.
Cheers