Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to use configuration files to install SQLServer failover clusters. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

The SQLServer installer provides the ability to generate configuration files based on system default values and runtime input. You can use configuration files to deploy SQLServer with the same configuration throughout the enterprise. You can also standardize enterprise-wide manual installation by creating a batch file that starts Setup.exe.

Setup only supports the use of configuration files from the command prompt. The order in which the parameters are processed when using the profile is listed below:

The profile overrides the default values in the package

The value of the command line overrides the value in the configuration file

Configuration files can be used to track the parameters and values of each installation. This makes the configuration file suitable for validating and auditing the installation.

Configuration file structure

The ConfigurationFile.ini file is a text file with parameters (name / value pairs) and descriptive comments.

Here is an example of a ConfigurationFile.ini file:

; SQLSERVER2008ConfigurationFile [SQLSERVER2008]; SpecifiesaSetupworkflow,likeINSTALL,UNINSTALL,orUPGRADE.Thisisarequiredparameter.ACTION= "Install"; Specifiesfeaturestoinstall,uninstall,orupgrade.Thelistoftop-levelfeaturesincludeSQL,AS,RS,IS,andTools.TheSQLfeaturewillinstallthedatabaseengine,replication,andfull-text.TheToolsfeaturewillinstallManagementTools,Booksonline,BusinessIntelligenceDevelopmentStudio,andothersharedcomponents.

How FEATURES=SQL,Tools generates configuration files

Insert the SQLServer installation media. Then double-click Setup.exe in the root folder. To install from a network share, locate the root folder in the share, and then double-click Setup.exe.

Follow the wizard until the prepare for installation page appears. The path to the configuration file is specified in the configuration file path section of the prepare for installation page. For more information about how to install SQLServer, see how to install SQLServer2008R2 (setup)

Cancel the installation and do not actually complete the installation in order to generate the INI file.

Note:

The installer infrastructure writes out all the appropriate parameters for the operation that has been run, but does not include sensitive information such as passwords. The / IAcceptSQLServerLicenseTerms parameter is also not written out to the configuration file, which requires that the configuration file be modified or a value provided at the command prompt. For more information, see how to install SQLServer2008R2 from a command prompt. In addition, for Boolean parameters that do not normally provide values from the command prompt, values are included.

Install SQLServer2008 using a configuration file

Configuration files can only be used in a command line installation.

Note:

If you need to make changes to the configuration file, it is recommended that you create a copy and operate on it.

How to install a stand-alone SQLServer instance using a configuration file

Run the installation from the command prompt, and then provide the ConfigurationFile.ini file using the ConfigurationFile parameter.

How to use a configuration file to prepare and complete an image of a stand-alone SQLServer instance (SysPrep)

Prepare one or more SQLServer instances and configure them on the same computer.

Run Image preparation for stand-alone instances of SysPrep deployment from the Advanced page in the installation center, and capture the preparation image configuration file.

Use the same preparation image profile as a template for preparing multiple instances of SQLServer.

Run Image completion of the prepared stand-alone instance from the Advanced page in the installation center to configure the prepared instance on your computer.

Use the WindowsSysPrep tool to prepare an image of the operating system, including unconfigured, prepared SQLServer instances.

Run Image preparation for stand-alone instances of SysPrep deployment from the Advanced page in the installation center, and capture the preparation image configuration file.

Run Image completion for prepared stand-alone instances from the Advanced page in the installation center, but after you have captured the full configuration file, cancel it on the ready to complete page.

The complete image configuration file can be stored with the Windows image to automate the configuration of the prepared instance.

How to install a SQLServer failover cluster using a configuration file

Integrated installation options (create a single-node failover cluster on one node and run AddNode on other nodes):

Run the install failover Cluster option and capture the configuration file that lists all installation settings.

Run the command line failover cluster installation by providing the ConfigurationFile parameter.

On the other nodes you want to add, run AddNode to capture the ConfigurationFile.ini file for the existing failover cluster.

Run command line AddNode on all other nodes that will join the failover cluster by providing the same configuration file using the ConfigurationFile parameter.

Advanced installation options (prepare the failover cluster on all failover cluster nodes, and then run it on the node with the shared disk after all the nodes are ready):

Run Prepare on one of the nodes, and then capture the ConfigurationFile.ini file.

Provide the same ConfigurationFile.ini file for the installer on all nodes that will be prepared for the failover cluster.

Once all the nodes are ready, run the failover cluster operation on the node that has the shared disk, and then capture the ConfigurationFile.ini file.

You can then provide this ConfigurationFile.ini file to complete the failover cluster.

This is the end of the article on "how to use configuration files to install SQLServer failover clusters". I hope the above content can be helpful to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.