Idea Details

FDM connectivity to SQL Server with Forced Encryption

Last activity 07-12-2016 10:19 PM
Swapnil_Rasane's profile image
07-12-2016 10:19 PM

We're unable to connect to SQL Server through FDM where server is having FORCED ENCRYPTION.

Is this scenario of forced encryption using Microsoft JDBC driver tested with all JDK versions?

 

Also, we want to append the connection string with some additional parameters, can we add that string directly in Server Name/Instance field?

 

The below connection string should get prepared by tool to establish the connection:

 

"jdbc:sqlserver://SERVERNAME:PORT;databaseName=DBNAME;integratedSecurity=true;encrypt=true;trustServerCertificate=true";

 

Also, when I open the FDM through CMD, JDBC connection
string only gets appeared on CMD if connection is getting established.  If the connection string gets displayed on
CMD (with JAVA exceptions if there are errors) prior to establishing connection
will be good as this will help to debug the errors.