Upcoming webinar        Getting Ready for the GDPR: How LepideAuditor Helps       Thursday 1st March 2018        3:30pm GMT      

Register Now

SQL Server Auditing

It’s fair to say data is more important today than ever before and at the heart of many organizations the database of choice is SQL server. The implications of a SQL server issue can be catastrophic – whether its downtime, data leakage or just a simple administrator error. We think it’s important organizations are prepared for when this happens. The issue, as we see it, is the out of the box features the auditing tools provide are somewhat reactive and limited. This is why we created LepideAuditor for SQL Server. It provides a simple means of seeing who, what, where and when changes are made to your SQL servers and automatically sends you real-time or threshold-based alerts and detailed reports when needed. It even helps you keep track of the overall health of your SQL Servers.

360-view of all configuration and permission changes

Lepide SQL Server Auditor provides you with a complete overview of all configuration and permission changes being made to your SQL Server environment through an easy-to-use, graphical user interface. At a glance, you will be able to see all configuration and permission modifications made to SQL Server, the total number of changes per administrator and the total number of changes per source. It even displays those changes over time to make it easier to spot change/event anomalies. All these changes are fed continuously through our LiveFeed, to ensure that you are proactively auditing SQL Server.

Granular reports to help audit SQL Server

Over the years, we’ve listened carefully to our customers and have created a library of the most common requirements surrounding SQL server auditing which now forms the basis of our report library. These include reports to show login changes, top users, active databases, changes to objects, changes to tables, replication, roles and jobs to name but a few. As with all of our reports – our whole approach is to show you a single log, for a single change… detailing the who, what, where, when and where from information. These reports can be saved in PDF, CSV or MHT formats on the disk and scheduled to be delivered in these formats through email or by saving at a shared location. You can also delegate access to view these reports to users on a web-based secured console.

Alert on configuration and permission changes as they happen

As you know, if you’re reacting to a configuration or permission change that has occurred a while ago, it’s likely you’re already too late to prevent the damage done. In order to truly take advantage from proactive and continuous SQL Server auditing, you need to get real-time or threshold-based updates of these changes taking place. These alerts can delivered to the console as updates, emails and to the LepideAuditor App as push-notifications. You can execute your own custom script (to perform any task like disabling a user account) upon detecting a critical event to proactively secure your SQL environment.

Track changes on the go with our LepideAuditor App

LepideAuditor for SQL Server makes it easy for IT teams to keep track of changes on mobile devices. SQL Server changes can be monitored on the go through the LepideAuditor App (available for both Apple and Android devices). It provides a live feed of all configuration changes, such as addition or deletion of a user account, changing the permissions of a user or deletion of a database/table/SQL object. Read more

Compliance Reports

Our predefined comprehensive audit reports help you achieve the requirements of regulatory compliances such as FISMA, GLBA, SOX, HIPPA, and PCI. You can schedule these reports to be sent to multiple recipients periodically via email or by saving at shared location. These reports can also be delegated to users for viewing on a secured Web Console. Read more

In-depth Auditing of SQL Configuration Changes

With Lepide SQL Server Auditor implemented in your organization, all aspects of SQL server can be audited with ease. All changes made to the configuration of SQL users, permissions, logins, triggers, databases, and other SQL elements are audited. The raw logs are parsed to create the meaningful audit data, saved for long-term in a SQL Server database, and displayed in predefined audit reports. You can customize these reports to create a long audit-trail to understand how a change was made and to track a specific critical change.

Audit SQL Server Permission Changes

Protecting critical assets from being compromised is a major priority for most organizations. LepideAuditor for SQL Server lets you track changes made in the permissions of users and their server roles. It sends real-time alerts (with advanced filters and threshold limits) for every change made in SQL Server permissions. Automatically runs user-created scripts to maintain an appropriate incident response strategy.

Track all SQL User Modifications

User account changes in the SQL Server could affect the normal functioning of an organization or even bring everything to a complete halt. LepideAuditor offers a dedicated set of consolidated reports from which you can get granular details of changes such as user created, deleted or modified. You can quickly determine what changes were made, who made the changes and when they were made. The real-time alerts keep you notified on critical user changes through email or push-notifications sent to the LepideAuditor App.

Detect changes made to SQL Logins

Logins are created in SQL Server to allow local or Active Directory users to access SharePoint Server. Mostly, permissions are assigned to these logins, meaning that regular and proactive auditing is crucial to maintain IT security. LepideAuditor for SQL Server audits every change made in the logins and keeps administrators updated with real-time alerts.

Our SQL Server health check feature

Monitor health of your SQL Server

HealthCheck feature is an inbuilt feature in Lepide SQL Server Change Auditing solution that provides a simple and powerful means of keeping track of important elements of your server to ensure continuity and health. It provides continuous monitoring and real time alerting keeping track of services, CPU usage, connections, error rates, usage and much more.
Read more

SQL Server audit delegation

Secure SQL Server Audit Delegation

While you may want specific users to see certain SQL audit reports it’s quite likely you won’t want everyone to have full access to the console. We offer a secure web based console in which IT teams can grant access to only specific reports to be accessed.

Read all reviews

Read all stories

Try LepideAuditor™

Lepide® is a registered trademark of Lepide Software Private Limited. © Copyright 2018 Lepide Software Private Limited. All trademarks acknowledged.