Access SQL database from Azure Function in NodeJS

Question

I'm trying to create an Azure Function which is triggered by a http request and then selects data from a SQL database, it then returns the data.

I've tried to set up a basic example that simply connects to a database by following the example here: https://msdn.microsoft.com/library/mt715784.aspx It isn't Azure Function specific but i thought that it should run:

var Connection = require('tedious').Connection;  
var config = {  
    userName: 'userName',  
    password: 'password',  
    server: 'databaseServer.database.windows.net',  
    options: {encrypt: true, database: 'AdventureWorks'}  
};  

module.exports = function(context, req, saasSql) {

    var connection = new Connection(config);  
    connection.on('connect', function(err) {  
        if(err) {
            context.log(err);
        } else {
            context.log("Connected");  

            context.res = {
                body: 'Connected'
            };
            context.done();
        }
    });  
};

However when this runs (triggered in the admin console). I get a log message to say that the function started and then nothing else in the logs. The Output window at the bottom gives a Status: 502 Bad Gateway and this message: Authentication is enabled for the function app. Disable authentication before running the function.

I guess that this is because I'm not calling context.done() as authentication is turned off for this function. I can't seem to work out how to get any error info etc out of the connection attempt, I've tried binding to the error event as well but nothing gets fired.

UPDATE

The error message was a bug in the Azure Functions code and was displaying the incorrect error. However, the above code still does not run (and no error is thrown). It run's fine when I create a local node server and run that way so it seems like an issue with running in the Azure Functions framework. Is there any way to connect to a SQL DB from an Azure Function?

mathewc · Accepted Answer · 2016-09-08 23:05:17Z

1

The error message "Authentication is enabled for the function app. Disable authentication before running the function." indicates that you've enabled the Authentication / Authorization feature of your Function App. That will prevent the portal from being able to invoke your Http function because authentication is required. Note that this authentication is different than the function level authentication you configure in the Functions Portal.

So currently the only way for this to work is for you to do as the error message says - disable the Function App level auth. We have a tracking item in our repo to improve this (issue here).

edited Sep 8, 2016 at 23:05

answered Sep 8, 2016 at 22:40

mathewc

13.6k2 gold badges48 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

smuff Over a year ago

Authentication is already off for this function. I've been doing some testing of this and it seems that the message is shown also when the function never calls done() I guess it's Azure shutting it down after being idle for a period of time.

mathewc Over a year ago

That error message is pretty specific to the scenario I described. If you're saying you don't have Web App Authz enabled and this is still happening, please log a bug here: github.com/projectkudu/AzureFunctionsPortal/issues.

smuff Over a year ago

Issue raised, auth is turned off for the web app. Do you have any examples of connecting to a SQL DB from a node function. I've tried the tedious approach above, and also the integrations but can't get anything to work.

Collectives™ on Stack Overflow

Access SQL database from Azure Function in NodeJS

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related