Azure SQL Database connector is not showing as connected

[Sidra_Raza]

Hello everyone,

I have integrated SQL database & SQL manage instances to sentinel through diagnostics settings, I send logs categories as follows:

SQL Insights, Query Store runtime Statistics, Query Store Wait Statistics, Errors

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

[#2]

@Sidra_Raza 

Hello, What does the Data connector screen look like?   If any data is being received you should get a green Bar in the top left and the status will be "connected".  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).  Its normal that you might only have one or more data types at any time.  

[#3]

@Clive_Watson Here is the connector screen

[#4]

@Sidra_Raza 

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

[#5]

@Clive_Watson 

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.

[#6]

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

[#7]

I have installed the latest version of SQL Database connector but the connector is still showing as disconnected.

[#8]

Do you have any data now (even if the connector is showing as disconnected)?

[#9]

Yes I can see the data in AzureDiagnostics table.

[#10]

What should I do now? Should I open support ticket with Microsoft?