Dell PowerEdge R940 Deploying the 385TB Data Warehouse Fast Track Reference Ar - Page 20
Install and con Microsoft SQL Server 2017 Enterprise Edition
![]() |
View all Dell PowerEdge R940 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 20 highlights
Install and configure Microsoft SQL Server 2017 Enterprise Edition 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. 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
![](/manual_guide/products/dell-poweredge-r940-deploying-385tb-data-warehouse-fast-track-reference-architecture-microsoft-sql-server-2017-using-emc-sc9000-4b2c195/20.png)