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

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

Sitecore Forms NOT visible in Form Builder - Strange but True!!!

Hello Sitecore Developers, in this blog we will be touching upon a strange Sitecore scenario i.e. Sitecore Forms are NOT visible in Form Builder even after creating a Form.  Note:  If you are new to Sitecore Forms and are intrigued to learn about creating a Sitecore Form, go through my blog on how to  Create a New Sitecore Form Let's begin with the most common resolution for this issue i.e.  Rebuild the Sitecore Master Index Rebuilding the master index will most likely solve this issue. But guess what, when it's not your day, this issue will persist even after the index rebuild. Refer to the below resolutions if this does not solve your problem. From Sitecore Launchpad, go to Control Panel > Indexing Manager and rebuild the Sitecore Master Index. Verify Form Folder Item ID To verify if this ID is correct. Go to the Core Database How to switch to the Core Database?   Ignore this part if you are already familiar to switch to the Core Database Go to Sitecore La...
Post a Comment
Read more