This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(304, 61%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
SQL Server normally has alerts, this feature is not available on Azure SQL Instance as a service. What do I have to do or purchase to get this functionality?
PS everybody knows that alerts are not available with sql instance as a service or sql as a service.
Hello Robert,
Are you referring to Azure SQL Database or Azure SQL Managed Instances?
What types of alerts are you wanting to receive from Azure SQL via email?
Regards,
Eric
Managed instance in my case, but the feature is not available for managed sql either.
Hi @Sawyer, Robert E If you are referring to SQL server Managed Instance. Please check this thread if this is similar to your ask.
https://learn.microsoft.com/en-us/answers/questions/1051661/index.html
If this is not similar to your ask. Please let me know what type of alerts you are trying to create.?
Regards,
Oury
![](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(188.79999999999998, 12%, 28%)' 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)
@Sawyer, Robert E Just checking in to see if the below answers helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Regards
Geetha
Ok, here is the stupid answer,
Create a job that queries the event logs and send an email if it sees a login failure. Keep a table with the last time it ran and filter the results by time.
However, I don't seem to be able to query the event logs either.
You can send alerts using dbmail on Managed Instance as explained on this documentation. You can use sp_readmierrorlog to read Managed Instance error log as explained on this documentation.
writing a crustom job that continuously runs is what I was trying to avoid.
It has been done already here, you can copy and use the solution provided.
That looks somewhat useful but that is what I was trying to avoid. The error log has hundred of thousands of rows, I don't want to have to read it every minute to capture login failures.
I hope you find somebody else to give you a better alternative. Meanwhile let give you more information, you can still use sp_readerrorlog but sp_readmierrorlog returns 1% of the volume returned by sp_readerrorlog. sp_readmierrorlog returns the contents of the instance error log, filtering out messages that are unlikely to be useful to an MI customer, so it shows less messages.
However, I agree Managed instance can generate 2,500 messages in a minute.
![](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(224.00000000000003, 59%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
If you are looking for a way to check login failures, you should look at setting up security auditing on the database or server. You can send the audit logs to storage, Event Hub or Log Analytics. Querying results in Log Analytics is not hard to do. All is described here: https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-overview?view=azuresql
An other approach would be to make use of Azure SQL triggered functions. A function is triggered every time something changes in a table in the database (insert/update/delete). See https://learn.microsoft.com/en-us/azure/azure-functions/functions-bindings-azure-sql?tabs=in-process%2Cextensionv4&pivots=programming-language-csharp. This functionality is still in preview though.