Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
MSSQL Connection Issue

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
Best Answer
-
I tried with two types of connection and got all databases
You need to find out your settings
Philip
Answers
-
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
Philip
-
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.
Thanks
Edit 10/9:
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,
Hostname: localhost\mssqlserver01
Port: 1434;integratedSecurity=true;database=bam
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
Thanks
-
I tried with two types of connection and got all databases
You need to find out your settings
Philip
-
After enabling TCP/IP through configuration manager everything works fine.
Thank you