title: Node.js and mssql connection
body: <p>I created this Microsoft SQL Server and a database with two tables in it. I am using Node.js for the backend but I am having trouble making a connection from node.js to mssql. I am using Visual Studio and have all the required frameworks and packages needed. I am not getting any errors but I'm also not getting the output. I want to understand if its connected and I want the code to work. My node.js and SQL are working fine though.</p>
  <pre><code>    const sql = require('mssql')
      const sqlConfig = {
  
      server: &quot;10.0.0.102\\MSSQLSERVER&quot;,
      port: 1433,
      pool: {
          max: 10,
          min: 0,
          idleTimeoutMillis: 30000
      },
      options: {
      encrypt: true,
      trustServerCertificate: false
      }
  }
  
  async () =&gt; {
      try {
       // make sure that any items are correctly URL encoded in the connection string
       await sql.connect(sqlConfig)
       const result = await sql.query`select * from multiuserlogin`
       console.dir(result)
      } catch (err) {
       // ... error checks
      }
  }
  </code></pre>