cli icon indicating copy to clipboard operation
cli copied to clipboard

Dialect options being ignored for mssql named instance

Open semics-tech opened this issue 1 year ago • 0 comments

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

semics-tech avatar Jul 24 '24 13:07 semics-tech