I am publishing a node app using Publish-AzureServiceProject. Everything that is not related to sql server is working ok. Upon running a query though, I get the error IM002 ("Data source name not found and no default driver specified")
it looks like the proper drivers are not installed in the production environment? After all I had the same problem when running the service locally, but everything was sorted out after I installed driver from here
So the question is, do I need to install the driver on production as well, and if so, how?
That was indeed the problem. I logged in with remote desktop into the role and installed SQL native client.