Updated on 2022-04-24 GMT+08:00

Installing SQL Server

  1. Double-click Setup.exe to open the SQL Server installation center.
    Figure 1 SQL Server installation center
  2. On the Installation page, click the first option.
    Figure 2 SQL Server installation options
  3. Select Specify a free edition to install SQL Server with a free image.

    To set up an official SharePoint environment, you need to enter a key to install a full edition of SQL Server.

    Figure 3 SQL Server free edition
  4. Select I accept the license terms and click Next.
    Figure 4 SQL Server license option
  5. Click Next to install Microsoft Updates, Install Rules, and Setup Role using the default settings.
  6. Click Select All to select all features and click Next.
    Figure 5 SQL Server features
  7. Select Default instance.
    Figure 6 SQL Server instance
  8. Set SQL Server configurations.
    • Change the account name of SQL Server Database Engine to NT AUTHORITY\NETWORK SERVICE.
    • Set the account and password of SQL Server Analysis Services to those configured in steps 11 to 13 in Adding AD, DHCP, DNS, and IIS Services.
    Figure 7 SQL Server service accounts
  9. Click Add Current User to set the current account as the SQL Server administrator account, and click Next.
    Figure 8 SQL Server administrator account 1
  10. Click Add Current User to grant Analysis Services administrator permissions to the current account, and click Next.
    Figure 9 SQL Server administrator account 2
  11. Retain the default setting in Reporting Services Configuration and click Next.
    Figure 10 Reporting Services Configuration
  12. Click Add Current User to grant Distribution Replay Controller service permissions to the current account, and click Next.
    Figure 11 Distribution Replay Controller service
  13. Confirm SQL Server configurations and click Install.
    Figure 12 SQL Server installation
  14. Click Close. The SQL Server installation is complete.
    Figure 13 Finish SQL Server installation