No video :(

Want to know how to install SQL Server Express 2022?

Подписаться 17 тыс.

Просмотров 74 тыс.

50% 1

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/que...
98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/dat...
70-462 SQL Server Database Administration (DBA): rebrand.ly/sql...
Microsoft SQL Server Reporting Services (SSRS): rebrand.ly/sql...
SQL Server Integration Services (SSIS): rebrand.ly/sql...
SQL Server Analysis Services (SSAS): rebrand.ly/sql...
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/mic...
----
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....

Опубликовано:

26 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 88

@shrikrushnajadhav2621 8 месяцев назад

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.

@jillannsarah5932 4 месяца назад

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!

@bocchi483 6 месяцев назад

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

@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

@oluseyinaomi4068 11 месяцев назад

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

@SQLServer101 11 месяцев назад

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

@traafnphuscnguyeen 29 дней назад

Thanks a lot for this video

@user-tn9py4kx8n Год назад

This is very helpful many thanks!

@adrianhodrea8246 6 месяцев назад

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 6 месяцев назад

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

@niconiconii9560 3 месяца назад

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

@SQLServer101 3 месяца назад

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

@alvarojosejuliobeltran822 Год назад

Thanks for the video. You show me right way.

@s3r3n3c 4 месяца назад

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 4 месяца назад

Hello. Please have a look at ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rLL3LEIj2jM.html . 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

@StratOnFire Год назад

Thanks so much for this!!!!

@RiteshKumar-cn3qb 11 месяцев назад

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 11 месяцев назад

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

@superfreiheit1 5 месяцев назад

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

@SQLServer101 5 месяцев назад

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 5 месяцев назад

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

@parthasarathipatra9483 Год назад

Thanks a lot for the tutorial.

@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

@marlorb23 5 месяцев назад

Can you add SSIS to SQL Server express?

@SQLServer101 5 месяцев назад

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

@marlorb23 5 месяцев назад

@@SQLServer101 thank you Philip.

@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

@GRABASLTU Год назад

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

@SQLServer101 Год назад

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

@basavamaasti Год назад

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

@SQLServer101 Год назад

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

@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

@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

@twtr6658 11 месяцев назад

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

@SQLServer101 11 месяцев назад

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 11 месяцев назад

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

@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

@irajtariq5769 Год назад

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 Год назад

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 Год назад

Oky thnku so much

@JJCK725 8 месяцев назад

Thanks brother

@toonytouchstone 11 месяцев назад

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 11 месяцев назад

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 11 месяцев назад

Thank you Phillip! @@SQLServer101

@birariraj9950 Год назад

So helpful video 👍🏻

@TheEngVibe Год назад

Error could not write value NT SERVICE\SQLWriter to key Do me a favor plss 😢😢

@SQLServer101 Год назад

Hi Lymy. Please have a look at stackoverflow.com/questions/39058510/cant-install-microsoft-sql-server-because-of-vssaccesscontrol . Phillip

@DZefyr- Год назад

dead link for downlaods please fix

@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

@sandilekhomo3030 Год назад

Thank You

@LaQuintaPataDebate Год назад

muchas gracias!

@deepikaa1106 Год назад

Thank you so much this video saves me 🙂

@kuzukumilol5428 Год назад

i keep on having the error decimal

@SQLServer101 Год назад

Hi. Thank you for watching the video. I don't understand the question. Phillip

@sedjrotovihouande4922 Год назад

Thanks, very useful

@rajeevanm2791 Год назад

I am getting error while runnig rules

@SQLServer101 Год назад

Hi. It depends now what error you have found. Phillip

@shivamsharma334 Год назад

I got the below error :- WAIT ON THE DATABASE ENGINE RECOVERY HANDLE FAILED

@SQLServer101 Год назад

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

@chibuikeonah6848 Год назад

Thanks for this. I got an 'Aditional information' message: A network related or instance-specific error occured while establishing a connection to SQL Server. The 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)

@SQLServer101 Год назад

Hi Chibuikeonah, it seems like you don’t have the correct server name. If it is one that is installed on your computer, try . or localhost Phillip

@chibuikeonah6848 Год назад

I tried using the localhost but it didn't work. Is there any other thing I can do about it? Thanks Phillip

@chibuikeonah6848 Год назад

More so, I installed the SQL server both the Basic an custom. I followed the steps in your video.

@chibuikeonah6848 Год назад

''a connection was successfully established with the server but then an error occurred during login process. (Provider: SSL provider, error :0- the certificate chain was issued by an authority that is not trusted)(Microsoft SQL Server) The certificate chain was issued by an authority that is not trusted'' Currently , this is the error message I get when Use the data base engine to connect instead of localhost.

@chibuikeonah6848 Год назад

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.

@sassy_bread Год назад

no matter what i try i keep getting 'exit code (Decimal): -2061893606Error description: Wait on the Database Engine recovery handle failed.' Does anyone know how to fix this? I'm running Windows 11

@SQLServer101 Год назад

Hi Sassy. Thank you for your question. Please have a look at learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size . Phillip

@busyshah Месяц назад

Thats a really good video. However I am getting below error while creating any new database or uploading adventureworks backup -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TITLE: Microsoft SQL Server Management Studio ------------------------------ Create failed for Database 'TestMaster'. (Microsoft.SqlServer.Smo) For help, click: go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=17.100.40.0&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262) For help, click: docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-262-database-engine-error ------------------------------ BUTTONS: OK ------------------------------

@SQLServer101 28 дней назад

Hi Busy. Thank you for your question. It sounds like you don't have the permissions to create a database. Please contact your Database Administrator. Philip