mitchell_ms_sqlV2.js

const sql = require("mssql");
require("msnodesqlv8");
const conn = new sql.Connection({
  database: "db_name",
  server: "server_name",
  driver: "msnodesqlv8",
  options: {
    trustedConnection: true
  }
};
conn.connect().then(() => {
  // ... sproc call, error catching, etc
  // example: https://github.com/patriksimek/node-mssql#request
});

https://github.com/patriksimek/node-mssql/issues/283

// var sql = require('mssql');

// var config = {
// 	user: '82401',
//     password: 'Password123',
//     server: 'ESAW1\\SHOPSTREAM',
//     database: 'ShopMgth'
// }

// // ESAW1\SHOPSTREAM\ShopMgt
 
// sql.connect(config).then(function() {
//     new sql.Request().query('SELECT * FROM information_schema.tables WHERE TABLE_TYPE=\'BASE TABLE\'').then(function(recordset) {
//         console.dir(recordset);
//     }).catch(function(err) {
//         // ... query error checks
//         console.log(err); 
//     });
// });


const sql = require("mssql");
require("msnodesqlv8");
// const conn = new sql.Connection({
//   database: "ShopMgt",
//   server: "ESAW1\\SHOPSTREAM",
//   driver: "msnodesqlv8",
//   options: {
//     trustedConnection: true
//   }
// });

var config = {
  driver: 'msnodesqlv8',
  connectionString: 'Driver={SQL Server Native Client 11.0};Server={ESAW1\\SHOPSTREAM};Database={ShopMgt};Trusted_Connection={yes}',
};

new sql.Connection(config).connect().then(function(conn) {
    conn.query`select * from SM.Customers`.then(function(recordset) {
        console.dir(recordset);
    }).catch(function(err) {
        // ... error checks
        console.log(err);
    });
}).catch(function(err) {
    // ... error checks
    console.log("ERR:: ", err);
});

// conn.connect().then(() => {
//     console.log("It works!");
//     var request = new sql.Request();
//     var request = new sql.Request();
//     request.input('input_parameter', sql.Int, value);
//     request.output('output_parameter', sql.Int);
//     request.execute('procedure_name', function(err, recordsets, returnValue, affected) {
//         // ... error checks

//         console.log(recordsets.length); // count of recordsets returned by the procedure
//         console.log(recordsets[0].length); // count of rows contained in first recordset
//         console.log(returnValue); // procedure return value
//         console.log(recordsets.returnValue); // same as previous line
//         console.log(affected); // number of rows affected by the statemens
//         console.log(recordsets.rowsAffected); // same as previous line

//         console.log(request.parameters.output_parameter.value); // output value

//         // ...
//     });
// })
// .catch(e => {
//     console.log(e);
// });