Article

Step 3: Check for SQL registrations

Chip Andrews, Contributor

Once you've performed an active scan, follow it up with another good "passive" detection method: the osql -L command. Osql is a tool provided with SQL Server that allows for command-line queries and has a discovery option -L that allows you to query the browser service for SQL server registrations. While not 100% reliable, depending on how well your Windows browser service is synchronizing, it provides a good cross-reference for your active scans by revealing machines that might be behind personal firewalls or that may be using older SQL versions and non-standard ports (thus avoiding your scans).

    Requires Free Membership to View

    Login


HOW TO PATCH SQL SERVER, PART 1

 Home: Introduction
 Step 1: Map your network
 Step 2: Perform an active scan
 Step 3: Check for SQL registrations
 Step 4: Probe remote services
 Step 5: Probe for SSNetlib.dll versions
 Step 6: Directly request version information
 Go to: How to patch SQL Servers, part 2

 

ABOUT THE AUTHOR:
Chip Andrews is the director of research and development for Special Ops Security Inc. and the founder of the SQLSecurity.com Web site, which focuses on Microsoft SQL Server security topics and issues. He is also the author of SQL Server Security.


Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top