How to Install SQL Server 2022 Express and SQL Server Management Studio SSMS - It's FREE to use.

and in the search bar type Ms SQL click on the second link which is a Microsoft site and it says SQL Server downloads once the website is open you will see multiple options for downloading now we want to download the Microsoft SQL Server Express Edition and we are going to find that link at the bottom so let's browse a little bit more all right and here you can see it says download the free specialized Edition here you can see the Developer Edition the Developer Edition is totally free to use for development purposes and the next one you can see is the express Edition which we are going to download now the express Edition we are downloading because it is totally free for commercial use that means you can use this for development environment as well as production environment click on download and you will see the executable file has been downloaded click on open file this will open up the download wizard here it is asking to select an installation type there is three types available basic custom and download Media I'm going to click on custom so that I can show you all the options which are available at the time of installation once we click on the custom installation we get this type of option here we have to specify the SQL Server media download Target location so what you can do you can click on the browse and then you can select the folder where you want to save the downloaded files also you can see over here it says minimum free space should be available on the drive is around 6000 MB and the downloading file size is 278 MB now let's click on install I'm going to fast forward the videos so it will not take much time once the downloading is completed the SQL installation wizard will automatically open let me close the browser now here you can see there are multiple options are available here we are going to click on the first link which is new SQL Server Standalone installation all right so let's click on it here it says please wait while Microsoft SQL Server 2022 setup processes the current operation I have fast forwarded the video now this brings up to the SQL Server 2022 setup right now we are on license terms and condition which we have to accept before proceeding forward so just check it out the license terms and condition and click on the check box then click on next here it is checking for the global rules and then it takes us to the Microsoft update I'm going to click on the check box use Microsoft update to check the updates all right now click next again it is checking for the updates available there are no updates available it has bring us to the next window this is a installed role window it says operation completed for past one warning here you can see it is giving warning for the firewall so that is fine let's click next now the wizard brings us to Azure extension for SQL Server So currently we are not using Azure extensions therefore we are going to uncheck this checkbox all right now click next now we are on feature selection window here you can see some of the features are already selected by default first one is the database engine service on the right hand side you can read more about this feature here it says it includes the database engine the core service for storing processing and securing data the database engine provides controlled access and Rapid transaction processing all right so now let's quickly check the next one SQL Server replication includes a set of Technologies for copying and distributing data and the database objects from one database to another and synchronizing between the databases for consistency you can read more about it from the description box next is machine learning service and the language extensions and the last one is full text schematics and the extension for search after that you can see poly based query service for external data I don't require polybase query service so I'm not going to click on the check box at the last you can see shared features there you will find local DB in our scenario we don't require that one as well so let's proceed here you can see instance root directory shared feature directory shared feature directory x86 in front of that you can see there is a path the path is for the C drive where it is going to be installed nothing to do over here let's click next now it is checking for any dependencies all right now we are on instance configuration here you can see by default it is selected the named instance and our instance name is SQL Express if you want you can also change this name with the name of your choice on the top you can see default instance is also available to select if you click on default instance then you can access the SQL server using the localhost or the computer name without the instance name now let's click next this brings us to server configuration window here we have to specify the service account and the Collision configuration in service account Microsoft recommends that you use separate accounts for each SQL Server service there are total four types of service are showing over here database engine SQL Server Launchpad SQL full text demand launcher and the last one is SQL browser I'm going to go with the default account which are already been selected and I'm not going to make any changes over here click on the check box Grant volume maintenance task privileges to SQL Server database engine service this privilege enables instance file initialization by avoiding zeroing of data Pages this may led to information disclosure by allowing deleted content to be accessed we are not going to do anything on the Collision Tab and we are leaving it as default now click next this brings us to the database engine configuration window first one is server configuration here we have to specify the authentication mode and the administrator for the database engine here you can see authentication mode currently Windows authentication mode is selected and the second radio button is for mixed mode that means it will support both types of Authentication SQL Server authentication and windows authentication as well I'm going to select the second review button mixed mode then I am going to specify the password for the SQL Authentication now remember the username for the SQL authentication is by default as a and the password you can enter of your choice let's click on data directories tab the first one is the data root directory the second one is the system data directory the third one is user database directory and the fourth one is user database log directory and the last one is the backup directory in front of it you can see there is a path is given so if you want to change the path of the location where the data is going to be saved you can click on the three dotted button and select the drive once you have selected a drive create on make a new folder give it appropriate name like I have given it SQL data and then click ok this way all the data will be saved in this particular folder as you can see the entire location has been changed to the e Drive it's e colon SQL data and after that you can see Ms SQL 16 that's a version number you can see the other directories the path is very long so I am going to shorten this I'm going to remove the version number all right so now let's check it out the tempdb normally we don't have to do anything over here so I'm going to leave it as this next one is memory SQL Server can change its memory requirement dynamically based on available system resources however in some scenarios you can configure the range of memory in mb that is managed by the SQL server memory manager for this instance by separating the minimum server memory and maximum server memory here you can see I have clicked on recommended in minimum server memory I'm going to leave 0 and in maximum server memory I am going to enter 3000 that will be 3000 MB I am entering 3000 because the total RAM on this server is 4 GB so it will be best to read to our needs to enter 3gp over here once we have allocated the ram we have to click on the checkbox where it says click here to accept the recommended Ram configuration for the SQL Server database engine I'm going to click on the checkbox later all right now in the user interface you don't have to do anything click on the file stream tab here also we don't have to do anything at all let me click back on the memory tab here we have to click on the check box once you have selected the checkbox you will see the cross icon has been removed let's go back to the server configuration and check all the configuration which we have done earlier database directories temp DB memory user interfaces file stream all right now let's click on next button now the installation is in progress it will take some time for the installation so I'm going to fast forward the video so you don't have to wait for long all right so the installation has been completed now you can see everything is in green and the status shows succeeded okay in the details it says install successful click on close and now we have to download SQL Server management Studio basically the SQL Server management studio is used to manage the SQL Server database let's click on this third link which is install SQL Server management Studio this will open up a browser and from here we can download the SQL Server management studio also known as ssms here you will find a download link click on the link to download this is a simple download and installation so it won't take much time I'm going to fast forward the video so you don't have to wait for long once the downloading is completed click on open file this will open up the SQL Server management Studio wizard it will take some time to open up so don't get panicked wait for few seconds there we go the wizard has been opened here it says Microsoft SQL Server management studio with Azure data Studio if you want to change the installation location you can click on change and then select the location where you want to save I'm going to click on install in C drive with the default location all right click install I'm going to fast forward the video so you don't have to wait for long normally it will take two to three minutes for the installation alright it says setup completed all specific components have been installed successfully click close now let me show you how you can open SQL Server management studio and connect to the database engine close this okay go to start at the top you can see there are three icons the third one is SQL Server management studio if you don't see the icon over there you will find the folder with the name Microsoft SQL Server tools 19. there you will find SQL Server management Studio click on it and this will launch the SQL Server management Studio as I am opening the SQL Server management studio for the first time on this server it will take few seconds to open all right so the SQL Server management Studio has been opened here you can see the server name and then you can see the instance name that is SQL Express below that you can see Authentication so right now the authentication is selected which is Windows Authentication and the user is administrator now I am going to click on connect now we are connected to the database engine which we have installed click on the plus sign of the database directory this is empty right now once you create the databases you will able to see it over here now I'm going to disconnect the database engine and then re-login using SQL Server authentication which is the second number this is the one all right so I'm going to enter the user which is SA this is a default user and then I'm going to enter the password all right you can click on remember if you don't want to type it again and again click on connect and there we are logged in successfully using SQL Server Authentication Hello friends thank you for watching our this video tutorial if you like this video don't forget to like share and subscribe also click on the Bell icon if you want to receive a notification whenever we post a new video my name is Sachin Sami and you are watching this video on YouTube channel Peter cries

Channel: Sachin Samy

Views: 82,678

Keywords: Express, SQL Server 2022 Express, Microsoft SQL Server 2022 Express

Id: VkUO9S7n8B8

Length: 17min 52sec (1072 seconds)

Published: Sun Apr 23 2023