How to install MS SQL Server
In this tutorial, we will learn how to install MS SQL Server and SQL Server Management Studio step by step. We will use MS SQL Server 2019 and latest version for SQL Server Management Studio.
Use following urls to download MS SQL Server and Management studeo.
Install MS SQL Server 2019 Express Edition
Step-1: After downloaded the MS SQL Server 2019 Express edition, you may launch the installer file “SQL2019-SSEI-Expr.EXE”
You may choose “Run as administrator” so it won’t create any issue with users permission to install SQL Server.
Step-2: After installer launch instance for setup, you may choose what type of installation you want to select. From given three option , you may choose custom option to it will allow you to what feature you want to install with SQL Server.
Step-3: Specify the location where you want to install MS SQL Server. By default it will store with “C:\SQL2019” folder. You may choose different location or folder by using browse option. Then click on Install to start the installation process.
Upon install, it will download all required setup package before installation start.
Step-4: Following screen will appear to select new SQL instance to install or add features in existing installation. To install it, choose the one which highlight with blue color square from the list and it will launch the wizard to start the installation for MS SQL Server 2019.
Step-5: Next screen will appear to accept license terms to use SQL Server. You have to select “I accept the license terms” checkbox and click on next button.
Step-6: Select checkbox to check whether any update released by Microsoft for MS SQL Server 2019 and it automatically check every time and notify to update it. It’s recommendation that you should select this option. Then click on Next button.
This will check for any update from Microsoft and download it before installation proceed and show on next screen with output.
Step-7: Before installation proceed, it will check any potential problems to identify while running setup and if any failure happens, it must be corrected. Then click on Next button.
Step-8: Next screen will show feature list which are available to install with SQL Server. By default all selected features which you can see from below screen are available to install, you may uncheck which are not necessary. Main feature if Database Engine Services is required for SQL Server. Then click on Next button.
Step-9: Here, you can define instance name for SQL Server. You may choose default one as well or you can provide your chosen name for instance in given option”Named Instance”. Then click on Next button.
Step-10: As you have selected all default options to install MS SQL Server, It require to install JDK or JRE and all selected features which are not there in your desktop. You may specify different location to install them. Then click on Next button.
Step-11: Now following screen will appear and display service accounts and its configuration. They are Database Engine, Launchpad, Full-text Filter Daemon and Server Browser for SQL Server. Then click on Next button.
Step-12: Now, you may choose security mode for server configuration with two options that are Windows authentication mode and Mixed Mode (Windows authentication and SQL Server authentication). If you choose Mixed mode, password and confirm password are required to specify. By default it will add administrator user as current user. You can have an option to add new user as well. Then click on Next button.
Step-13: You will have to accept checkbox for “Consent to install Microsoft R Open” and proceed. Then click on Next button.
Step-14: From feature list, “Python” was selected by default to install, it is required to install it through the wizard so following screen will appear to accept “Download and install necessary pre-requisite” for Python installation. You will have to accept it and click on Next button.
Step-15: Following screen “Installation Progress” will appear when installation will start. Wait until it finishes with progress bar.
Step-16: Once installation completed, it will show all features list with their status for install as “Succeeded”. You may close the window.
Now your MS SQL Server 2019 Express edition installed successfully. Now nest step it to install sql server management studio tool to access your MS SQL Server 2019 interface.