News Stay informed about the latest enterprise technology news and product updates.

Step 1: Map your network

Learn how to prepare a set of IP address ranges to scan for SQL Server instances in this SQL Server patch management guide.

Prepare a set of IP address ranges to scan for SQL Server instances. The most important thing to remember is to...

never exclude IP addresses in the scan based on the assumption that SQL Servers should not be among them. Second, you should always plan to perform the scan from multiple directions where applicable.

For example, when scanning machines in a demilitarized zone (DMZ), be sure to scan from both the internal network and the Internet. Never assume that traffic coming from another direction is inherently safe. Finally, make sure the appropriate personnel are aware of your scans so you don't set off any alarms and unnecessarily force security administrators into a panic.

HOW TO PATCH SQL SERVER, PART 1

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.

Dig Deeper on SQL Server Migration Strategies and Planning

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close