Security Considerations for SQL Server

SQL Server 2005 includes a variety of highly precise, configurable security features. These features can empower administrators to implement defense-in-depth that is optimized for the specific security risks of their environment.

The following table lists important security-related topics.

Topic Description

Securing SQL Server

Provides an overview of securing SQL Server.

Security Considerations for a SQL Server Installation

Describes preparing the Windows server and network for an installation of SQL Server 2005.

Setting Up Windows Service Accounts

Describes the minimum Windows-related rights and file permissions that are required by services that are installed by SQL Server 2005.

Surface Area Configuration

Describes how to minimize the vulnerable surface area of an installation of SQL Server 2005.

Security Considerations for Databases and Database Applications

Describes the security features of the SQL Server 2005 Database Engine.

Securing Analysis Services

Provides an overview of security in SQL Server 2005 Analysis Services (SSAS).

Security Considerations for Integration Services

Provides an overview of security in SQL Server 2005 Integration Services (SSIS).

Security Considerations for Replication

Provides a general overview of security in replication.

Securing Reporting Services

Describes the options for configuring security in SQL Server 2005 Reporting Services (SSRS).

Security Considerations for Notification Services

Provides an overview of security in SQL Server 2005 Notification Services.

Security Considerations for Service Broker

Provides a general description of security in SQL Server 2005 Service Broker.

CLR Integration Security

Provides an overview of security-related aspects of CLR Integration.

Security Catalog Views (Transact-SQL)

Lists the security-related metadata visible in catalog views that are optimized for performance and utility.

Security Functions (Transact-SQL)

Lists the functions that return information that is useful in managing security.

Cryptographic Functions (Transact-SQL)

Lists the functions that support encryption, decryption, digital signing, and the validation of digital signatures.

See Also

Other Resources

SQL Server Overview
Security Tutorials

Help and Information

Getting SQL Server 2005 Assistance