Installing the SQL Server Database

Context

The following describes the procedure for installing the SQL Server database on Windows Server 2012 R2 Standard (64-bit).

If the Microsoft .NET Framework window is displayed during the installation, indicating that an exception that cannot be resolved occurs and the system cannot find a specific file, such as (C:\Users\Administrator\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\11.0.0.0\user.config lin 5), delete the corresponding file and click Continue to solve the problem.

Procedure

1. Log in to the server as the Administrator user.
2. Microsoft .NET Framework 3.5 has been installed on the server. For details, see How Do I Install Microsoft .NET Framework.
3. Insert the database installation disc and execute the setup.exe file in the root directory on the disc to start the installation.
4. Optional: Click OK. The system automatically configures Microsoft .NET Framework 3.5.

   The SQL Server Installation Center dialog box is displayed.

5. Choose Installation > New SQL Server stand-alone installation or add features to an existing installation.

   The Setup Support Rules dialog box is displayed.

6. Click OK.

   The Product Key dialog box is displayed.

7. Select Enter the product key:, enter the serial number, and click Next.

   The License Terms dialog box is displayed.

8. Select I accept the license terms and click Next.

   The Install Setup Files dialog box is displayed.

9. Click Install.

   The Setup Support Rules dialog box is displayed.

10. Click OK.

    The Setup Role dialog box is displayed.

11. Select SQL Server Feature Installation and click Next.

    The Feature Selection dialog box is displayed.

12. Select Database Engine Services, Client Tools Connectivity, and Management Tools-Basic, and click Next.

    To change the installation directory, modify Shared feature directory.

    The Installation Rules dialog box is displayed.

13. Click Next.

    The Instance Configuration dialog box is displayed.

14. Click Next.

    The Disk Space Requirements dialog box is displayed.

15. Click Next.

    The Server Configuration dialog box is displayed.

16. On the Service Accounts tab page, set SQL Server Agent and SQL Server Database Engine in the Account Name column to NT AUTHORITY\NETWORK SERVICE and click Next.
    1. In the Account Name drop-down list box of the corresponding service, click Browse.

    2. In the Select User or Group dialog box, click Advanced.

    3. Click Find Now.

    4. Under Search results, select NETWORK SERVICE and click OK.

    5. Click OK.

17. In the Server Configuration dialog box, click the Collation tab and check whether the value of Database Engine is Chinese_PRC_CI_AS. If the value of Database Engine is not Chinese_PRC_CI_AS, perform the following steps. If the value of Database Engine is Chinese_PRC_CI_AS, click Next.
    1. Click Customize....
    2. Select Windows collation designator and sort order.
    3. Select Chinese_PRC from the Collation designator drop-down list box.
    4. Deselect Case-sensitive, and select Accent-sensitive.
    5. Click OK.

    6. In the Server Configuration dialog box, click next.

18. Select Mixed Mode (SQL Server authentication and Windows authentication) in the Authentication Mode area, and set Enter password and Confirm password. Then click Add Current User to add the user to the Specify SQL Server administrators area.

    The administrator password can only contain uppercase letters, lowercase letters, digits, and the following special characters: ~@#^*()-_+|[{}]:./?

    The administrator password contains 8 to 32 characters.

19. Click Next.

    The Error Reporting dialog box is displayed.

20. Click Next.

    The Installation Configuration Rules dialog box is displayed.

21. Click Next.

    The Ready to Install dialog box is displayed.

22. Click Install.

    The Installation Progress dialog box is displayed, showing the installation progress.

    When the installation is complete, the Complete dialog box is displayed.

23. Click Close.

Follow-up Procedure

To verify the SQL Server 2012 database installation, perform the following operations:

1. Choose Start > Microsoft SQL Server 2012 > Sql Server Configuration Manager.

   The Sql Server Configuration Manager window is displayed.

2. Click SQL Server Services. If Running is displayed for SQL Server (MSSQLSERVER) in the State column, the SQL Server 2012 database is installed successfully.