Skip to content

Dialect options being ignored for mssql named instance #1517

@semics-tech

Description

@semics-tech

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions