I am unable to send the data to SQL database through IoT hub using Stream analytics

Question

When i start the process in stream analytics and then try to write a query in SQL, then it shows the process is degraded and shows a notification failed to initialize output adapter output stream.

Answer 1

Hello @Manikanta Kommur ,

Thanks for the question and using MS Q&A platform.

You may experience the following error message due to network restrictions on the Azure SQL Database.

Make sure the firewall settings of the Azure SQL database, the option "Allow Azure services and resources to access this server" was turned ON.

Hope this helps. Do let us know if you any further queries.

------------

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a notification.