Configure API for SQL Server Database

Question

I have an API that I used with Mysql, but I had to switch to SQL Server. Unfortunately I never used SQL Server, I do not know if you need to download something to get. The API was made in JS. The sequelize configuration of my API with MYSQL was like this:

const Sequelize = require('sequelize');    

const config = {
    user: "root",
    database: "api",
    password: "",
    host: "localhost",
    port: 3306,
    dialect: 'mysql',
    max: 10000,
    idleTimeoutMillis: 3000
};

const seq = new Sequelize(
    config.database,
    config.user,
    config.password,
    {
        host:config.host,
        dialect:config.dialect,
        port:config.port,
        logging: false,
        pool: {
            max: config.max,
            min: 0,
            idle: config.idleTimeoutMillis
        }
    }
);

module.exports = seq

I made the following change to test with sql server:

const Sequelize = require('sequelize');    

const config = {
    user: "sa",
    database: "dbPortal",
    password: "",
    host: "localhost",
    port: 1433,
    dialect: 'mssql',
    max: 10000,
    idleTimeoutMillis: 3000
};

const seq = new Sequelize(
    config.database,
    config.user,
    config.password,
    {
        host:config.host,
        dialect:config.dialect,
        port:config.port,
        logging: false,
        pool: {
            max: config.max,
            min: 0,
            idle: config.idleTimeoutMillis
        }
    }
);

module.exports = seq

When I turn on the API it says it was connected, but right away it says it wasn’t. When I test her, she is POST, keeps giving some errors in red at the prompt.

Does anyone know how to configure it to work on SQL Server?

Answer 1

With the help of comments on my question I managed to resolve:

const config = {
    user: "sa",
    database: "Nomedb",
    password: "",
    host: "GUI122", //NOME QUE APARECE ANTES DA INSTANCIA DO MEU SQL
    port: 1433, //PORTA PADRAO SQL SERVER
    dialect: 'mssql',
    max: 10000,
    idleTimeoutMillis: 3000,
    instanceName: 'MSSQLSERVERMARIA' //INSTANCIA DO MEU SQL SERVER

};