Requirement is to read records from sql table and process the record and then put it back to sql . Using azure function for the same .
While trying to connect to SQL database from Azure function after publishing, I am getting an error
"A network - related or instance specific error occurred while establishing a connection to SQL Server The server was not found or was not accessible . verify that the instance name is correct and that SQL Server is configured to allow remote connections ".
While executing locally by giving the connection string in local.setting.json it works fine.
Tried in App settings and also in Connection string of function app setting , getting the above mentioned error.