Hi All,
I am trying to create a connection to an MS SQL Server 2017 database in Data Dictionary with poor results.
I have tried it both in Data Modeler 18.4 and 19.1 following the steps below:
- Added under the third party JDBC drivers mssql-jdbc-7.0.0.jre8.jar
- Created a new JDBC MSSQL connection under data dictionary using the following settings:
- Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
- JDBC URL:three different urls were used
- v1: jdbc:sqlserver://localhost;port=1434;integratedsecurity=true;
- v2: jdbc:sqlserver://localhost\bam_db;instance=mssqlserver01;port=1434;integratedSecurity=true
- v3:jdbc:sqlserver://localhost\mssqlserver:1434;integratedsecurity=true;database=bam_db
The first two urls (v1 &2) are tested successfully, while the third fails with an error message of: "Cannot open database "bam_db" requested by the login. The login failed".
However, even though the first two urls are tested successfully, if we try to connect to the database,the "Select Schema/Database" screen shows only the schemas of msdb and tempdb and their schemas. In v1 this is expected as we did not specify the database so it took the default one, however in v2 this should not be the case.
Any ideas?
Edit 9/9:
Repeated the above steps in Data modeler 9.2 with jdbc7.4.
After downloading jdbc 7.4 it was added under "Third party jdbc drivers", and sqljdbc_auth.dll was copyied to thr bin and lib folders under the jre path.
After adding a connection using the options of v3 above i received again the same message : "Cannot open database "bam_db" requested by the login. The login failed".
Has anyone managed to create a connection to MS SQL Server 2017 using Datamodeler? This looks like a serious bug.
Thanks