Microsoft SQL Server 2017 Installation
A basic system requirement before installing the software.
- SQL Server Management Studio requires .NET 4.6.1 as a prerequisite
-.NET 4.6.1 will automatically be installed when SQL Server Management Studio
Important Points Before Installation
A) Make Sure you CHANGE the install path from C drive to D drive.
B) SQL Server on a virtual machine may result in slower operations because of virtualization overhead.
1) Execute the file name, SQLSERVER2017-version-type-x64-ENU.exe
(Version= Dev, Standard, etc.)
SQL Server 2017 (14.x)
2) This will bring up the MS SQL Server setup wizard. Here you will be presented with several options:
A) New SQL Server stand-alone installation
B) Installing SQL Server Reporting Services
C) Install SQL Server Management Tools
D) Install SQL Server Data Tools
E) New SQL Server Failover cluster installation
F) Add node to a SQL Server failover cluster
G) Upgrade from an earlier version of SQL Server
H) New Machine Learning Server (Standalone) installation
3) We select Option A, New SQL Server stand-alone installation
4) Now, you will see a page showing our product key already filled in so just click next
5) Now, you will see a page with Microsoft Software License Terms. Accept it and click next.
6) Now, you will see a page displaying the ‘Install Rules’. Ignore the firewall error after it runs unless you are having problems. At the top of the page, you will see Operation completed: Passed: i.e. 12 and Warning: 1 Firewall
7) Click next and Select the features you wish to install:
A) SQL Server Database Engine -Database engine, core services (Option)
B) Analysis Services -Creation tools and Manage online analytical processing (Option)
C)Integration Services- Graphical tools and programmable objects (Option)
D) Master Data Services -master data management. (Option)
E) Machine Learning (Standalone)- machine learning solutions (Option)
Unless you have special instructions with the server build,
Out of the several options, Select A, SQL Server Database Engine
Make sure you install SQL Server on D drive!!!!
8) Now you see a page with the ‘instance configuration option’. Just select ‘Default’ unless you have special build instructions
9) Now you will see a page called ‘Server Configuration’. Here you configure the service accounts and collation. You will also be presented with the choice for Windows Authentication mode or Mix mode. I usually select Windows Authentication. You can go either way. Lastly, on this page, add users of your choice. i.e. Administrator Group
10) Now the following pages will depend on the features added earlier during this install process.
11)Once you have completed everything based on the selected features, you will be ready to Install.
12)The installation progress will begin and you can watch the progress bar.
13) At the end of the operation, it will display ‘Install Successful’
14)The last step is installing SSMS, SQL Server Management Studio. Go back to the SQL setup wizard and select “Install SQL Server Management Tools’