Fast Guide

Fast Guide: Controlling access to SQL Server

 

One of your top priorities as a DBA (maybe the top priority) is to secure your SQL Servers, the home to your customer details, human resources data and all business-critical information. You must not only protect SQL Server against external

    Requires Free Membership to View

threats, but the much-more-common internal threats -- and the measures you take to control access will go a long way in achieving that. This guide will walk you through key tips and expert advice to help you control internal and external access to SQL Server, and it will highlight access control enhancements in SQL Server 2005.

TABLE OF CONTENTS
   Controlling internal access
   Controlling external access
   SQL Server 2005 access control
   Additional security resources

 

Controlling internal access Return to Table of Contents
  • Hiding SQL Server
    If you're running SQL Server in an environment where you don't want computers to access it, you must hide the instance from network discovery.

 

Controlling external access Return to Table of Contents
  • Hacker's-eye view of SQL Server
    Hackers can devastate your SQL Server workflow and cripple your company's business. Learn the four primary methods used to hack into SQL Server.
  • Use SQLPing to prevent outside access
    Make sure no listening ports are open for public access on your SQL Server machines -- or you could be relaying sensitive database information to the outside world.

 

SQL Server 2005 access control Return to Table of Contents
  • Granting permissions in SQL Server 2005
    New security features in SQL Server 2005 make it easier to manage and grant permissions on a more granular basis. Get an overview of new features and functions.

 

Additional security resources Return to Table of Contents

 

This was first published in November 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: