DBA Security Advisor

DBA Security Advisor for SQL Server

Analyze your SQL Server Instances for Security Misconfigurations, and get Useful Recommendations using our Powerful SQL Server Security Tool.

DBA Security Advisor, is a powerful SQL Server security tool, which assesses SQL Server instances against a rich set of security checks and detects potential security risks. Moreover, in the Enterprise Edition, you can get recommendations as well as remediation methods and scripts for the detected security risks. Furthermore, there is a history mechanism which allows you to track the progress of your SQL Server instances security by accessing older reports. Secure your SQL Server instances today and protect your data more efficiently!

List of Features

  • *Easily Assess Multiple SQL Server Instances Against a Rich Set of Security Checks
    • The Enterprise Edition of DBA Security Advisor features over than 30 security checks which can help you assess your SQL Server instances for potential security risks.
  • **Recommendations & Remediation Scripts Engine
    • For each detected security risk you get a comprehensive recommendation along with suggested remediation scripts and methods.
  • **Report History
    • With report history you have access to the results of all scan sessions you previously ran. You can use older reports in order to see the progress in securing your SQL Server instances.
  • *Statistics
    • Get useful statistics for each security assessment.
  • Datasheet
    • Get the datasheet for a full list of features and comparison of the Enterprise and Community Editions.
* The full set of security checks is available only in the Enterprise Edition of DBA Security Advisor.
** This set of features is only available only in the Enterprise Edition of DBA Security Advisor.

Why we Built DBA Security Advisor and How Can it Help you?

DBA Security Advisor for SQL Server
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’.
DBA Security Advisor is highly recommended when it comes to SQL Server security and protecting your SQL instances from high-risk configurations.

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

What’s New and System Requirements

Latest Version: 2.1 (Build_20180309_1)

Version Information:

  • Release number: 2.1
  • Build number: 20180903_1
  • Release date: March 09, 2018

What’s new:

  • GUI enhancements
  • Minor bug fixes
  • Added Support for SQL Server 2017


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, 2008, 2008 R2, 2012, 2014, 2016, 2017.

 


Download the Community Edition

The trial version of DBA Security Advisor, is actually a Community Edition, which allows you to use a limited set of security checks but you cannot get recommendations and suggested remediation actions. However, The set of unlocked features in the Community Edition of DBA Security Advisor are enough to help you see its value and usefulness when it comes to SQL Server security. Then, you might consider purchasing the Enterprise Edition and get access to the full power of DBA Security Advisor.

Download DBA Security Advisor (Community Edition):

* DBA Security Adviror, up to version 2.0 was released under the brand name “SQLArtBits”.


Purchase the Enterprise Edition of DBA Security Advisor

Purchase the Enterprise Edition of DBA Security Advisor, unlock all features and protect your SQL Server instances today!

Price for single license: $49.95

Buy DBA Security Advisor Enterprise License

SSL Connection

Help Topic: How to activate the Enterprise Edition

 

*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 SQLNetHub 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 of DBA Security Advisor

DBA Security Advisor for SQL Server - SQL Server Security ToolDBA Security Advisor - SQL Server Security ToolDBA Security Advisor - SQL Server Security ToolDBA Security Advisor - SQL Server Security ToolDBA Security Advisor - SQL Server Security ToolDBA Security Advisor - SQL Server Security ToolDBA Security Advisor - SQL Server Security ToolDBA Security Advisor - SQL Server Security Tool

 

 

 

 


Recommended eBooks

Developing with SQL Server (eBook)

Title: Developing with SQL Server (Second Edition)
Author: Artemakis Artemiou, B.Sc., M.Sc., MCP, MCTS, MCITP, Former Microsoft Data Platform MVP (2009-2018)

Learn how you can efficiently program in SQL Server. Learn about different T-SQL constructs and get useful T-SQL tips. Learn how you can work with unstructured data, data access and more.

Price: $39.99

Learn More | Buy Online

 

Administering SQL Server (eBook)Title: Administering SQL Server (Second Edition)
Author: Artemakis Artemiou, B.Sc., M.Sc., MCP, MCTS, MCITP, Former Microsoft Data Platform MVP (2009-2018)

Learn how to effectively administer your SQL Server databases. Learn about maintenance, security, integration, error handling and more.

Price: $39.99

Learn More | Buy Online

 

 

Tuning SQL Server (eBook)Title: Tuning SQL Server (Second Edition)
Author: Artemakis Artemiou, B.Sc., M.Sc., MCP, MCTS, MCITP, Former Microsoft Data Platform MVP (2009-2018)

Learn how you can tune SQL Server and get the most of it when it comes to performance. Learn about indexes, log files management, locking, blocking and more.

Price: $39.99

Learn More | Buy Online

 


Other Recommended Software Tools


Rate this tool: 1 Star2 Stars3 Stars4 Stars5 Stars (5 votes, average: 5.00 out of 5)

Loading...