Azure Stream Analytics Reference Input: SQL DB Snapshot Error

Kamlesh Khollam 21

Hi Team,

I am using SQL DB as Reference Input in Stream Analytics Job.

When I Start the stream analytics job, Reference Input(SQL DB) shows following error:

I did check my Storage Account Details and it looks correct. But not sure why above error is coming.

PRADEEPCHEEKATLA-MSFT 79,536 Reputation points Microsoft Employee

2020-11-26T12:31:25.823+00:00

Hello @Kamlesh Khollam ,

We are reaching out to the internal team to get more help on this, I will update you once we hear back from them.
PRADEEPCHEEKATLA-MSFT 79,536 Reputation points Microsoft Employee

2020-11-27T11:03:58.833+00:00

Hello @Kamlesh Khollam ,

We are still waiting for a response from the product team. I will let you know once I heard back from the product team.

Stay Tuned!
PRADEEPCHEEKATLA-MSFT 79,536 Reputation points Microsoft Employee

2020-12-03T06:21:12.997+00:00

Hello @Kamlesh Khollam ,

Apologize for the delay in response.

In order to investigate further, could you please check that the IP address is whitelisted in the server network and check if you are able to login to the Azure SQL Database through the Azure Portal?
PRADEEPCHEEKATLA-MSFT 79,536 Reputation points Microsoft Employee

2020-12-08T10:46:38.66+00:00

Hello @Kamlesh Khollam ,

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