Detailed explanation of sqlserver2012 installation

Installation environment:

System: Windows 2012 R2 Datacenter

Database: SQL_Svr_Enterprise_Edition_2012_w_SP1

Start the installation:

1. Double-click setup.exe

2. Install, click "install a new SQL Server standalone or add features to an existing installation"

3. Installer support rules: view the detailed report status "passed" and click "OK"

4. Product update: install the installer file and click "next"

5. Install the installer file: wait for the SQL server installer file to be installed (wait for the green progress bar to finish), and click install

6. Installer support rules: check the status "passed" and click "next"

7. Product key: enter the product key (the purchased SQL serial number), and click "next"

8. License terms: check "I accept the license terms" and click "next"

9. Set roles: select "SQL Server feature installation", and click "next".

10. Function selection: click "Select all" and click "next"

11. Installation rules: check the status "passed" and click next. # warnings can be ignored

12. Instance configuration: select "default instance" and click "next"

13. Disk space requirements: click "next"

14. Server configuration: SQL Server proxy. Click the arrow at the startup type, change it manually to "automatic", and click next # automatic backup of the database needs to enable the proxy service.

15. Database engine configuration ①: server configuration, select "mixed mode", and specify the sa account password. Click add current user, click next

16. Database configuration ②: data directory, change the c of the data root directory to d, and click the next step # c to change it to d, that is, all the new added databases will be created on d disk in the future. Avoid the failure of C disk system and the loss of database files.

17. Analysis Services configuration: server configuration. Click add user, and click next.

18. Reporting Servers configuration: select "install and configure", select "install only", and click "next"

19. Distributed replay controller: click "add current user" and click next

20. Distributed replay client, click "next"

21: error report, click next

22. Installation and configuration rules, view the detailed report status "passed", and click "next"

23. Prepare for installation: click "install"