Help Center/ Elastic Cloud Server/ Best Practices/ Setting Up an Application/ Building Microsoft SharePoint Server 2016/ Installing SQL Server
Updated on 2025-11-27 GMT+08:00
View PDF

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 Feature Selection
  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 Distributed Replay Controller service permissions to the current account, and click Next.
    Figure 11 Distributed Replay Controller
  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