Install SQL Server 2022 Developer and SQL Server Management Studio (SSMS) for Free (2024 video)

[Music] hello and in this video we're going to download and install SQL Server Developer Edition 2022 along with SQL Server management Studio ssms I'm Philip Burton of ID dat.com so first of all you need to go to a web page where you can download it so here you can see I'm on a Microsoft web page in the past I've said Google the phrase download SQL Server 2022 however at the time of recording that takes me to some pages which are completely different to this this is the best page to use now you can see that there are three big entries at the top here I don't want any of those instead I want to scroll down and choose a free specialized Edition now in this case we're going to download the Developer Edition so I'm going to click download now and it downloads what is called a bootstrap so this is a small program only about 4 megabytes so I'll go to my downloads and open it so do I want to allow this app to make changes to your device yes I do now you can see that there are three options a basic version where you don't have have to do any of the configuration because it is the standard default configuration a custom one where you can actually choose what you want to do and you can download the media and then run them either on your current machine or on any other machine so the basic one is fine to start off with it will allow you to create select statements and do some database Administration but not much else so if you wanted to do more in SQL Server such as ssas SQL Server analysis Services ssis integration services and SSRS reporting Services then don't select this basic option so custom might be the one for you you can download it and choose what you want to install or you can download the media and install them later on a machine of your choice so I'm going to use the custom install type so select a media location so this is where it's going to store the download so you can change it there and click install so you can see now it is acquiring the setup files but it is over a gigabyte so it's going to take quite a while so while it's downloading I want to talk about some other things so let's go back to this web page so if I scroll back up we start off with SQL server on Azure Microsoft Azure is Microsoft in the cloud so you can get an SQL Server database in the cloud so in other words the back engine which is the thing that I'm downloading at the moment it runs in the background and you can query that from your computer now you can have that on your computer the back engine or you can have it in the cloud so why not just have SQL server in the cloud well the problem is there is a cost to that it's not necessarily a huge cost but there is a cost and the developer addition that we are downloading there is no cost now there is this SQL server on premises so this is the paid for version and then we've got the three specialized editions we've got the developer that's the one that we're downloading now and the express so the express is fine if you want to do select statements and some database Administration it's totally free including for production however it is a cutdown version the Developer Edition is a full featured free edition so the only restriction is you cannot use it in a production environment if you want to do that then you will need to actually buy it so what are these paid for versions well we've got the Enterprise the standard and the web so if we have a look at these you'll see that the Enterprise is the premium offering delivering comprehensive high-end data center capabilities with a price to match the standard version offers basic database management however there are some features that are missing so look at the Developer Edition this includes all of the functionality of the Enterprise Edition so why do people go for the Enterprise Edition and not the Developer Edition it's because the Enterprise Edition is licensed for production the developer is not licensed for production so if you want to learn SQL Server then it is this development and test system that you will be using and it allows you access to all of the various strands of SQL Server so in other words reporting Services integration Services analysis Services as well as creating queries using the select statements and database Administration you can see that the Enterprise Edition is the best version for developers and hobbyists building client applications it's a very quick install but you can't expand you can't build on it if you want to go to the other Realms of SSRS ssis and ssas now the Developer Edition used to be a paid for version it was a box product right up to the 2014 edition it sold for around $200 and I bought one at around that price and it was a very good value but now it's completely free and therefore if you want to learn how to use SQL server on your own computer it is the perfect Edition for you now it's called SQL Server so does that mean you need a server to install it on and the answer is no in fact the hardware requirements are fairly basic all it requires is a minimum of 6 GB of available hard dis space yeah right I don't believe that it only requires a gigabyte of memory well it would function let's put it this way but you can see that these are really small requirements so the big requirement is it needs a 64bit processor now if you don't know whether your computer has got a 64bit processor then open up Windows Explorer go to computer or my computer so in this case this PC right and click on it s of properties and you'll get a new dialog box and somewhere on there it will talk about a 32-bit or a 64bit operating system if you've got a 32-bit operating system then the latest version that you would be able to use is the 2014 version and there is a 2014 Developer Edition available however it is not easily findable it isn't on the SQL Server downloads page there is a product button that gives you access to some previous versions but not unfortunately the 2014 version so if you do want that Edition then you should Google download SQL Server 2014 Developer Edition here you can see an article about it and there is a link there for visual studio Dev essential members and that's a free membership if you click on that then you will get to this web page which searches for SQL Server 2016 but just change that to 2014 and you can then download the service pack free version from there so on my 64-bit operating system my SQL Server 2022 is still downloading so I'm going to finish it downloading so I'll pause the video here and in the next part of the video we'll start with the installation right well we can see that the download was successful now if you wanted a custom install then you will have the SQL Server installation Center already running if not you'll probably find that there are two files that have been downloaded an exe and a box BX and you should run the exe and it will then ask do you want to allow changes that you've made and you say yes and that will then extract it into a folder and you can then open up the SQL Server 2022 developer installation center now there's a lot of hyperlinks here don't worry about them you don't need to know much if anything about them at the moment it's the installation we are going for so on the left hand side I'm going to click on installation and at the top we've got new SQL Server Standalone installation or add features to an existing installation so I'm going to click that and then I'm going to minimize everything else so the computer then starts preparing for the installation process so the first thing that it asks is what version of SQL Server do you want do you want the Developer Edition do you want the express Edition or do you want a 180-day trial if you're going for the standard or Enterprise Edition or have you got a product key or are you doing this through the cloud Microsoft Azure well I'm going to install the Developer Edition so let's click next so next we go to the second item on our list and this list may increase as we continue so the license agreement so you should have a read of this and if you agree with the license terms and the Privacy statement then check that box and we go to next now it's just making sure that your computer has got everything that it needs now now you may find Windows Firewall there is a warning don't worry about it it's just a standard warning so let's click next and now we get to the Azure extension for SQL Server so this is useful if you want to enable Microsoft Defender for cloud purview and aure active directory to use this particular instance of SQL Server so in other words if you want your SQL Server to be protected from the cloud well I'm not going to do that so I'm going to uncheck aure extension for SQL Server so that's all you need to do and click next next is going to ask you okay what features do you want now there is a big list here and if this is your first time don't worry you can always come back to this and add additional things later if what you are looking for is to build your select statements or to do some database Administration then I would check the database Engine Services and then just leave it at that if you're looking for SQL Server analysis Services ssas then you should check this and notice each time I do this list gets just a little bit longer if you're looking for ssis integration Services then check this and if you're looking for any of these additional features then check that as well now if you're looking for for SSRS SQL Server reporting Services it is not actually here you can click on download it from the web and you'll see that it comes to this page however this is not needed unless you want to host your own SQL Server reporting Services reports on your computer so you can still create them you can still run them you can still print them everything apart from horsing them without this so if that's all you want to do then you do not need to click on this link now I used to say you could select all but that was in the days when we didn't have such a long list now one more thing if you have got a small C drive so you might have a small but very fast drive then you might want to change the instance route directory at this stage and there are a few other places where you may wish to change it as well so for the purposes of this YouTube video I'm going to assume that you do want access to ssas and ssis as well as the database Engine Services so I am going to check those two and then we click next so now it's just going to have a look and make sure that everything's fine next is going to ask you for whether you want a default instance or a named instance now if this is your first time installing SQL Server then you should use the default instance it's the first instance that anyone will try to connect to and it's the easiest to connect to if not if you have other versions of SQL server on your computer then you need to use a named instance so why might you want more than one SQL server on the same machine well let's say you're installing ssas in the two different mods that we've got the MDX multi-dimensional Expressions mode and in the tabular mode these require different instances they can't sit on the same instance so for this video because I have previously got an instance I'm going to create a new one so I'm going to call This mssql Server 2022 so let's do that and click next however you should use the default instance if that is available the next tab is for the service account so you should leave everything here as is unless you've got a particular reason for changing them so let's go to next next what is your authentication mode how are you going to log in to SQL Server 2022 so the default is the windows authentication mod so that uses the same Windows account as you logged into right now so if somebody else accesses SQL Server then they'll use their windows now suppose you can't do that suppose you need to use a username and password then you can use the mixed mode and you should enter a password for the system administrator the sa account but for now I'm going to leave it on Windows authentication mode but I'm not going to click next immediately very important I'm going to add me the current user as an administrator administrators have all the power that you need in your instance now if your C drive is a bit on the small side then you may wish to go into Data directories and change these directories again so I'm now going to just click next and go into the ssas configuration now there are two different modes there is the multi-dimensional mode so this is the mode where you can create huge cubes using billions or trillions of raws they used by huge companies if you don't want that then the Tableau mode was created in 2012 so it depends are you wanting to use MDX Expressions to create and then query a cube or are you wanting to use the Dax language and create your analyses in something that's a bit more recent now if you don't want any of these then in the earlier section you shouldn't select ssas so for the purposes of this video I'm going to select multidim dimensional mode and I'm going to click on ADD current user and again you can go into the data directories and change it if you don't want everything linked to your C drive so there is no additional configuration required for the ssis it is now ready to install and to install you just click the install button and you can leave it now installing for the next few minutes now while it's installing I'd like to talk about a few different editions so I've talked about one type of Edition are you getting the express the developer the standard or the Enterprise Edition in addition to this every couple of years or so Microsoft comes out with a new version so we started off with SQL Server 2000 that's the first of the yearn named versions and then 2000 2005 and then 2008 now you might think the next one's going to be 2010 but it was actually called 2008 release 2 or R2 but it was released in 2010 and then we have 2012 2014 2016 2017 2019 and now 2022 so you can imagine the next version will come out in 2024 2025 now SQL Server costs a huge amount of money if you're talking about the standard or the Enterprise Edition and this is one big reason why you might find big companies are using older versions yes there are improvements in each version but there might not be sufficient for someone who is wanting to spend or not wanting to spend tens or hundreds of thousands of dollars to upgrade and then there is a big hassle Factor when upgrading so for us who are just using SQL Server to understand how to create our select statements to database Administration or learn SSRS ssis or ssas it's very easy just to uninstall a previous version and install a new version you haven't got people relying on a particular version relying on all the data that's there so if you're going into work and going to be using SQL Server you might find you don't have the very latest version of SQL server and that's absolutely fine in fact a lot of people even if they were going for the latest version at work wouldn't buy it until the first big Service Pack has been released so basically if you're using SQL server on your home computer then you should get the latest one in this case the 2022 version if you are creating tsql select statements for instance there have been some improvements in the 2012 version some very important improvements but after that there have been more minimal improvements until you get at least to the intermediate level of creating select statements so if you've already got 2012 2014 2016 2017 2019 then you're probably fine if not then you should install SQL Server 2022 so this is how you can install SQL Server if you haven't got one and you can see while I've been talking it has installed in the next part of this video we'll install the front end so we've installed the back end this is the thing that runs in the background so next we'll install the front end for SQL Server so now SQL server has been installed on your computer s let's go back to the SQL Server installation Center and installation now the next thing we need to install is a front engine in other words a program that you can use to create select statements and for database management and it's called SQL Server management studio so I'm going to click on install SQL Server management tools and it takes me to this web page download SQL Server management studio so I'm going to scroll down and click on download SQL Server management studio now the current version at the time of recording is 20.1 and this is the latest generally available or GA version so I would suggest whatever the latest GA version is you install it I would not recommend installing preview versions so I'm just going to click on that and it's going to start downloading now if you want for some reason a pre previous version then you can scroll down and we've got a link to previous ssms releases say version 19.3 now you can only have one version of ss sms2 installed at any one time so if you've got version 20.2 and you install 20.4 then the 20.2 version gets upgraded however you can have SS SMS 20 ssms 19 and SS SMS 18 All In installed if you want to do so so my version of SQL Server management studio ssms is now downloading so I'm going to pause the video until it's fully downloaded so now you can see that ssms has now fully downloaded so I'm going to click on open file now you should ensure that you have good virus protection before installing any program now this is the location where SS SMS is going to be installed if that's not suitable for you for example if you've got a small C drive then click change to change it otherwise click install so I have a question do you want to allow this app to make changes to your device well I'm going to say yes and now it's going to install and it's going to be a fairly smooth install so I'm going to speed up the video while it installs so now you can see that SQL Server management Studio has now successfully installed so I'll close that and I'll go to my start menu and I'll type in ssms and here you can see my version 20 and you can also see my previous versions so I'm going to click on ssms and open it now the first question it's going to ask me is what instance of SQL Server the back end are you connecting to so if you're connecting to your default instance then you could just type in a dot in server name or the word Local Host without a space alternatively you could click on browse for more and then find a connection within the database engine or you might be at work and you might have been given a server name so I'm just going to enter a DOT and click connect however there will be a problem in SQL Server version 20 you will probably get this error message the certificate chain was issued by an authority that is not trusted while this solution for this is to check trust server certificate or to change encryption from mandatory to optional so whichever you do click connect and you should now be connected you won't get that problem with sss9 or below the reason we get this problem is because in SS sms2 this encryption setting changed from no or optional to yes or mandatory so the two solutions are either Chang the encryption to optional or to check trust server certificate if you're connecting to a production environment so a system at work then it should have its own certificate already installed and therefore you shouldn't have any problems if you are connecting to it if you are using the default settings so in these videos we have installed the back engine SQL Server 2022 and we've also installed SQL Server management Studio this front engine so now we've installed SS SMS and SQL Server where' you go from here well if you'd like to learn SQL Server then I hope you will have a look at my udemy videos in these courses I take you through various aspects of SQL Server so if you want to learn how to query SQL Server then I've got a range of courses depending on whether you have got around 1 hour around 9 hours or 29 hours to really get in dep if you're looking for database Administration then please join me in my DBA course if you are looking for ssas ssis or SSRS then I have got courses on these as well so you can learn how to use SSRS reporting Services either version of ssas so whether you're looking for the multi-dimensional MDX version or the tablea version and ssis additionally I've got a more advanced course for administering SQL on the cloud in Azure links to all of these courses are included in the description to this video additionally if you want to learn SSRS ssas or ssis and use it on your computer then you will need an additional program you'll need Visual Studio 2022 Community Edition again this is free and then you need to install the appropriate extension so I have additional videos on my YouTube channel for how to do this for SSRS ssas or ssis so if you want those I hope you look at the playlist which hopefully is on the screen now and click to get to your next video well I hope you've enjoyed this video if you have then please click the like button and why not subscribe and click that Bell next to it that way you'll be notified of any new videos I'm Philip buron of ID do dat.com thank you very much for watching this and keep learning [Music]

Channel: SQL Server 101

Views: 2,107

Keywords: how to download sql, how to install microsoft sql, how to install sql, how to install sql server, how to install sql server on windows, install microsoft sql, install microsoft sql server, install sql, install sql server, install sql server management studio, install sql server on windows, install ssms, install t-sql, sql server installation, sql server tutorial, ssms, sql server 2022, sql server 2022 install, how to install sql server 2022, sql server install, ssms 20

Id: oKsYmoCHTtQ

Length: 26min 51sec (1611 seconds)

Published: Thu May 02 2024