Microsoft Security | Microsoft Defender | Microsoft Defender for Cloud
A cloud-native solution that protects workloads across hybrid and multi-cloud environments with threat detection and security recommendations
SQL Server: Defender for SQL Server Configuration Issues – Status Not Displayed
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 22%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
mara7
206
Reputation points
I have an SQL Server, and I attempted to configure Defender for SQL Server. However, even after a day, it has not been configured properly, and the menu showing the "Protected" or "Not Protected" status does not appear as expected. What could be the cause and how can I resolve this issue?
(normal)
(issue server)
Microsoft Security | Microsoft Defender | Microsoft Defender for Cloud
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 81%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Marilee Turscak-MSFT 37,266 Reputation points Microsoft Employee Moderator2024-06-12T00:42:08.27+00:00 Hi @mara7 ,
We are looking into your question and will get back to you as soon as possible.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 17%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Givary-MSFT 35,681 Reputation points Microsoft Employee Moderator2024-06-12T06:23:44.9066667+00:00 @mara7 just wanted to check this is only SQL VM in the subscription experiencing this issue? do you have other SQL VM's which are working as expected ? Also, have you followed the instructions mentioned here - https://learn.microsoft.com/en-us/azure/defender-for-cloud/defender-for-sql-usage
-
mara7 206 Reputation points
2024-06-12T06:52:36.45+00:00 yes. Other Machine are workiing as expected.
-
Givary-MSFT 35,681 Reputation points Microsoft Employee Moderator
2024-06-12T07:22:44.06+00:00 @mara7 Thank you for quick response, while researching internally found a similar case/scenario, how is the vm (having issue) deployed ? when compared to the other vm's which are working as expected, scenario which I am referring noticed publisher details are different for vm's which can cause this issue to happen, review your built-in policy.
-
mara7 206 Reputation points
2024-06-12T07:46:39.8766667+00:00 vm (having issue):
OS: Windows (Windows Server 2019 Datacenter)
- OS: Windows (Windows Server 2019 Datacenter)
- Version: SQL Server 2019 Standard
Normal vm :
- OS: Windows (Windows Server 2019 Datacenter)
- Version: SQL Server 2019 Enterpise
If it is a simple display issue, Please let me know how to check
-
Givary-MSFT 35,681 Reputation points Microsoft Employee Moderator
2024-06-12T08:07:19.8433333+00:00 @mara7 Detailed troubleshooting might be required for this issue, would recommend to open a support team with our team where they will have access to the tools to review further details on your subscription for this issue, so do you have the support contract plan with us where you can raise the support ticket?
-
mara7 206 Reputation points
2024-06-12T08:10:34.8966667+00:00 yes I have
-
Givary-MSFT 35,681 Reputation points Microsoft Employee Moderator
2024-06-12T08:17:48.3+00:00 @mara7 Please help me with the case details to track the resolution internally.
-
Givary-MSFT 35,681 Reputation points Microsoft Employee Moderator
2024-06-26T06:27:37.3066667+00:00 @mara7 Just wanted to follow up and check if the above mentioned issue is resolved ?
Sign in to comment
Sign in to answer