sequelize连接mssql数据库

const { Sequelize } = require('sequelize')
const qt = require('sequelize').QueryTypes

const dbCon = new Sequelize("BackupDB", "sa", "Sa12345", {
    host: "192.168.1.50",
    port: 1433,
    dialect: "mssql",
    dialectOptions: {
        options: {
            instanceName: "BENET",
            encrypt: false,
        },
    },
    define: {
        charset: 'utf8',
        freezeTableName: true
    },
    pool: {
        max: 5,
        min: 2,
        acquire: 10000,
        idle: 600000
    }
});

const connectDB = async () => {
    try {
        await dbCon.authenticate();
        console.log("数据库连接测试成功.");
    } catch (error) {
        console.log(error);
    }

    const a = await dbCon.query('select top 2 * from prison where id=$1', {
        bind: [1],
        type: qt.SELECT
    })
    console.log(a);
}

connectDB()

主要是记录 instanceName: "BENET" 参数