Using Integrated Security to connect to SQL server from Linux

[meta-forte]

Hi,
In our company, the user ids and passwords are removed from the DB and we are required to use a Windows NT id to connect to the DB.
The permissions are based on the AD group in which it is a member. And the group is configured in SQL server and is given necessary permissiouns.

One of our teams is using ExpressJS and tediousJS npm package and they are able to connect okay

We need to connect from a Linux Docker image deployed in Kubernetes cluster.

Is there any documentation on how to configure Lucid to use this npm package to connect to SQL server from Linux

thank you

[thetutlage]

Lucid already uses the tedious package. Can you share the config your team is using in the Express app?

[meta-forte]

Below is db conifg. Hope I mentioned everything necessary

const options: SequelizeOptions = {
    host: xxxx,
    database: xxx,
   dialect: 'mssql',
    dialetctOptions : {
       authentication: {
             type: 'ntlm',
             options: {
                 userName: myConfig.username,
                 password: myConfig.password,
                 domain: 'AD'
             }
      },
      options: {
            port: 1433,
            encrypt: true
      }
  },
  pool: {
     max:30,
     iflr: 120000,
  }
}

const sequelize = new Sequelize ({...options, 
     modelPaths: [],
     modelMatch: (fileName:String, member:string) => {
           //match code
     }
    
})

`