cli
cli copied to clipboard
Dialect options being ignored for mssql named instance
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