"Original" SQL SERVER 2012 Installation Configuration instructions (multi-image detailed)

1. Install the software first

1. NET framework3.5.

2.3.5 support is required before installing SQL SERVER 2012. The win 2012 system can be installed in the add roles and features of system administration, and the components under ". NET Framework 3.5 features", ". NET Framework 4.5 Features" are all checked.

3. Install the above content need to configure a source, because some installers are external, not the system comes with, so you need to install the Windows system disk before installation, and then specify the source. Such as

2. Installing SQL SERVER 2012

Execute Setup.exe, click on the Installation page, select "New SQL Server standalone installation or add features to an existing installation"

Enter the Product Key

Tick "I accept the license terms"

Checking for updates will download patches, which are recommended to skip the scan or disconnect the network before installation, because the check is likely to persist for a long time, even if it fails to download.

Tick the features that need to be installed.

It is recommended that you change the default installation directory to a non-C drive, because SQL Setup is relatively large.

The instance name can be either default or custom, and a server can have more than one SQL Server installed as long as the instance is different.

Turn on Blending mode and click Add Current user to designate the Windows user who is currently installing SQL as an administrator.

It is recommended to change the corresponding directory to a non-C drive path, you can create your own rules of the path, easy to develop and use.

Here are the two modes of OLAP, after selecting the mode you need, click Add Current user, you can specify the Windows user who is currently installing SQL as Administrator.

Specify the appropriate OLAP directory.

Click Add Current user to distributed Replay controller server permissions.

Enter the name of the controller

Start installation

3. Installing the SP3 patch

After installing SQL Server, install the SP3 patch pack.

4. Common basic Settings

Open the SSMS management client, select Tools, Options

Set line numbers, wrap lines.

The designer does not select "Prevent saving changes that require re-creation of the table", and after checking, the edit table structure save is never saved.

The maximum server memory limit for SQL Server, because SQL Server always consumes server memory constantly, so it is generally necessary to set the maximum memory usage, usually about 90% of the total server memory.

"Original" SQL SERVER 2012 Installation Configuration instructions (multi-image detailed)