DBA Security Advisor
(Community Edition - Free)

DBA Security Advisor is a powerful security tool which assesses SQL Server instances against a rich set of security checks and detects potential security risks. The Community Edition provides basic functionality with a limited set of security risks and with no recommendations and remediation scripts for the detected security risks. Furthermore, report history is not enabled.

featuresdownloadscreenshots online help buy e. editiondatasheet why we built it

  

Image

Why We Built DBA Security Advisor


You store data in your databases. Data is every organization's most valuable asset. That is why you need to take database security very seriously. You need to prevent unauthorized access, keep your SQL Server instances healthy and patched to the latest service pack, turn off features that are not required by your operations, and the list goes on. We created DBA Security Advisor in order to help you protect your SQL Server databases and in the end of the day, your data. We have included a large number of security checks and for every detected risk we provide recommendations and remediation methods. It is just like we are there and we perform a vulnerability assessment of your SQL Server instances and compile a report. We do just this via our software tool 'DBA Security Advisor'.

Community Edition Features and Limitations


App Screenshot
Limited Set of Security Checks

In the Community Edition of DBA Security Advisor, only the below security check categories are available:

- Server-Level Accesses
- Surface Area
- Authentication and Authorization
- Password Policies

Single Instance Assessment 

In the Community Edition of DBA Security Advisor, you can only assess one instance each time. In the Enterprise Edition you can assess multiple instances in a single run.

 



Recommendations & Remediation Scripts Engine

In the Community Edition of DBA Security Advisor, recommendations and remediation scripts are not available.


Report History & Export Options

In the Community Edition report history is not available as well as certain export options.



Editions Comparison


Compare Editions of DBA Security Advisor
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

Download DBA Security Advisor

Version: 1.0
Build: 20161020_1 (new)

You can download the Community Edition of DBA Security Advisor from the below download links:

 

Awards:

image



System Requirements:

  • Operating System: Microsoft® Windows 7 or later / Microsoft® Windows Server 2008 R2 or later
  • Logical Processors: 4 or more
  • RAM: 4 GB or more
  • Software Requirements:
    • - Microsoft .NET Framework 4.5 or later
    • - Microsoft Excel 2010 or later (part of Microsoft Office)

    • 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.

* Supported SQL Server versions: 2005 or later.


Total Downloads: 341

Purchase the Enterprise Edition of DBA Security Advisor


Read the EULA


*Important Considerations

[1] A single purchased license for DBA Security Advisor's Enterprise Edition allows up to two (2) activations for different hardware configurations but only on the same computer. To this end, if you make extensive changes to your computer's hardware, you can generate a new activation code and run the activation process again. This can only take place once. This means that the after you make use of the second activation (for the same computer), you will not be provided with additional free activations in case of further hardware changes to your computer. In such case, you will need to purchase a new license for the Enterprise Edition and perform a new activation (read the EULA for more info).

[2] During the activation process, and after you enter the serial key that you were provided during your purchase of the Enterprise Edition license of DBA Security Advisor, you need to retrieve and submit to SQLArtBits an "Activation Code". The activation code is a unique hardware hash (a hash is a numeric value derived through a mathematical formula and based upon some other, original value) that is created by running 2 different pieces of information from the computer's hardware components (BIOS id, Mainboard id) through a one-way mathematical transformation. This means that the resultant hash value cannot be backwards calculated to determine the original values and it ensures complete anonymity. This process was developed in order to maintain the user's privacy and it is only used to deter piracy.

Last but not least you can find here the End-User License Agreement for DBA Security Advisor.

Screenshots