SQL Server TechCenter

SQL Server 2005 – Security and Protection

Help protect your SQL Server 2005 systems from malicious attacks and improve the security of your data.

Database Engine

The SQL Server 2005 database engine implements a highly scalable and available service for data storage, processing, and security to meet the requirements of the most demanding data systems.

Analysis Services

SQL Server 2005 Analysis Services implements a highly scalable and available service for data storage, processing, and security to meet the requirements of the most demanding data systems.

Integration Services

Microsoft SQL Server 2005 Integration Services (SSIS) is a platform for building high performance data integration solutions, including the extraction, transformation, and loading (ETL) of packages for data warehousing.

Security Considerations for Integration Services

Replication

SQL Server 2005 replication is a set of solutions that allow you to copy, distribute, and potentially modify data across your enterprise.

Security Considerations for Replication

Reporting Services

SQL Server 2005 Reporting Services is a new server-based reporting platform that you can use to create and manage tabular, matrix, graphical, and free-form reports that contain data from relational and multidimensional data sources. The reports that you create can be viewed and managed over a Web-based connection.

Notification Services

SQL Server 2005 Notification Services helps you develop and deploy scalable applications that can deliver personalized, timely information updates to a variety of connected and mobile devices.

Service Broker

Microsoft SQL Server 2005 Service Broker helps developers build scalable, secure database applications. This new technology, a part of the Database Engine, provides a message-based communication platform that enables independent application components to perform as a functioning whole. Service Broker includes infrastructure for asynchronous programming that can be used for applications within a single database or a single instance as well as for distributed applications.

Security Considerations for Service Broker

SQL Server Express Edition

Microsoft SQL Server 2005 Express Edition is a free, easy-to-use, and robust database engine that is ideal for building data-driven applications and Web sites.

Securing Your SQL Server 2005 Express Server

SQL Server Compact Edition

Microsoft SQL Server 2005 Compact Edition, the next generation of SQL Server Mobile Edition, offers essential relational database functionality ideal for embedding in mobile and desktop applications.