title: Node-SQL with node.js and MS integrated Security
body: <p>I have some sample code that is successfully connecting to SQL Server using Microsoft SQL Server user name and password. But I was wondering if there is a way to use integrated security with this script. Basically which means use the logged in user's credentials without supplying a password in the script.</p>
  
  <pre><code>var sql = require('mssql');
  
  var config = {
      server: '127.0.0.1', 
      database: 'master',  
      user: 'xx',
      password: 'xxx',
  
      options : {
          trustedConnection : true
           }
  }
  
  
  var connection = new sql.Connection(config, function(err) {
      // ... error checks
      if(err) {
      return console.log("Could not connect to sql: ", err);
      }
  
      // Query
  
      var request = new sql.Request(connection);
      request.query('select * from dbo.spt_monitor (nolock)', function(err, recordset) {
          // ... error checks
  
          console.dir(recordset);
      });
  
      // Stored Procedure
  
  
  });
  </code></pre>