title: Azure NPM Issue: msnodesql Fails to deploy
body: <p>I'm trying to set up msnodesql (formerly node-sqlserver) with my azure hosted site and am running into some issues.</p>
  
  <p>Essentially I'm getting a deployment failed within Azure. I believe it is due to the fact NPM is trying to install msnodesql on the server but will fail because it would need "node-gyp", Python and C++ 2010 installed (which is not present on the azure side).  Here is the error message I'm seeing</p>
  
  <pre><code>npm ERR! msnodesql@0.2.0 install: `node-gyp rebuild`
  npm ERR! `cmd "/c" "node-gyp rebuild"` failed with 1
  npm ERR! 
  npm ERR! Failed at the msnodesql@0.2.0 install script.
  npm ERR! This is most likely a problem with the msnodesql package,
  npm ERR! not with npm itself.
  npm ERR! Tell the author that this fails on your system:
  npm ERR!     node-gyp rebuild
  npm ERR! You can get their info via:
  npm ERR!     npm owner ls msnodesql
  npm ERR! There is likely additional logging output above.
  </code></pre>
  
  <p>I've been hacking at this error for a while now and nothing seems to fix it.  The best answer I've gotten is to manually include the msnodesql within node_modules (as specified by <a href="http://geekswithblogs.net/shaunxu/archive/2012/11/16/install-npm-packages-automatically-for-node.js-on-windows-azure-web.aspx">http://geekswithblogs.net/shaunxu/archive/2012/11/16/install-npm-packages-automatically-for-node.js-on-windows-azure-web.aspx</a> ).  I feel like that should fix it but alas it does not.  I also tried compiling it against the local x86 node and also just using a prebuilt x86 one (suggested by <a href="http://geekswithblogs.net/shaunxu/archive/2012/09/18/node.js-adventure---when-node.js-meets-windows-azure.aspx">http://geekswithblogs.net/shaunxu/archive/2012/09/18/node.js-adventure---when-node.js-meets-windows-azure.aspx</a> ).</p>
  
  <p>Any other suggestions would be appreciated here.</p>
  
  <p>Also worth noting is it's working in my local environment just fine and can grab data in from the SQL Azure DB I created (once i've whitelisted my IP) using msnodesql running within webmatrix but hitting Azure SQL DB.</p>
  
  <p>I originally had an issue with the DB and the Website in Azure being on different regions, but I corrected that.</p>