时间戳

首页 > 解决方案 > TypeOrm - Nest.js 无法连接到 XX:1433 - 自签名证书

nestjs - TypeOrm - Nest.js 无法连接到 XX:1433 - 自签名证书

问题描述

尝试连接到 SQL Server 时，出现以下错误：

[Nest] 96151  - 30/07/2021 18:28:34   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)...
ConnectionError: Failed to connect to XXXXXX:1433 - self signed certificate*

我的 ormconfig.json：

{
    "type": "mssql",
    "host": "localhost",
    "port": 1433,
    "username": "user",
    "password": "pass",
    "database": "BDname",
    "entities": ["dist/**/*.entity{.ts,.js}"],
    "synchronize": true
}

标签： nestjstypeorm

解决方案

您只需要添加 ormconfig.json 并为我工作

“选项”：{“trustServerCertificate”：真}

{
    "type": "mssql",
    "host": "XXXXXX",
    "port": 1433,
    "username": "user",
    "password": "pass",
    "database": "BDName",
    "entities": ["dist/**/*.entity{.ts,.js}"],
    "synchronize": true,
    "options": {"trustServerCertificate": true}   
}

推荐阅读