I don't have MS SQL Server 2017 available but you are not using the right path. You trying to use general JDBC import. After adding the JDBC driver you'll have MS SQL Server as supported database.
Here is the right path:
I have very old JDBC drivers and have no problem to connect to MS SQL Server 2016. You can put some options after the port number like - 1434;integratedSecurity=true
Thanks for your reply,
I tried to use the SQL Server database type with the following options
The port settings used are: 1434;integratedSecurity=true;instance=mssqlserver01
I also tried including the database name, but in both cases testing the connection results in the following message: "Status :Failure - Test failed: Login failed for user 'modeler'"
Now, the username / password used in this attempt are valid, and i confirmed them again, with the only thing that may be worth noting being that the modeler account is an sql account.
Interestingly, the below connection details for this connection available in the left side of the database connection pane, end with /null , and a wild guess would be that this results in an invalid url and subsequently to a login fail.
Am i missing something?
I use the developer edition of MS SQL server 2017.
After transferring the instance under the host option, testing the connection was successful, however it seems that if i specify the database as in the example below,
I receive an error message of "Status : Failure - Test failed : cannot open database "Bam" requested by the login. The login failed"
On the other hand if the database name is not referenced, the connection test is successfull, but when actually connecting to the database the only available databases and schemas are the ones under :System databases".
I changed the default database for modeler to "bam" with the same effect
After enabling TCP/IP through configuration manager everything works fine.