Using SQL Secure to monitor SQL Instances and Databases running on Azure

by Jan 24, 2019

As companies migrate more and more applications and data to the cloud using services like Azure and Amazon, it is important to ensure that the SQL Server instances and databases running in the cloud are monitored to ensure that they are protected from unauthorized access.  Database Administrators need to ensure that permissions are limited to the right levels for users and groups and that configurations are properly configured.

DBAs have used SQL Secure to identify vulnerabilities, analyze user permissions, and set strong security policies for SQL Server instances and databases running on a private network.  Starting with the release of SQL Secure version 3.1, we have added support for monitoring and assessing SQL Servers and databases running on Azure VM or part of Azure SQL Server. We will continue to add features to monitor SQL Servers and databases running on the cloud (Azure and Amazon).  Now you can monitor and analyze user permissions and risks for SQL Server instances and databases running in the cloud (in Azure VM or Azure SQL databases) right along with your SQL Server instances and databases running on your private network. You can download a 2 weeks trial version of SQL Secure to try it out.  Check out http://wiki.idera.com/display/SQLSecure/Monitor+Azure+Databases for more details.  Below are a few screens showing registration, Azure VM SQL Server Instances properties and SQL Secure report for SQL Server instances running on Azure VM:

Register Azure Instances

Review Azure VM SQL Server instances properties

Review reports