Product Reviews

AppDetective for SQL Server

Exposing holes in your SQL security

AppDetective is a new security auditing tool that actually covers a variety of servers, including Oracle and Lotus Domino as well as SQL Server, with more editions planned for the future. I took a look at the SQL Server version, testing it with some SQL Server databases on my network—one "out of the box" and one that I thought was pretty well up to date.

Using AppDetective is a three-step process. First, you scan your network, looking for servers using the target software. Second, you can run "Pen Tests" against any server. A Pen Test (or penetration test) is a test that doesn't use any special knowledge about the server; it just looks for problems that can be found from outside. Third, you can run audits, which require a valid login for the server. An audit can check for problems such as easy-to-crack passwords and buffer overflows.

Well, it turns out that even my "up to date" server had problems—there's a Microsoft hot fix that I'd missed installing. And the out of the box server was, of course, a security disaster waiting to happen. AppDetective made short work of even comprehensive scans against these servers, coming back with results in a matter of minutes.

You can download a functioning evaluation copy from the Application Security web site. If you choose to purchase, you also get access to periodic updates so that it can continue to monitor your network for the latest vulnerabilities.

About the Author

Mike Gunderloy, MCSE, MCSD, MCDBA, is a former MCP columnist and the author of numerous development books.

Featured

  • How To Enable Guest Access for Office 365

    While it's possible to give outside users access to certain content in your organization's Office 365 environment, the process of setting them up requires a few extra steps.

  • Microsoft Now Supports OpenSSH in Windows Server 2019

    Microsoft announced on Tuesday that the OpenSSH solution used for remote management is now a supported "Features on Demand" addition in both Windows 10 version 1809 and Windows Server 2019.

  • Microsoft's December Security Patches Includes Fixes for Two Active Exploits

    Microsoft ended the patch year on Tuesday with a whimper of sorts, releasing an estimated 39 security fixes in its December bundle plus one security advisory, according to a count by Trend Micro's Zero Day Initiative.

  • Microsoft Edge Browser To Get New Rendering Engine but EdgeHTML Continues

    Microsoft isn't exactly killing off its EdgeHTML rendering engine, even after declaring plans to use Chromium open source technologies in its Edge browser.

comments powered by Disqus
Most   Popular

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.