Installation and configuration of SQL Server 2012 database under Win7 system

Due to the requirements of the data Warehouse and data mining courses and the integration of many data analysis tools in the SQL Server database, there are many advantages to the Data Warehouse deployment, OTAP data analysis and so on. Simply write the installation and configuration of the SQL Server 2012 database.

Download of 1.SQLServer Database

SQL Server 2012 databases can be downloaded on the official website: https://www.microsoft.com/zh-cn/download/details.aspx?id=29066, depending on the configuration of the computer, choose a different installation package.

Installation of 2.SQLServer databases

After the download is complete, place all the files in the same folder and install them.

The first step: Find Sqlfull_x86_chs_install.exe under the file, click Open, pop Up an interface, click Run, start the SQL Server 2012 database installation.

Step two: Configuration of variables and installation of data

First, pop up an interface such as: Show various performance requirements

Then, click on the left side of the installation, on the display page click on the new SQL Server standalone installation or existing add features, pop up the following interface:

Click OK to jump to another page, such as:

The product key in the interface is not entered, click Next directly, such as:

In the "I accept the license Terms" box, select Agree and click Next, such as:

Click Next, such as:

Click Install, such as:

Click Next to make the role settings, such as:

Click Next to select a feature, choose it as needed, and choose the location of the shared feature directory, as well:

Click Next, such as:

Click Next, such as:

For example, select the root directory to install, and then click Next, such as:

Click Next to continue the installation, such as:

Click Next, such as:

Select Authentication as mixed mode, and enter the password (this needs to be remembered), add user Management, and then click Next, such as:

Select the service mode and add users, then click Next, such as:

Click Next, such as:

Add users, let's click Next, such as:

Enter the controller name and click Next, such as:

Click Next, such as:

Click Next, such as:

All variables are configured to complete, final installation, click Install, after installation is completed such as:

When you're done, click Close, and the SQL Server 2012 database is installed and then viewed in Control Panel, such as to indicate that the installation was successful.

This is followed by database learning and the deployment of data warehouses, data analysis through OLTP, and so on, in the hope of helping to install SQL Server for the first time.

Installation and configuration of SQL Server 2012 database under Win7 system