Connecting to Microsoft SQL Server database using Oracle SQL Developer

User_MGAVU

Good afternoon

I'm looking to connect to a Microsoft SQL Server database using Oracle SQL Developer and have followed the guidance on the Oracle website here: Third Party Databases Drivers in Oracle SQL Developer

After installing the JTDS driver and entering the relevant credentials, when I tried to connect I received the following error:

When viewing the main SQL Server activity log, I received the following error message:

"Encryption is required to connect to this server but the client library does not support encryption; the connection as been closed."

Can someone confirm how to navigate around this issue?

thatJeffSmith-Oracle

It's possible...

https://www.papercut.com/kb/Main/UseSSLWithMicrosoftSQLServer

User_7PE2L

I have this same issue. I tried the connection string from the papercut article and I get an different error now. this when I try and setup a custom JDBC connection.

#database.url=jdbc:jtds:sqlserver://localhost/papercut;ssl=required

Status : Failure -Test failed: oracle/jdbc/datasource/impl/OracleDataSource

User_7PE2L

I actually figured it out and I can connect successfully.