-3

I sent json format from Esp8266 to iot hub but I can't send data from iot hub to sql database by Stream Analytics

enter image description here

enter image description here

enter image description here

enter image description here

When I test query in Stream Analytics job, it's ok but I run Stream Analytics job data can't record to sql database and informed that "degraded"

enter image description here

Tony
  • 9,672
  • 3
  • 47
  • 75
Mic
  • 1
  • 1

1 Answers1

0

It sounds like your job may not have the correct permissions to the SQL database.

I suggest configuring a Managed Identity for your Stream Analytics job and using that to create a user with the required permissions in Azure SQL DB as described here

Martin Cairney
  • 1,714
  • 1
  • 6
  • 18