Saturday 12 December 2020

SQL Server 2019 Installation Steps

 Hello Guys, 


I am going to write steps how to install MS SQL Server 2019 on Windows 10.


Microsoft SQL Developer Edition is free. We can search in google and download the Media.


Download SQL Developer Edition, Its free.




Download the Media and open the Folder.


We are going to install Custom type of installation.

I have created new folder SQLDEV2019 in D drive.

I have created new folder SQLDEV2019 in D drive.



Next



Installation is in Progress


Once the software is installed we will get a new Windows like this, then we will click on the installations tab to install the database. 

 We will click on the New SQL server stand alone installation..


Next


Tick for updates (recommended)
Next


Next 


Next Screen we will get Windows Firewall Warning.  We can also disable firewall and re-run, but this is warning only, so leaving it.


Now this is the MAIN screen, here we will get what features we want to install in SQL Server.

-Database Engine Services
- Analysis Services


In the next screen we have default instance name MSSQLSERVER. I have changed instance name and instance ID to RAKESH


Next


In Next window, add current user for windows Authentication.



Now here, we have analysis configuration. We have three options
- Multidimensional and Data Mining mode
- Tabular mode
- Power Pivot mode

We will select Multidimensional and Data Mining mode now. we can add another option later by re-running the setup again.

Click next and Install

Installation in Progress



Complete.

 Installation Successful.

2 comments:

MS SQL Server and its Editions.

Microsoft SQL Server  Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a ...