Error with msnodesql installation on Azure

[RaketenRonny]

Hey guys,
i have an issue here and can't figure it out. I try to get the msnodesql module on my Azure but it fails each time. I get this error message:

Command: deploy.cmd

Handling node.js deployment.

KuduSync.NET from: 'C:\DWASFiles\Sites\uyb-admin-DEV\VirtualDirectory0\site\repository' to: 'C:\DWASFiles\Sites\uyb-admin-DEV\VirtualDirectory0\site\wwwroot'

Copying file: 'iisnode.yml'

Copying file: 'package.json'

Deleting directory: 'node_modules\node-gyp'

Deleting file: 'node_modules.bin\node-gyp'

Deleting file: 'node_modules.bin\node-gyp.cmd'

Copying file: 'node_modules.bin\handlebars'

Copying file: 'node_modules.bin\handlebars.cmd'

Copying file: 'node_modules\msnodesql\lib\sqlserver.node'

Node.js versions available on the platform are: 0.6.17, 0.6.20, 0.8.19, 0.8.2.

Selected node.js version 0.8.2. Use package.json file to choose a different version.

npm WARN package.json UnLockYourBrain@0.0.1 No README.md file found!

msnodesql@0.2.1 install C:\DWASFiles\Sites\uyb-admin-DEV\VirtualDirectory0\site\wwwroot\node_modules\msnodesql

node-gyp rebuild

C:\DWASFiles\Sites\uyb-admin-DEV\VirtualDirectory0\site\wwwroot\node_modules\msnodesql>node "D:\Program Files (x86)\nodejs\node_modules\npm\bin\node-gyp-bin....\node_modules\node-gyp\bin\node-gyp.js" rebuild

npm ERR! msnodesql@0.2.1 install: node-gyp rebuild

npm ERR! cmd "/c" "node-gyp rebuild" failed with 1

An error has occurred during web site deployment.

npm ERR!

npm ERR! Failed at the msnodesql@0.2.1 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.

npm ERR! System Windows_NT 6.2.9200

npm ERR! command "D:\Program Files (x86)\nodejs\0.8.2\node.exe" "D:\Program Files (x86)\nodejs\node_modules\npm\bin\npm-cli.js" "install" "--production"

npm ERR! cwd C:\DWASFiles\Sites\uyb-admin-DEV\VirtualDirectory0\site\wwwroot

npm ERR! node -v v0.8.2

npm ERR! npm -v 1.1.37

npm ERR! code ELIFECYCLE

npm ERR! message msnodesql@0.2.1 install: node-gyp rebuild

npm ERR! message cmd "/c" "node-gyp rebuild" failed with 1

npm

I am working on node 0.8.2, msnodesql is removed from package.json depencies, content of extracted "msnodesql-0.2.1-v0.8-ia32.msi" is in folder "node_modules\msnodesql". All is pushed to github, but the deploy shows an error each time. Locally it works. So i hope you have some suggestions for me to fix the problem. Let me know if you need more specific explanations. Thanks a lot :-)

[RaketenRonny]

Just want to give you an update:

ich followed a combination of this 2 instructions which prevent the deploy from exit with an error.

http://geekswithblogs.net/shaunxu/archive/2012/11/16/install-npm-packages-automatically-for-node.js-on-windows-azure-web.aspx

http://stackoverflow.com/questions/14420387/azure-npm-issue-msnodesql-fails-to-deploy

important is to use an msnodesql driver for node 0.6.2 and 32-bit. So far there are no deployment errors anymore but the msnodesql driver still isn't working.

Native sqlserver module not found. Did you remember to run node-gyp configure build?
Application has thrown an uncaught exception and is terminated:
Error: Cannot find module '../build/Release/sqlserver.node'
at Function.Module._resolveFilename (module.js:338:15)
at Function.Module._load (module.js:280:25)
at Module.require (module.js:362:17)
at require (module.js:378:17)
at Object. (\10.61.68.153\volume-20-default\a66ec5e89542f977dce2\72f069f5efc14064a325404e53e27bab\site\wwwroot\node_modules\msnodesql\lib\sqlserver.native.js:25:23)
at Module._compile (module.js:449:26)
at Object.Module._extensions..js (module.js:467:10)
at Module.load (module.js:356:32)
at Function.Module._load (module.js:312:12)
at Module.require (module.js:362:17)