Node.JS:使用 Sequelize 时无法连接到 Microsoft Azure 数据库

Question

我正在尝试使用 express + Sequelize 连接 Azure 数据库。我无法连接到工作。

我已经修改了 database.json 连接文件，如下所示:

"development": {
    "username": "XXX",
    "password": "XXX",
    "database": "XXX",
    "host": "XXX",
    "dialect": "mssql",
    "port": 1433,
    "dialectOptions": {
      "encrypt": true
    }
  }

我尝试像这样连接 Sequelize

  sequelize = new Sequelize(process.env[config.use_env_variable], config);
} else {
  sequelize = new Sequelize(config.database, config.username, config.password, config);
}

我收到错误消息:
https://i.imgur.com/FQdZCeZ.png

如果我直接更改 Sequelize 连接而不使用 JSON 文件并像这样连接:

sequelize = new Sequelize('XXX', 'XXX', 'XXX', { host: 'XXX', dialect: 'mssql', dialectOptions: { options: { encrypt: true } } });

我收到关于用户名为空的错误:
https://i.imgur.com/JbkOgIU.png

我尝试过与 MySql 的连接，并且一切正常。只有在连接到 Azure 数据库时才会出现问题。任何帮助都会是很棒的家伙!谢谢你。

Answer 1

我连接如下。有用。

   const sequelize = new Sequelize(database, username, password, {
  host: config.databaseHost,
  Port: config.databasePort, // 49175 // 1433
  dialect: 'mssql',

  pool: {
    max: 5,
    min: 0,
    idle: 10000
  },
  dialectOptions: {
    instanceName: 'SQLEXPRESS',
    requestTimeout: 60000
  }
});
sequelize
  .authenticate()
  .then(() => {
    console.log('Connection has been established successfully.');
  })
  .catch(err => {
    console.error('Unable to connect to the database:', err);
  });