How to Install Microsoft SQL Server 2022 & SSMS 20 on Windows 10/11 [ 2024 Update ] Complete guide
HTML-код
- Опубликовано: 29 сен 2024
- Hello Everyone! Today in this video I am going to step by step guide you on How to install Microsoft SQL Server 2022 and SQL Server Management Studio SSMS 20 for writing SQL queries on Windows 10/11. Windows (64-bit).
► Subscribe to Geeky Script Vlog Channel: / @geekyscriptvlogs
► Subscribe to Geeky Syntax Channel: / @geekysyntax
Geeky Script (
@GeekyScript) is a Computer Science - Educational Videos Creator 🎉
You can support us by buying a coffee ☕️ here -
www.buymeacoff...
✻ I really hope you find this video useful. ♥
✻ Please click on the CC button to read the subtitles of this video.
Installing Microsoft SQL Server 2022 is very easy. Just follow the following steps and there you go to create your first SQL database!! So let's begin.
Step 1. To install Microsoft SQL Server 2022 first you just need to download .exe file from the following Link:
www.microsoft....
Step 2. After downloading Microsoft SQL Server 2022 run the .exe by double-clicking it.
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications-which may run either on the same computer or on another computer across a network.
Step 3. You need to click the License agreement as shown in the video.
Step 4. Now simply install all Microsoft SQL Server 2022 as shown in the video.
Step 5. After installation, you need to install SQL Server Management Studio or SSMS 20. So download it from the following link:
learn.microsof...
Step 6. Now after installation simply login into the server using Windows authentication as shown in the video.
Step 7. After making a connection now it's time to create your first SQL database. For that, simply type CREATE DATABASE yourdatabasename;
And there you go!!
The instructions in this video tutorial can be applied to laptops, desktops, computers, and tablets that run the Windows 10/11 operating system like Windows 10/11 Home, Windows 10/11 Professional, Windows 10/11 Enterprise, and Windows 10/11 Education. This tutorial will work on all hardware manufacturers, like Dell, HP, Acer, Asus, Toshiba, Lenovo, and Samsung.
#SQLserver #ssms20 #SQLinstallation #sqltutorial #Windows10/11
Topics addressed in this tutorial:
How To Download And Install MySQL and Workbench IDE On Windows 10/11 64 bit OS
How to install the Microsoft SQL Server 2022 on Windows 10/11
Install Microsoft SQL Server 2022 on Windows 10/11
How to Install Microsoft SQL Server 2022 and Get Started
---------------------------------------------------------------------------
► Laptop I use:
amzn.to/4937mKs
amzn.to/3HJGXp5
► Recommended Laptops (35k Range):
amzn.to/3OqfNqL
amzn.to/3OrvHRZ
amzn.to/3SLK6uX
► Laptops 50k Range:
amzn.to/3ujvWHW
amzn.to/3UrW6CL
amzn.to/3SKlJh7
► Rode Wireless Mike:
amzn.to/4899rTH
amzn.to/3wd7nwE
► Windows 11 Pro 64-Bit: amzn.to/49cEpvk
► Windows 10 Pro 64-Bit: amzn.to/3SIxOn0
► Quick Heal Antivirus: amzn.to/49gnsAJ
► McAfee Antivirus: amzn.to/48ZoHUp
MY RELATED VIDEOS:
✻ All about Android Studio: • How to install Android...
✻ All about PostgreSQL: • How to Install Postgre...
✻ All about MongoDB: • How to install MongoDB...
✻ All about MySQL: • How to Install MySQL o...
✻ All about WordPress: • How to Install WordPre...
✻ All about Java Spring: • Spring Framework | Spr...
✻ All about Maven: • Maven project in NetBe...
✻ All about eBook: • How to Create an Ebook...
✻ All about React: • How to Install React o...
✻ All about NextJS: • How to Install Next.js...
✻ All about Angular: • How to Install Angular...
✻ All about Microsoft SQL Server: • How to Install Microso...
✻ All about Wamp: • How to Install WAMP Se...
✻ All about Visual Studio: • How to Install Microso...
THANK YOU so much for watching!
Please make sure to LIKE and SHARE the video and SUBSCRIBE to the channel for more such videos :)
CONNECT WITH ME ON:
✻ Website: geekyscript.com/
✻ LinkedIn: / geekyscript
✻ Twitter: / geekyscript
✻ Email: geekyscript@outlook.com
✻ RUclips channel: / geekyscript
Affiliate Disclaimer: Some of the links above are affiliate (referral) links which means if you do click and purchase through them, then I may receive a commission. This helps support the free content on this channel.
Did this tutorial help you to install Microsoft SQL Server 2022 & SSMS?
Comment Now!! And let me know your opinion...
And Please SUBSCRIBE for more! Also, you can Support my work through RUclips Thanks!
Hello sir, while installing Microsoft SQL Server 2022 & SSMS I am getting an error message stating that There was an error while checking the Rules of SQL server setup. Kindly help me to resolve it at the earliest as it is imperative
I would like to know about the Connection Security
@@Anitha-ew8xi same problem i am getting
Hi sir, please post a detailed void on the connection security tab and its uses ❤❤❤❤❤
i still having the erro oohs couldn't download th sql server(setup.exe)
oops... unable to install sql server (setup.exe) plz help me sirr
when i install it i got this error please someone help me "there was an error while checking Rules of sql server setup"
its installed successfully but it does show in search bar
just search ssms.. or sql server management
nice ❤❤❤
Well done. Would be nice, however, to have a comprehensive video about fixing installation errors. Installing, when it works, is simple. Troubleshooting errors is difficult.
Thanks for the idea!! ❤❤ Also, watch Complete ECommerce tutorial ⏩ ruclips.net/video/76E2QmjhRtQ/видео.html and WordPress Tutorial Playlist ⏩ ruclips.net/video/qt2BQt7uPbs/видео.html
It is showing CREATE DATABASE permission denied in database 'master'. WHAT TO DO ? PLEASEEEEE TELL 🙏
Thank you so much..
This video helped me a lot..
I actually wasted lot of time for this yesterday..
Glad it helped! Also, watch Complete ECommerce tutorial ⏩ ruclips.net/video/76E2QmjhRtQ/видео.html and WordPress Tutorial Playlist ⏩ ruclips.net/video/qt2BQt7uPbs/видео.html
Hi sir, please post a detailed video on the connection security tab and its uses
Ok sure
i can't install the SQL serve , it shows the error "system can not find the specific path" and i didn't find the solution, if anyone can help i'll appreciate it
Nice video - if it only worked in reality.
True!!! 😊 ❤
Also Subscribe to Geeky Syntax Channel: www.youtube.com/@geekysyntax/ and
www.youtube.com/@GeekyScriptVlogs/
This is very helpful. I will watch your SQL tutorial since I recently started learning DBM
Thank you for this!
Glad it was helpful! ❤
Also Subscribe to Geeky Syntax Channel: www.youtube.com/@geekysyntax/ and
www.youtube.com/@GeekyScriptVlogs/
Hi sir, please post a detailed void on the connection security tab
Hey sir I am installed in office laptop but every time I am trying to open it is asking admin password
thankyou sooo much for this!!!
You're so welcome!! 😊 ❤ Also, watch Complete ECommerce tutorial ⏩ ruclips.net/video/76E2QmjhRtQ/видео.html and WordPress Tutorial Playlist ⏩ ruclips.net/video/qt2BQt7uPbs/видео.html
I can't connect server, because there is a another server name showing me
thanks buddy, this helped alot
Glad it helped! ❤ Also, watch Complete ECommerce tutorial ⏩ ruclips.net/video/76E2QmjhRtQ/видео.html and WordPress Tutorial Playlist ⏩ ruclips.net/video/qt2BQt7uPbs/видео.html
I don't see polybase on object explorer even though I installed it, is it ok?
Thank you 👍 for this!
Welcome!! 😊 ❤ Also, watch Complete ECommerce tutorial ⏩ ruclips.net/video/76E2QmjhRtQ/видео.html and WordPress Tutorial Playlist ⏩ ruclips.net/video/qt2BQt7uPbs/видео.html
thanks. very helpful.
Glad it was helpful!! Also, watch Complete ECommerce tutorial ⏩ ruclips.net/video/76E2QmjhRtQ/видео.html and WordPress Tutorial Playlist ⏩ ruclips.net/video/qt2BQt7uPbs/видео.html
Microsoft ssms in my file not showing sir pls respond
when I attempted to connect the database and my visual studio, it said "System.Data.SqlClient.SqlException: 'Cannot open database "LibraryManagementSystem" requested by the login. The login failed.
Login failed for user 'LAPTOP-IAC39QAN\HP'.'"
how can we get the server name here
getting error cannot connect to: my "server name"
You save my day ! Thank you so much
You're welcome!!😊 ❤ Also, watch Complete ECommerce tutorial ⏩ ruclips.net/video/76E2QmjhRtQ/видео.html and WordPress Tutorial Playlist ⏩ ruclips.net/video/qt2BQt7uPbs/видео.html
But I can't create a database. I have a message error. ("Some file names listed not be created") I try many differents names but it's still not working. Can you help, thanks
Thx u so much sir ❤
Most welcome! Also, watch Complete ECommerce tutorial ⏩ ruclips.net/video/76E2QmjhRtQ/видео.html and WordPress Tutorial Playlist ⏩ ruclips.net/video/qt2BQt7uPbs/видео.html
why my keeps on sayimh repair
Why when I download it do I get the 2019 version?
I CANNOT CONNECT TO SERVER WITH BOTH METHODS
In server name: localhost\sqlexpress
Thank u so much
Thank you too! 😊 ❤
Also Subscribe to Geeky Syntax Channel: www.youtube.com/@geekysyntax/ and
www.youtube.com/@GeekyScriptVlogs/
thanks buddy
You're welcome!! 😊 ❤
Also Subscribe to Geeky Syntax Channel: www.youtube.com/@geekysyntax/ and
www.youtube.com/@GeekyScriptVlogs/
After one successful execution, I am gettting the error "Database 'demo' already exists. Choose a different database name.". I tried running the "sqllocaldb stop" and "sqllocaldb delete" in the cmd, they did not fix anything. Do you know what might be causing this problem?
You are trying to tell sql to create a db called demo when you already ran it earlier, its telling you it already exists cause that has been created before, if you want to create a new database, you have to change the name from demo. Also, my guess is you're running the other line of codes he used, like the create table and others, you have to highlight those separately before running because sql is running the full page and the demo database code creation still exists hence the error
Thanks a lot :)
You're welcome!! 😊 ❤
Also Subscribe to Geeky Syntax Channel: www.youtube.com/@geekysyntax/ and
www.youtube.com/@GeekyScriptVlogs/
Can't connect sql server
bro it doesn't connecting to server, is there any other process to do or can anyone please solve my issue
Did u solve the connection problem I am facing it now
How do know the password sir
its asking me for Server Name? what should I write?
I was facing the same issue. You just have to write your device name along with \SQLEXPRESS there. For example in this video, below the server name, user name is given as SDSGS\sdsgs , so we will take SDSGS and add \SQLEXPRESS. So the server name will be- SDSGS\SQLEXPRESS.
@@niharikasinghal8784 appreciate your reply
same issue
@raveen5372 I realized downloading the management studio alone doesn't help. You also need to download the express version as well. Then, from your computer, open command prompt and type : whoami to see the current username. Then enter the username in the management studio .
you can see the Server name by clicking on the connect-now button on the SQL Server Installation Completed window
Thank you so much
Thank you too!! ❤
Also Subscribe to Geeky Syntax Channel: www.youtube.com/@geekysyntax/ and
www.youtube.com/@GeekyScriptVlogs/