FDM connectivity to SQL Server with Forced Encryption

Idea created by Swapnil_Rasane on Jul 13, 2016
    New
    Score0

    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.