Skip to content

When using the health check function, the database (SQL Server) connection check results in "UnHealthy"

Answer

Please edit the UserConnectionString parameter settings in "Rds.json".

Overview

In the case of a health check response as shown below、By adding Encrypt=false; to the setting value of the UserConnectionString parameter in Rds.json, it may result in a (Healthy) response.

Response

{
    "status": "Unhealthy",
    "totalDuration": "00:00:00.2663513",
    "entries": {
        "sqlserver": {
            "data": {},
            "description": "The connection to the server was successfully established, but an error occurred during login (provider: SSL Provider, error: 0 - The certificate chain was issued by an untrusted authority.)",
            "duration": "00:00:00.1871996",
            "exception": "The connection to the server was successfully established, but an error occurred during login (provider: SSL Provider, error: 0 - The certificate chain was issued by an untrusted authority.)",
            "status": "Unhealthy",
            "tags": []
        }
    }
}

UserConnectionString

Before editing

"UserConnectionString": "Server=(local);Database=#ServiceName#;UID=#ServiceName#_User;PWD=SetUsersPWD;Connection Timeout=30;"

After editing

"UserConnectionString": "Server=(local);Database=#ServiceName#;UID=#ServiceName#_User;PWD=SetUsersPWD;Connection Timeout=30;Encrypt=false;"

Installation Instructions

  1. Open App_Data/Parameters/Rds.json.
  2. Edit the setting value of the UserConnectionString parameter.
  3. Restart the Pleasanter application.
  4. Access the health check endpoint.