Features


DBA Security Advisor comes in two editions: (i) The Community Edition which is free but has limited functionality, and (ii) The Enterprise Edition where all security checks and other features are available.


The below table compares the two DBA Security Advisor Editions.

Compare Editions

Feature
Community Edition
Enterprise Edition

7 Categories with more than 30 Security Checks:

  • Server-Level Accesses:
    • Logins – Server Role Association
  • Surface Area:
    • Ad Hoc Distributed Queries
    • CLR Enabled
    • Cross DB Ownership Chaining
    • Database Mail XPs
    • Ole Automation Procedures
    • Remote Access
    • Remote Admin Connections
    • Scan for Startup Procs
    • SQL Mail XPs
    • Trustworthy
    • SA Account Status
    • xp_cmdshel
  • Authentication & Authorization
    • Server Authentication Mode
    • Guest User
    • Orphaned Users
    • Public Database Role
    • SA Account Chec
  • Password Policies
    • Password Expiration
    • Password Policy
    • Checks for SA (password expiration and policy)
  • Auditing
    • Login Auditing Setting
    • Default Trace Enabled Setting
    • Today’s List of Failed Logins
    • Last Password Change
  • Miscellaneous
    • CLR Assembly Permission Set
    • Transparent Data Encryption
    • SQL Server Version
    • Service Pack Inf
  • Advanced
    • Database Engine Service Account
    • SQL Agent Service Account
    • Credentials Check (sa:sa)
    • Credentials Check (user:user)
    • Latest DB Backup Times
    • BUILTIN\Administrators Access
Only the Following Security Check Categories:
  • Server-Level Accesses
  • Surface Area
  • Authentication and Authorization
  • Password Policies
All Security Check Categories:
  • Server-Level Accesses
  • Surface Area
  • Authentication and Authorization
  • Password Policies
  • Auditing
  • Miscellaneous
  • Advanced
Scan Single SQL Server Instance
Scan Multiple SQL Server Instances
Generate Security Report
Generate Recommendations for Security Risks
Generate Remediation Scripts for Security Risks
Security Report Display Options: Display Only Security Risks
Security Report Display Options: Word Wrap
Security Report Display Options: Display in Grid
Security Report Display Options: Display in Text
Security Report Display Options: Suggest Remediation Scripts
Security Report Display Options: View Report in Report Viewer
Security Report Export Options: Export to Excel

Note: You need to have Microsoft® Excel® 2010 or later installed on the same PC on which DBA Security advisor is installed in order to be able to export to Excel.
Security Report Export Options: Export to RTF
Security Report Export Options: Export to Text
Security Report Export Options: Export to HTML
Security Report Export Options: Copy to Clipboard
Security Report Export Options: Print
Program Customizations
Program Options
Report History
Informative Report On Connected Instance(s)
Connected Instances History

 

If you are interested in purchasing a license for the Enterprise Edition of DBA Security Advisor and unleash its full power, please visit the "Licensing / Purchase" section.


You can also download the datasheet here:

In-Memory OLTP Simulator Datasheet

.