question

ManikantaKommur-8428 avatar image
0 Votes"
ManikantaKommur-8428 asked PRADEEPCHEEKATLA-MSFT commented

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

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.

azure-stream-analytics
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.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @ManikantaKommur-8428,

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.

108974-image.png

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.


image.png (24.3 KiB)
· 2
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.

Hello @ManikantaKommur-8428,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

Hello @ManikantaKommur-8428,

Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.

0 Votes 0 ·