Anaplan Connect Migration v1.4. SQL Server Connection (check sql server driver for jdbc)

When migrating some Anaplan connect scripts from v1.3. to v1.4. I encountered an error with my sql connection. The error I received when running my script was something like 'check sql server driver for jdbc'. I wanted to share the solution for reference as it was not that obvious.

 

In my original script (v1.3) my connection parameter was:

-jdbcurl jdbc:sqlserver://localhost

 

As you can see in v1.3. I did not provide a port, however when I used the settings in my v1.4. JDBCProperties.properties file:

jdbc.connect.url=jdbc:sqlserver://localhost

 I received an error when running the script. The solution that worked for me was to add the default port value to my connection url as below:

jdbc.connect.url=jdbc:sqlserver://localhost:1433