Skip to main content

SQL Sever 2019 - Lets Install Together!!

Introduction:

Hello Developers, welcome to my blog. In this blog, I will be covering the SQL Server 2019 Installation. There are different ways with which this can be done.

By default when you install SQL Server, you will be able to log in to it using Windows Authentication. In this blog, I will help you to create credentials for logging into the SQL Server using SQL Server Authentication as well.

SQL Server 2019 Installation:

Download the Setup Files:

  1. Download the Setup File of SQL Server 2019 from here
  2. You will be having two options:
    • Developer Edition - In this blog, we will be using Developer Edition as we are installing SQL Server for our local environment. This edition works ONLY for Developer and Test Systems.
    • Enterprise Edition: This is preferred for installing SQL Server in higher environments such as Production. This has premium performance and capabilities as compared to the Developer Edition.
  3. Once you have Downloaded the Developer Edition. An SQL2019-SSEI-Dev.exe file will be downloaded. 
  4. Open it in the Administrator Mode.
  5. Since we have to change some configurations, we will select the Download Media option from the three options provided in the image above.
  6. After the download is complete, you will get a SETUP.exe
  7. Run this in Administrator mode.
  8. Go to the Installation Tab > New SQL Server stand-alone installation highlighted in Red.
  9. Product Key: In this case, we are selecting the Free edition.
  10. License Terms: Read the Microsoft Software License Terms in this section
  11. Microsoft Update: Check this checkbox as per your interest.
  12. Install Rules: This step identifies the potential problems and gives the status to each rule. Make sure all the Rules are passed along with the Windows Firewall Rule. Note: If the Windows Firewall Rule is NOT passed successfully, you may face issues while connecting to your SQL Server via SSMS.
  13. Feature Selection: You can check the settings if required. We will be selecting the default settings in this blog. 
  14. Installation Type: Since I already have an instance installed it is showing me the below options. 
  15. If you are installing the SQL Server for the first time, you will get two options:
    • Default - This will name your SQL instance by giving it a default name.
    • Named Instance - If you select this option, you can name your SQL Instance
  16. Database Engine Configuration: We have to specify the Authentication Mode and also add a user in the Specify SQL Server Administrators.
  17. There are two Authentication Modes:
    • Windows Authentication Mode: This will allow you to log in to the SQL Server instance using Windows Authentication mode.
    • Mixed Mode: If you select the Mixed mode, you will be able to log in from both Windows Authentication mode and SQL Server Authentication mode. To log in from the SQL Server Authentication mode, you will have to specify a password.
  18. Note: 
    • Remember the password mentioned while installing as this will help you to log in to the SQL Server.
    • The default username is sa
  19. Once all the above steps are complete click on Next and then click install. 
With this, the SQL Server 2019 Installation is complete.😊

You can now access, monitor, and configure the installed SQL Server using SQL Server Management Studio (SSMS)

See you in my next blog. Till then Keep Learning and Keep Growing!! ðŸ˜Š


Comments

Post a Comment

Popular posts from this blog

Creating a Sitecore Form - A whole new Experience!!

What is a Sitecore Form? Sitecore has introduced an amazing feature that transforms a regular form into a form that has many out-of-the-box features attached to it. Some of the features are listed below: Unique Views:  Number of unique visitors of the form. Abandonments:  Visitor who visited the form but did not submit the form Abandonment Rate: Percentage of visitors not submitting the form. Export Data: This helps us exporting all the submitted form data in a .csv file. We can also leverage this new Sitecore Form by adding custom components like File upload, Captcha, etc. as per the requirement. In this blog, we will see the creation of a basic Sitecore Form. Let's get started Form Builder: The first step is to open the Form Builder from Sitecore Launchpad.  What is a Form Builder? Form Builder is a Dashboard where you can create and view all the Sitecore Forms, it Create a Sitecore Form: Click on Create > Add a Blank Form as shown in the above image.  Note:...
Post a Comment
Read more

Planning to Install Sitecore 9.3 using Sitecore Install Assistant (SIA)? Here is what you need!!

Hello Sitecore Developers, welcome to my blog. When we start with Sitecore, there are many questions. How to install Sitecore? Has Sitecore made the installation easier? If yes then how? Well, Let's find out by reading through this blog. In this blog, I will be covering the installation of  Sitecore 9.3 using Sitecore Install Assistant (SIA) What is Sitecore Install Assistant (SIA)?  Sitecore Install Assistant is a GUI which Sitecore provides for making the installation easier and efficient. Sitecore has introduced this for the versions of 9.2 and above. Before SIA, Sitecore installation was a tedious job where you had to run PowerShell scripts and install various prerequisites. This would lead to a cumbersome task for the developers to setup their local environment.  So, Lets Begin with the Installation: Prerequisites: Visual Studio 2015 + MS SQL Server - Let's Install Together Sitecore License File .NET Framework Worried about the compatibility while installing Sitecore...
2 comments
Read more

SQL Server Management Studio (SSMS)

What is SQL Server Management Studio (SSMS)? SSMS is an integrated environment that manages the instances of SQL from SQL Server to Azure SQL. You can perform various operations in the SQL instances. You can connect the SSMS and SQL Server by providing a proper: Server Type Server Name Mode of Authentication: Windows Authentication SQL Server Authentication (Username and Password Required) SQL Server Management Studio has a very straightforward installation: You can install by clicking on the section highlighted in red in the below image:
Post a Comment
Read more