Want to know how to install SQL Server Express 2022?

Рет қаралды 69,852

Жыл бұрын

SQL Server can be installed on your Windows 10 or 11 computer (with a 64-bit operating system) - that is most modern desktops or laptops; you do not need a server to install it on.
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/microsoft-powerpiv...
----
In this video, we'll show you how to install SQL Server Express 2022. This video is perfect for beginners who want to learn how to install and use SQL Server.
If you're looking to install SQL Server on your own computer, then this video is for you! We'll walk you through the steps necessary to install SQL Server Express 2022, and teach you all you need to know to get started. Plus, we have a comprehensive tutorial accompanying this video that will help you get the most out of your installation!
Let's see how you can install it, and start creating your own SQL statements.
To download it, please go to www.microsoft.com/en-us/sql-s...

Пікірлер: 85

@shrikrushnajadhav2621 6 ай бұрын

Thank you so much. I've watched many videos and tried hard to install Express but every time the server name popup was blank and I didn't know what should I type there. but you showed to click on browse more and select data engine n select own machine name as server. And miracle! it works.

@bocchi483 4 ай бұрын

I've been struggling with installing and this help me solve. Thank you!

@jillannsarah5932 3 ай бұрын

Excellent explanation of how to install SQL Server. You answered every question I had and I was able to install successfully... after hours of failed attempts before I found your video!

@user-tn9py4kx8n Жыл бұрын

This is very helpful many thanks!

@alvarojosejuliobeltran822 Жыл бұрын

Thanks for the video. You show me right way.

@oluseyinaomi4068 9 ай бұрын

Thank you so much. I have been trying to install for the longest time.

@SQLServer101 9 ай бұрын

Hello Olusey. I'm glad that it was helpful. Good luck on your SQL Server journey. Phillip

@endofmysteries Жыл бұрын

Thank you Phillip! Very thorough introduction! I am so glad you showed both Basic & Custom installs.

@SQLServer101 Жыл бұрын

You are very welcome. Enjoy using SQL Server. Phillip

@StratOnFire Жыл бұрын

Thanks so much for this!!!!

@parthasarathipatra9483 Жыл бұрын

Thanks a lot for the tutorial.

@birariraj9950 Жыл бұрын

So helpful video 👍🏻

@LaQuintaPataDebate Жыл бұрын

muchas gracias!

@sandilekhomo3030 Жыл бұрын

Thank You

@JJCK725 7 ай бұрын

Thanks brother

@deepikaa1106 Жыл бұрын

Thank you so much this video saves me 🙂

@sedjrotovihouande4922 Жыл бұрын

Thanks, very useful

@adrianhodrea8246 5 ай бұрын

Hello. A very good guide. Please allow me to ask you to provide the additional details: Why to choose between Express Basic installation and Express Custom installation? You have provided both options but not why to choose one over the other. How much space would need for express, or developer (just the installation without da data itself). Thank you for your great job!

@SQLServer101 5 ай бұрын

Hello Adrian. You would do the Custom installation if you wanted to alter any of default settings. SQL Server requires a minimum of 6 Gb of hard drive space. For more details, see learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-2022?view=sql-server-ver16 . Phillip

@jordable0000 Жыл бұрын

Thank you for the video. I am having a trouble on installing it on windows 11 the error is on database engine

@SQLServer101 Жыл бұрын

Hi Jordable. What is the error message? Phillip

@RiteshKumar-cn3qb 9 ай бұрын

Hi Philip, just came across your channel. I have installed SQL Server Express 2022 version, but I am unable to see the SQL server agent in the object explorer. How to enable the same? Please ,make a video on that!

@SQLServer101 9 ай бұрын

Hi Ritesh. Thank you for your question. SQL Server Agent is not part of the Express edition. You will need a paid-for edition or the Developer edition for that. Phillip

@toonytouchstone 10 ай бұрын

Thank you for your excellent video. Knowing that you are busy and may not be able to answer, I have a question. For many years I have used SQL Server with Microsoft Access as the client using linked tables. That has worked very well for me. I am currently using SQL Server 2014 with Access 2016 on a Win10 machine. I have bought a new win11 machine and I will install SQL Server 2022 Exp on the new machine. I have run the Data Migration Assistant and all my databases are cleared to install on my new Win11 machine on SQL Server 2022. I don't anticipate any problem installing SQL Server 2022 Exp and migrating my databases. On the new machine I have installed Office Pro 2021 with Access. I need to research and understand the process of migrating my Access 2016 "databases" (which store no data themselves but instead interface with SQL Server via linked tables) to Access 2021 on my new machine and with proper connections to SQL Server 2022 Exp on the new machine. Do you have videos which would help me? If not, can you recommend channels which might help me?

@SQLServer101 10 ай бұрын

Hi Toony. Thank you for your message. The only problems I've had with Access (apart from the change from Access 97 to 2000) is with the file extension. As long as both Access 2016 and 2021 can read the same types of files, you should be fine. I've opened Access 2021 and notice that in the "File types" dropdown box it has an option for "Microsoft Access 2008-2016 Databases". I would use that to open it, and then save as an Access 2021 database. However, always keep a backup copy, just in case. I hope that helps. Phillip

@toonytouchstone 10 ай бұрын

Thank you Phillip! @@SQLServer101

@rayenbenfathallah7156 Жыл бұрын

i couldn't find the object explorer when I first open mssms, even if i check the view tab, customize the window, still cannot find it, any solution please ?

@SQLServer101 Жыл бұрын

Hello. Please go to View - Object Explorer (or press F8). Phillip

@GRABASLTU 11 ай бұрын

Is there a posibility to delete and rewrite new one? Thank you

@SQLServer101 11 ай бұрын

Hi Grabasltu. Yes, you can completely uninstall SQL Server, and then reinstall it. Phillip

@KarthikK-ep3uv Жыл бұрын

Loading packages..please wait.. ...... while installing SSms it takes more time and not going to next step..any advise on this..

@SQLServer101 Жыл бұрын

Hi Karthik. I'm afraid that, without any more specifics, I can't really help you. Phillip

@niconiconii9560 Ай бұрын

Why is my windows not showing the SSMS application??? I think I followed the instruction

@SQLServer101 Ай бұрын

Hi Niconiconii. If SSMS has not installed, then please install it from here: learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16 . Phillip

@twtr6658 10 ай бұрын

hello, how do you do it when you have installed the basic type, and want to select the custom type again, please help

@SQLServer101 10 ай бұрын

Hi Twtr. I personally would uninstall SQL Server, and then reinstall it. Alternatively, if you can find SETUP.EXE, you can run that, go to the Installation tab, click "New SQL Server standalone installation or add features to an existing installation", and then add new features to your existing SQL Server. Phillip

@twtr6658 10 ай бұрын

@@SQLServer101 what about SSMS? did you uninstall it too?

@s3r3n3c 3 ай бұрын

Hi, please help. This is the error message i got everytime :( A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) ------------------------------

@SQLServer101 2 ай бұрын

Hello. Please have a look at kzfaq.info/get/bejne/qLJ8Zq92rtCWmoE.html . Phillip

@orlandomartinez4085 Жыл бұрын

I’m getting this error message A connection was stablished with the server, but then an error occurred during the login process (provider: SSL Provider, error: 0 - the certificate was issued by an authority that is not trusted.) (Microsoft SQL Server)

@SQLServer101 Жыл бұрын

Hello Orlando. Thank you for your question. Please have a look at learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/certificate-chain-not-trusted?tabs=ole-db-driver-19 . Phillip

@ismaelaye Жыл бұрын

@chibuikeonah6848 did this "I have been able to resolve it. I am now connected This how I did it: On the SQL server connection pop up window, I clicked on 'Option', Checked the 'Trust Server Certificate', clicked on 'Connect' and thats it. Thanks. I have been able to resolve it. I am now connected This how I did it: On the SQL server connection pop up window, I clicked on 'Option', Checked the 'Trust Server Certificate', clicked on 'Connect' and thats it. Thanks." God bless this man for his intelligence.

@daramolaolukayodedaniel7880 Жыл бұрын

@@ismaelaye Thank you so much. Thumbs up

@milad8652 Жыл бұрын

Does this version have package sql agent

@SQLServer101 Жыл бұрын

Hi Milan. Thank you for your question. No, SQL Agent is not part of SQL Server Express. If you want a version which includes that for your own personal use, then try SQL Server Developer (see my other videos on that version). If you want it for business use, then you would need to buy a license. Phillip

@user-ir7ox2uq6d Жыл бұрын

I am getting error when i instal The massege : exception has been thrown by the target of an invocation

@SQLServer101 Жыл бұрын

Hi. According to community.spiceworks.com/topic/2193421-sql-server-2014-exception-has-been-thrown-by-the-target-of-an-invocation, you should try installing the latest version of Microsoft .NET Framework, and then reinstall SQL Server. Phillip

@superfreiheit1 4 ай бұрын

CAn you show us how to get SQL Server 2022 Machine Learning Services start?

@SQLServer101 4 ай бұрын

Hi Super. Please have a look at learn.microsoft.com/en-us/sql/machine-learning/install/sql-machine-learning-services-windows-install-sql-2022?view=sql-server-ver16 . Phillip

@superfreiheit1 4 ай бұрын

@@SQLServer101 I know, a video would be awesome. How to get it running including r config.

@basavamaasti 11 ай бұрын

I'm getting wait on database engine recovery handle failed what to do😢

@SQLServer101 11 ай бұрын

Hi Basavamaasti. Please have a look at www.mssqltips.com/sqlservertip/4526/sql-server-install-error-wait-on-the-database-engine-recovery-handle-failed/ . Phillip

@irajtariq5769 10 ай бұрын

after installing ssms is not opening rather provide following options repair, uninstall, close though ive followed ur vedio exactly , dont know what is the issue

@SQLServer101 10 ай бұрын

Hi Iraj. I'm afraid I don't know what is happening either. However, you can download SSMS separately from learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16 . Phillip

@irajtariq5769 10 ай бұрын

Oky thnku so much

@marlorb23 4 ай бұрын

Can you add SSIS to SQL Server express?

@SQLServer101 4 ай бұрын

Hi Marlorb. It is not one of the components of SQL Server Express. You can however use SQL Server Developer instead. Phillip

@marlorb23 4 ай бұрын

@@SQLServer101 thank you Philip.

@anshulvishnaliya9551 Жыл бұрын

Hello brother it doesn't install in my windows 11, says "OOPS unable to install sql server" and give the directory of SQL Server log file something like this C\Program Files\Microsoft SQL Server\160\SetUp Bootstrap\Log\20230417_100237 how to resolve it it is big problem i m facing it from 1 months and it doesn't resolve

@SQLServer101 Жыл бұрын

Hello Anshul. It depends what the log says. If you are having a problem with SQL Server Express 2022, try SQL Server Express 2019. Phillip