User Manual

04.15.2025

MANUAL

FAQ: 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](/en/manual/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 ```json { "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. ## Related Information - [Enable the Health Check function in Pleasanter](https://pleasanter.org/ja/manual/health-check) - [Parameter Settings:Rds\.json](https://pleasanter.org/ja/manual/rds-json) - [Parameter Settings:Security\.json](https://pleasanter.org/ja/manual/security-json)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.