I'm unable to get my query output saved to an azure sql table
I am unable to get a SQL DB output to work with my analytics job. My job is storing Application Insights export data into a SQL table. The error I'm receiving is that the SQL initialization connection string is invalid. All of the inputs I'm prompted for are correct, and I'm unable to see what connection string the portal is generating for the analytics job. I need assistance determining why the job cannot store output into my table.
- Format of the initialization string does not conform to specification starting at index 87.
Azure SQL Server '', database table .[MyTableName] - Failed to initialize. Error message: Format of the initialization string does not conform to specification starting at index 87., - Format of the initialization string does not conform to specification starting at index 87.
, : OutputSourceAlias:<redacted>;AdapterType:SQL;ShardId:0;
Send Events: Failed to initialize output adapter <redacted>