title: Connect to SQL Server with knexjs, Unable to acquire a connection
body: <p>After trying looking at dozens of examples, and reading most of the docs, and trying many different variations, and changing many settings within SQL Server,  I've finally broke down to ask for help with this one.</p>
  
  <p>I successfully connected to a tblTextKnex with mssqljs using the exact same connection string which SQL Server accepts, but have not been able to with knexjs for some time now.</p>
  
  <p>I get the following warning and error:</p>
  
  <blockquote>
    <p>Knex:warning - calling knex without a tableName is deprecated. Use knex.queryBuilder() instead.</p>
  </blockquote>
  
  <p>and </p>
  
  <blockquote>
    <p>Unhandled rejection Error: Unable to acquire a connection</p>
  </blockquote>
  
  <p>This is the unsuccessful/offending code that I believed should work.</p>
  
  <pre><code>  var knex = require('knex')({
      client: 'mssql',
      connectionString: "Initial Catalog=TextKnex;Data Source=localhost\\TESTINSTANCE;User ID=my_user_id;Password=my_password;Integrated Security=SSPI;"
    });
  
    knex().connection().then(() =&gt; {
       knex('TextKnex').table('Products')
          .select('Products.Price as Price')
          .then((product) =&gt; {
              console.log('log product', product);
              console.dir('dir product', product);
              logger.info('Query Data: %j', product);
       })
    });
    knex.destroy();
  </code></pre>