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
What you are doing?
I am trying to run a
db:migrationon a mssql server with a named instance and it's failing to connect due to thedialectOptions.instanceNamenot being respectedWhat 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