aws sam local test lambda with mssql db on-premise

I’m trying to test this lambda but every time that I tested gives me NULL. Have a VPC configured. When I tested locally through local VPN it works.
code running local with local VPN

const sql = require("mssql");
const config = {
    server: process.env["DB_HOST"],
    user: process.env["DB_USER"],
    password: process.env["DB_PASSWORD"],
    domain: process.env["DB_DOMAIN"],
    port: process.env["DB_PORT"],
    database: process.env["DB_NAME"],
    options: {
      enableArithAbort: true,
exports.lambdaHandler = async (event, context) => {
  // database connection
  sql.connect(config, function (err) {
    if (err) console.log(err);

    // create a new Request object
    let sqlRequest = new sql.Request();

    // insert to the database
    let sqlQuery =
      "INSERT INTO HUB_SYMBEE_REQUESTS (Contract_Num,Line_User,Request_Date,Status) VALUES ('57371113','user_name',CURRENT_TIMESTAMP,'Active')";
    sqlRequest.query(sqlQuery, function (err, data) {
      if (err) console.log(err);

      //Display the data in the console

      // Close the connection

Fetching lambci/lambda:nodejs12.x Docker container image……
Mounting D:Projectsmy-sls-apphpscnpop as /var/task:ro,delegated inside runtime container
START RequestId: 972b2f81-69c9-11e5-8663-da19b12bc864 Version: $LATEST
END RequestId: 972b2f81-69c9-11e5-8663-da19b12bc864
REPORT RequestId: 972b2f81-69c9-11e5-8663-da19b12bc864 Init Duration: 4787.47 ms Duration: 6.68 ms Billed Duration: 100 ms Memory Size: 128 MB Max Memory Used: 74 MB


Source: StackOverflow