Azure Stream Analytics with Reference Input from SQL Database is giving error

Question

I am trying to use Azure SQL Database as Reference Input for an Azure Streaming Analytics job.
Reference Input was added like so,

Connection to Db was tested successfully; sample input from database was also received successfully; and the test run of analytics query also completed successfully.

But when the Analytics Job is started, I get this error:
"Encountered error trying to discover new reference data snapshot. Error: Sql Error occurred while trying to take Sql full snapshot"

I am using 3 SUs for this job.

Answer 1

Hello @Prashanta Shrestha ,

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

For Microsoft's Azure Active Directory to verify if the Stream Analytics job has access to the SQL Database, we need to give Azure Active Directory permission to communicate with the database. To do this, go to the "Firewalls and virtual network"/”Firewalls” page in Azure portal again, and enable "Allow Azure services and resources to access this server/workspace."

For more details, refer to Use managed identities to access Azure SQL Database or Azure Synapse Analytics from an Azure Stream Analytics job (Preview).

One more question - Is the IP used by ASA static?

Currently there are no public IP addresses for Stream Analytics.

Hope this will help. Please let us know if any further queries.

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

• Please don't forget to click on or upvote button whenever the information provided helps you. 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
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators