question

BParlour-0525 avatar image
0 Votes"
BParlour-0525 asked KranthiPakala-MSFT edited

ASA job SQL database output error

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


azure-stream-analytics
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @BParlour-0525,

Welcome to Microsoft Q&A forum and sorry for your experience.

We have reached out to product team about this error message and will get back to you as soon as we have an update from the team.

We appreciate your patience.

Thank you




0 Votes 0 ·

1 Answer

KranthiPakala-MSFT avatar image
1 Vote"
KranthiPakala-MSFT answered KranthiPakala-MSFT edited

Hi @BParlour-0525,

I see that your issue seems to be resolved form the other thread : https://docs.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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.