ASA job SQL database output error

Question

I am getting the following log error when I attempt to run my stream analytics job:

"Initialize Adapter: Failed to initialize output adapter SQLdatabase"

Would appreciate some help on what causes this error? The query is simply saving incoming IoT Hub data into an azure SQL table.

Many thanks,
Brett

Answer 1

Hi @BParlour ,

I see that your issue seems to be resolved form the other thread : https://learn.microsoft.com/answers/questions/362746/index.html. Appreciate much for sharing the details and helping the community.

Sharing the resolution details here as it can be beneficial to other community member if anyone else face the same situation.

The issue is related to Azure SQL Database firewall settings. It does have network restrictions which has resulted in this error message. Under the firewall settings of the Azure SQL database, the option "Allow Azure services and resources to access this server" was turned off. Turning on has solved the problem.

I have also provided a feedback to the product team to improve the error message more specific to the issue. If you have any additional feedback, I would also encourage you to please share it in Azure Stream Analytics user voice forum : https://feedback.azure.com/forums/270577-stream-analytics and please do share the feedback link here so that other users with similar idea can up-vote and/comment on it to increase the priority.

Do let is know us you have further query.

Thank you

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.