search

sequelize / cli

The Sequelize CLI
MIT License
2.53k stars 528 forks source link

Dialect options being ignored for mssql named instance #1517

Open semics-tech opened 1 month ago

semics-tech commented 1 month ago

What you are doing?

I am trying to run a db:migration on a mssql server with a named instance and it's failing to connect due to the dialectOptions.instanceName not being respected

export default {
  production: {
    username: USERNAME,
    password: PASSWORD,
    database: DATABASE,
    host: HOSTNAME,
    dialect: 'mssql',
    dialectOptions: {
      instanceName: INSTANCENAME,
    }
  },
}

What do you expect to happen?

Migration to connect successfully

What is actually happening?

Migration is trying to connect to the host only

Output, either JSON or SQL ERROR: Failed to connect to HOSTNAME:1433 - Could not connect (sequence)

Dialect: mssql Database version: 2019 Sequelize CLI version: 6.6.2 Sequelize version: 6.37.3