error when connecting Stream Analytics job output to Azure SqlServer --"Failed to fetch"--

John Meza 5 Reputation points
2023-03-30T17:31:13.9366667+00:00

Using Stream Analytics job, when defining output to SqlServer db using SqlServer authentication (username/pw, user has connect and dbo for db). the Output details pane, using the Load existing tables control, after validating, returns "Failed to fetch" error.

This same error is returned in the SA Query Test window when using Sql table schema.

I have this query and another query successfully hooked up to another SqlServer db. Can't figure out what is wrong with this db.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,530 questions
0 comments No comments
{count} vote