Azure SQL Database connector is not showing as connected

Question

Hello everyone,I have integrated SQL database &amp; SQL manage instances to sentinel through diagnostics settings, I send logs categories as follows:&nbsp;SQL Insights, Query Store runtime Statistics, Query Store Wait Statistics, Errors&nbsp;I can see the logs in table “AzureDiagnostics” whereas the connector Azure SQL Database is not disconnected neither the tables are enabled in this connector. If anyone of you faced this issue kindly help me out.Thanks in advance

clive_watson · Answer

Sidra_Raza&nbsp;&nbsp;Hello, What does the Data connector screen look like?&nbsp; &nbsp;If any data is being received you should get a green Bar in the top left and the status will be "connected".&nbsp; Then the Datatypes that have sent data in the last 7days only are shown (look at the code in Log Analytics by clicking the button).&nbsp; Its normal that you might only have one or more data types at any time.&nbsp;&nbsp;&nbsp;&nbsp;

sidra_raza · Answer

Clive_Watson&nbsp;Here is the connector screen&nbsp;&nbsp;

clive_watson · Answer

Sidra_Raza&nbsp;Is that maybe the older version in the Data Connectors blade? The latest is found in the [Content hub]&nbsp; Version 2.0.2:&nbsp;

sidra_raza · Answer

Clive_Watson&nbsp;I will check the version and get back to you.One more Question: How we can integrate SQL virtual machine through diagnostics setting? Do we need to do some sort of configuration on the SQL VM?I don't have the diagnostics setting in the left bar.&nbsp;

clive_watson · Answer

Generally if its a VM, you'd add the AMA agent or use Defender for SQL Servers https://learn.microsoft.com/en-us/azure/defender-for-cloud/defender-for-sql-usage

Forum Discussion

Azure SQL Database connector is not showing as connected

9 Replies