SQL Server Enterprise Edition installation process (including how to set each step and why)

First, start the installer, click on the "Install" tab, select "New SQL Server standalone installation or add features to an existing installation". (Select this option for the first time you install a database system or add functionality to an existing database system)

Second, the installer then carries out the "Installer support rules" test to analyze whether the prerequisites for installing SQL Server Enterprise Edition successfully are met. If there is one or more conditions (rules) that do not pass, the installation process will not work and the failed entry must be corrected to continue. If both are satisfied (all rules have a status of passed) click "OK".

Third, enter the product key and click "Next":

Four, tick "I accept the License terms" and click "Next"

V. If you want to install all the module functions of the SQL Server database system, tick "all features with default values" and click "Next". (The third "all features with default value" is mostly a module of shared functionality compared to the first SQL Server feature installation, which can be seen on the next page)

Six, all features "Select All", and specify the "shared feature directory" path (the path is generally used by default), click "Next"

Seven, the installation program for "Installation Rules" detection, if all pass, then click "Next"

Viii. Specify the name of the SQL Server instance and the installation path (the installation path typically takes the default) and click Next. (The operating system can install a new SQL Server database system under each login account, each installation is to install an instance of SQL Server, just like an instance of a class in the object-oriented language, you need to take a name for this instance, and specify the installation path, An installed instance of the operating system can be seen in the window, and of course the new instance name cannot be duplicated with the database system instance name that already exists in the operating system. ）

IX. Setup to see if the disk space required to install SQL Server meets the requirements, then continue to click Next.

X. Specify which accounts can use the services in the SQL Server database system and provide the password corresponding to the account. These accounts can be the account in the database system, or the account in the operating system, if it is set as an account in the operating system, it is recommended that each service is set to the same account, so as not to use multiple services at the same time (default is set as a database system in some of the built-in accounts, this setting, These services can be used regardless of which operating system account the user uses to log on to the operating system, where I set up an administrator account Antonoil\lichuandong for logging into the native operating system, so if you are not using an account antonoil\ Lichuandong logging on to this computer's operating system, you will not be able to use these services in the database system, of course, the password is the operating system account corresponding password. ) Continue to click "Next". The startup type can be either default or can be modified as needed.

Xi. Configure the database engine in the database system: generally tick "mixed mode SQL Server Authentication and Windows Authentication" and for the SQL Server system administrator account (the administrator here refers to the administrator of the database system): SA Specifies the account password, There is also a need to specify an administrator for the SQL Server database (the administrator here refers to the operating system's account), typically specifying the account currently logged into the operating system as the administrator of SQL Server, so click "Add Current User button". Click "Next". (Need to understand: The database system can have multiple accounts, the account type has administrator and non-administrator, by default, the database system administrator account is SA.) Note the difference between the operating system account and the database system account and the connection here.

12. Configure Analysis Services in the database system: The previous step, where the current user is added as an Analysis Services administrator. Click "Next"

13, the Reporting Services in the database system configuration: The general use of the default configuration can be. Click "Next"

14. Specify which users have permissions to the distributed Replay controller: General "Add Current User", click "Next"

Specify the appropriate controller and data directory for the distributed Replay client: The default is generally used.

16. Confirm the SQL Server 2012 database System functional module to be ready for installation: Click "Install" directly

17, after the installation, will return to the installation results, in the results window can see whether all the modules of the database system are installed successfully (status is displayed as successful). If a module installation fails, you can repeat the entire process and reinstall the functional module that is not installed successfully. In general, during the installation process of the several "installation rules" of the detection, if there are no failed conditions, can be successfully installed.

Description: If "error occurred while enabling Windows feature NetFx3" appears in the installation process, please refer to my other blog post detailing the causes, analysis, and workarounds for the error: http://www.cnblogs.com/ Eastliroar/p/4052017.html

October 26, 2014 14:29:50

SQL Server Enterprise Edition installation process (including how to set each step and why)