|
|
|
 Microsoft SQL Server 2005 MSIT Basic Configuration Pack for Configuration Manager 2007Brief DescriptionThis configuration pack contains configuration items intended to manage your SQL Server 2005 server roles, and was developed based on settings used by Microsoft IT in the configuration of these server roles. On This PageQuick Details
OverviewThe Microsoft SQL Server 2005 MSIT Basic Configuration Pack is designed to be used for managing the configuration of SQL 2005 servers. This configuration pack defines recommended configurations based on a limited number of settings affecting the configuration of SQL 2005 servers in the Microsoft IT environment. More extensive configuration items and settings can be obtained by downloading the Microsoft SQL Server 2005 MSIT Intermediate and Comprehensive Configuration Packs. It is recommended that users begin by evaluating their configuration against the Basic configuration pack, and then progress to the Intermediate and Comprehensive configuration packs as desired configurations are verified.
Once imported into SCCM 2007, this configuration pack and its included configuration items can be targeted to collections of systems which are then audited for compliance with the recommended configurations. When settings are detected to be out of compliance, events will be generated and sent to the Configuration Manager server where the data is available for reporting. This enables early detection of potentially detrimental configuration changes and allows the administrator to correct the settings before they may cause downtime events.
Please note that the configuration items, settings, and values used by Microsoft IT and included in this configuration pack will not necessarily reflect the desired configuration for every possible SQL Server 2005 environment. The administrator should verify that the rules being evaluated reflect the desired configuration for their specific environment. If desired, the administrator can also modify the configuration pack by changing the value(s) specified for given settings-based configuration items or by adding/removing configuration items from the model through the Desired Configuration Management user interface within the SCCM 2007 console. Where settings and values are represented by a Parent and Child configuration item pair, the Child configuration item will contain the editable rules and values that an administrator may choose to modify.
Feature Bullet Summary: The Microsoft SQL Server 2005 MSIT Basic Configuration Pack includes configuration items for the following:
• Instance • System Databases • User Databases • Cluster Core • Cluster Instance • Cluster System Databases • Cluster User Databases In some cases, the settings and values will be represented by a Parent and Child configuration item pair. Please note that the Child configuration item will contain the editable rules and values that an administrator may choose to modify to reflect the desired configuration for their specific environment. To understand in detail what each configuration item will be evaluating please review the properties of that configuration item in the context of the server role being addressed. Configuration Pack Release History: 11/12/2007 - Version 1.0 - Original release of the English version System Requirements
System Center Configuration Manager 2007 InstructionsDownloading and Extracting To download the pack:
Importing the Configuration Pack You can import the configuration pack using the Microsoft System Center Configuration Manager administrative console and following these steps :
For more information about using desired configuration management in Configuration Manager 2007 with imported best practices configuration data from Configuration Packs, see the topic "Desired Configuration Management Administrator Workflows" in the Configuration Manager Documentation Library (http://go.microsoft.com/fwlink/?LinkID=66999 ). What Others Are DownloadingOthers who downloaded Microsoft SQL Server 2005 MSIT Basic Configuration Pack for Configuration Manager 2007 also downloaded:
|
