First, pre-installation preparation
1. Requires the. Net Framework 3.5 to automatically update the installation before SQL2008 R2 is installed
2. Requires Widnows PowerShell support, WPS is a very powerful shell application, the command is compatible with Dox/unix and supports direct invocation of the. NET module for line command editing, which is a very worthwhile tool for in-depth research (in SQL2008 R2 installation will be updated automatically during installation)
3. Need to ensure successful startup of Windows Installer, requires more than 4.5 versions (check service boot status service.msc)
4. Requires MDAC2.8 SP1 support (XP is integrated in the system above)
5. The A8 database must be selected for SQL SERVER R2, and Visual Studio 2008 installed on the machine will need to reinstall version R2.
II. Installation and configuration process
1. For the SQL Server Installation Center, select the "Install" option, install SQL2008 on the new PC R2 can directly select the "New SQL Server standalone installation or to the existing installation features", will install a default SQL real column, such as
2. Function selection, for only the database server installation, the choice of functions can be based on the actual work needs to be developed, I generally choose: Database Engine Services, client tools connectivity, SQL Server Books Online, management tools-BASIC, management tools-complete. Where the Database engine service is the core of the SQL database, the analysis and Reporting Services can be installed as per the deployment requirements, and these services may require IIS support. Such as:
3. Real-column settings, you can directly select the default instance for installation,(it is important to note that if you have SQL2000 or SQL2005installed on the server, do not use their instance name for upgrade processing, make sure to create a new instance name),
4. Server configuration, the server configuration is primarily the configuration of the service startup account, the account name of the service is recommended to use the NT AUTHORITY\SYSTEM System account, and specifies the startup type of the currently selected service,
5. Database engine configuration, in the current configuration mainly set the SQL login authentication mode and account password, and SQL data storage directory, authentication mode is recommended to use mixed mode for authentication, during the installation of the built-in SQL Server system Administrator account (SA) password is more special, SQL2008 's password strength requirements for SA are relatively high and require uppercase and lowercase letters, numbers, and symbols, otherwise you will not be allowed to proceed with the installation. In specify SQL Server administrator, it is best to specify the native system administrator administrator.
Click Next to install the configuration steps to complete!
Reference article:
1. SQL server2008 Installation Tutorial
"Sqlsever 2008R2" Sql Sever 2008R2 Installation and configuration