White Papers

Install and configure Microsoft SQL Server 2017 Enterprise Edition
20 Deploying the 385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using
Dell EMC PowerEdge R940 and SC9000 | 4033-CD-SQL
7 Install and configure Microsoft SQL Server 2017 Enterprise
Edition
7.1 Install Microsoft SQL Server 2017 Enterprise Edition
To install SQL Server 2017 Enterprise Edition, perform the following steps:
1. Insert the SQL Server 2017 Enterprise Edition install media.
2. Double-click Setup.exe. The SQL Server Installation Center window will appear.
3. Click Installation in the pane on the left-hand side.
4. Click New SQL Server stand-alone installation or Add features to an existing installation. The
SQL Server 2017 Setup dialog box will appear.
5. On the Product Key screen, enter the product key and click Next.
6. On the License Terms screen, select I accept the terms and click Next.
7. On the Microsoft Update screen, leave Use Microsoft Update to check for updates unselected
and click Next.
8. On the Feature Selection screen, select the following features and click Next:
- Database Engine Services
- SQL Server Replication (optional)
- Full-Text and Semantic Extractions for Search (optional)
- Client Tools Connectivity
- Client Tools Backwards Compatibility
- Documentation Components
9. On the Instance Configuration screen, leave Default Instance selected and MSSQLSERVER in
the Instance ID textbox. Click Next.
10. On the Server Configuration screen, do the following:
On the Service Accounts tab:
a. Enter the SQL Server service account name (.\SQLService) and password for the SQL Server
Agent.
b. Change the startup type for the SQL Server Agent to Automatic.
c. Enter the SQL Server service account name (.\SQLService) and the SQL Server Database
Engine.
d. Select the Grant Perform Volume Maintenance Task privilege to SQL Server Database
Engine Service.
On the Collation tab, leave the Collation at the default setting and click Next.
11. On the Database Engine Configuration screen, do the following:
On the Server Configuration tab:
a. Under Authentication Mode, select Mixed Mode.
b. Enter and confirm the sa password.
c. Click Add Current User.
On the Data Directories tab:
a. In the Data root directory text box, enter M:\ft\SQLSystem.
b. Leave the remaining directory text boxes as-is.