Skip to main content

MS SQL : Encrypted Database

Aaron Olson
  • Updated

This requires Data Admin privileges for utilization.

Issue:

You are trying to use a Microsoft SQL Server as your repository database but are receiving the below error:

I/O Error: DB Server Closed Connection

This error will occur when you are attempting to connect to a Encrypted database.

Resolution:

You will add ssl=request to the end of your current connection string.
Current URL: jdbc:jtds:sqlserver://hostname:1433/database;TDS=8.0;
Required URL: jdbc:jtds:sqlserver://hostname:1433/database;TDS=8.0;ssl=request;

For More Information:

If the above is unable to resolve the issue, then please contact iDashboards Support for further assistance.

 

Comments

2 comments

Date Votes
  • Subin N

    Hi Aaron

    I have tried to connect the sql database with mentioned encryption property but getting below response,

    Database Error:

    Encryption is required to connect to this server but the client library does not support encryption; the connection has been closed. Please upgrade your client library

    IDashboard Frontend error: Connection refused/timeout in 10 seconds

    iDashboard version : Version: 9.1f

    JDBC : jtds-1.3.1   (Upgraded. Earlier it was jtds 1.2.5)

    Kindly help on this.

    Regards,

    Subin N

    0
  • Aaron Olson

    Hi Subin,

    The version you are on is no longer supported. In order for us to support you, we will need to get you updated to or most current version 10.2. If you would like I can have one of our account managers reach out to you to talk to you about the update process. 

    0

Please sign in to leave a comment.