Please don't change a thing about the way you go about delivering these helpful and thorough videos. Some people just have a way that makes it so easy and pleasant for others to learn from
The algorithm brought me here and glad it did. Just bought a desktop specifically to learn SQL. Your style of presentation is straightforward and brilliant. Thank you!!
I have been trying to import excel data into SQL for the last 3 days. I tried a lot of stuff that I read online but non worked. This video is a life saver. Was easy to follow and understand. Problems landed me here but am hooked now. Will check you other courses in Udemy. Thank you
@23:56 This really helped a lot. I started a tutorial and couldn't believe I was already stuck and just in the very beginning lol. Up and running now, tysm!
Thank you so much, I was stuck for like 2h because I didn't uncheck the Azure extension for SQL server and assumed it was something to do with my previous installations or with my Microsoft account. I don't remember the last time I tried to install something where you had to uncheck something, otherwise it would fail in the next step with an error that was not be helpful at all.
If you got the error "A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (Framework Microsoft SqlClient Data Provider)" => Choose button Option => Tick on Trust server certificate
Thank for this tutorial. Really handy and helpful. Explanation is very through and in details which is hard to find in many other videos available on the TH-cam.
Thank you for the crystal clear instructions. I too have subscribed and given a hearty thumbs up. Looking to watching your other videos. Thank you so much.
Hello I'm in the middle of instalation. After the first part, before you say we have to install 'the front ', appeared a small window saying that I should restart the computer. You didn't get that message. Should I restart and then come back to install the 'front' ?(Continue instalation from min 20.20)
Hello, every time I try to connect to mysql database, I receive a message saying that 'This connector requires one or more additional components to be installed before it can be used.' I clicked on the 'Learn more' button and is said that I needed to install from MYSQL Community Downloads' the 'Connector/NET 9.1.0,' however, despite having downloaded it, I am still getting the same message! Can anyone help, please?
Hello I got the following problem when trying to connect to the server: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (Framework Microsoft SqlClient Data Provider). Could you help me with this? Edit: nvm, solved by checking the "trust this server" option.
@@huanyanlim2981 Hello, I can't quite recall, but it came from a prompt on the right side on the screen, near the bottom there's one of the options that says "trust this server" and it's set to False, I changed it to True and I got the access needed. I'm sorry I can't remember it better because now I connect directly with just my user, it doesn't ask anymore.
@@huanyanlim2981 Hi again, I just checked and found it, on the server list in Azure Data Studio select the database you want to gain access to, then right click and hit the "Edit Connection" option, there a prompt on the right side of the screen should appear, navigate near the end of the list and you should find an option that's called "Trust server certificate", change the False to True and save, you should be able to connect now.
Hi! Thank you for your video! As I try to install the SQL Server Management Studio (SSMS) I get an error that says „Setup failed. Fatal error during installation (0x800706643)”. It also says a previous installation required a reboot of the machine and even though I restart the computer and run the setup again I get the same error. I tried versions 19.0.2 and 18.12.1. Which could be the problem?
Hi Khaled. Thank you for your message. I would try downloading the full program, and then right-hand clicking on it and selecting "Run as Administrator". Phillip
Hi thanks for the video, I have a challenge, my machine gets stuck for hours right after clicking yes from the “do you want this application to make changes to your computer” message☹️ been stuck since yesterday on “getting things ready” please assist
Hi. I would try right-hand clicking on the application before running it, maybe holding the Shift key down, and select "Run as Administrator". See if that works. Phillip
Nice information. Thanks a lot. I have a query. Let me know whether can we upgrade ssis 2014 packages and deploy on sql server 2022 db catalog. Also can we deploy sql server 2022 on Azure VM and whether run ssis packages from Azure VM.
Hi Saket. Please see learn.microsoft.com/en-us/sql/integration-services/install-windows/upgrade-integration-services-packages-using-the-ssis-package-upgrade-wizard?view=sql-server-ver16 - and yes, you can deploy SQL Server 2022 on Azure VM. Phillip
@@SQLServer101 Hi, Thank you very much for your immediate responce. However the link what you provided is talking SSIS packages migration till 2019. I don't think lower versions of SSIS package below 2019 can be migrated directly to SSIS 2022.
Hi Rahul. Assuming you have just installed SQL server on your computer, I would use the server name localhost or . (dot). Depending on your error, you might want to have a look at th-cam.com/video/rLL3LEIj2jM/w-d-xo.html . Phillip
Lenovo g500s model. Intel CPU version: Intel (R) core ( TM) i3-3110M CPU@ 2.40 GZ System memory: 6144 MB Hi, the above information is my laptop configuration. I brought in 2013. Could you tell this configuration is enough for the run SQL server in my laptop. Please help me.
Hi Gopik. Yes, that should be enough to run SQL Server. I assume from the system memory that you have a 64-bit Windows. You should use a version which is comparable with your version of Windows. Phillip
Hi. Thank you for your question. I'm afraid that you haven't given enough information. I would look at the error code (probably about 8 characters), and then Google it. Phillip
Hey man! Thank you for this useful video. I encounter a problem when installing the Analysis Service. - Can you please tell me what this means please? TITLE: Microsoft SQL Server 2022 Setup - The service could not be started. Reason: Service 'MSOLAP$MSSQLSERVER2022' start request failed. Additionally, the error refers me to 'Connect your SQL Server to Azure Arc'. But I don't need Azure Further down the line, there is this other error saying: No connection could be made because the target machine actively refused it 127.0.0.1:2382 (System)
Hi - I would ask the question in Microsoft Q&A. You will need to share the Summary.txt log file generated by SQL Server Setup on the last installation. Go to learn.microsoft.com/en-us/answers/ to ask that question. Phillip
Hi Andrew. I can't help with "etc" - that is too vague. Ensure that you have enough space on your hard drive, and you have proper administrative rights. Phillip
@@SQLServer101 sorry for the explaination, the problem said "please provide a valid location, the specified directory is not valid becauss this directory is compressed or is in a compressed directory. Im using C:\Program Files\Miscrosoft SQL Server"
Hi Kiet. Thank you for your message. Please have a look at learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size#resolutions . Phillip
Hi Pipilina. Thank you for your question. I don't know, but try right-hand clicking the file and select "Run as administrator" if that option exists. Phillip
Hello brother, I got an error while connecting SSMS to Database engine services, I have selected the server name that is visible below the database engine services. Can you please help me on this??
Hi Deepak. Thank you for your question. If you have installed SQL Server on your own computer, then try localhost or . (a dot). If you have installed it on another computer, please ask their DBA for the connection details. Phillip
Hi. You can increase the max degree of parallelism (MAXDOP) setting by running EXEC sp_configure 'max degree of parallelism', 8; -- replace 8 with the number of processors you want to use RECONFIGURE; Phillip
mine just says this and it makes no sense, literally did everything correct: TITLE: Microsoft SQL Server 2022 Setup ------------------------------ The following error has occurred: Attempted to perform an unauthorized operation. Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup. getting bored of it.
@@SQLServer101 To pirate Solidworks and get all the features you need to download and install sql server and use this video to set up some parts of the application, like the electrical components.
Please don't change a thing about the way you go about delivering these helpful and thorough videos. Some people just have a way that makes it so easy and pleasant for others to learn from
Installed just the way you walked through. No issues faced at all, loved the smooth installation. Thanks a mil!!❣
The algorithm brought me here and glad it did. Just bought a desktop specifically to learn SQL. Your style of presentation is straightforward and brilliant. Thank you!!
I have been trying to import excel data into SQL for the last 3 days. I tried a lot of stuff that I read online but non worked. This video is a life saver. Was easy to follow and understand. Problems landed me here but am hooked now. Will check you other courses in Udemy. Thank you
At 7:51 in video the link for free download(that is:- Visual Studio Dev Essentials members) is not working
Hi User. Thank you for your message. I have just tried going to my.visualstudio.com/ , and it works for me. Phillip
@23:56 This really helped a lot. I started a tutorial and couldn't believe I was already stuck and just in the very beginning lol. Up and running now, tysm!
Thank you so much!!! I love your channel and the way you explain. Really to comprehend SQL server rather than find a quick glance
Thanks for the great video. Followed it to a tee and got the SQL 2022 installed on my VM.
It was the full stop of my queries. really liked the video
Thank you so much for this video. I’m new to SQL and this was a massive help. You got a new subscriber. Keep up the good work
Thank you. I needed help with the second half and your video was very helpful. Smooth as hot knife in butter!
Awesome tutorial from the gentleman! very explanatory and understandable. Thank you sir!!!
Thank you so much, I was stuck for like 2h because I didn't uncheck the Azure extension for SQL server and assumed it was something to do with my previous installations or with my Microsoft account. I don't remember the last time I tried to install something where you had to uncheck something, otherwise it would fail in the next step with an error that was not be helpful at all.
Hi Samuel. I agree - it was quite a surprise when I came across it. A very…interesting…design decision. Phillip
Same
If you got the error "A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (Framework Microsoft SqlClient Data Provider)" => Choose button Option => Tick on Trust server certificate
Hi Tien. That's right; please have a look at my video on the subject - th-cam.com/video/e-Oz_FCz62A/w-d-xo.html . Phillip
that helped me out thank you
Thanks man, things shouldn't be this complicated.
I want to echo the previous commenters. Wonderful tutorial. Thanks for the time you put into that.
Thank you Deron. I'm glad that you enjoyed it, and I hope it helps you on your SQL journey. Phillip
Thank for this tutorial. Really handy and helpful. Explanation is very through and in details which is hard to find in many other videos available on the TH-cam.
Clear explanation - you make so easy to follow the process. Thank you so much.
2nd half helped me out, thank you for the videos!
Nice video. This is the most complete video tutorial about sql server.
thank you so much, your explanation were really complete, i was so confuse before watching this, thanks again
Hello
i get issue with iint he minit 19:40
Error meesage " DataBase Engine service : status Failed .
Can you please assist ?
BR ,
Hi Dev. Thank you for your question. Do you have a status code, probably a 5-digit number? Phillip
@@SQLServer101 no it just feild to install .
i have win 11,
Hi Dev. I'm afraid that, without any details, I can't really help. Phillip
@@SQLServer101 i have the same problem Error code: 0x851A001A
Thank you for the crystal clear instructions. I too have subscribed and given a hearty thumbs up. Looking to watching your other videos. Thank you so much.
Awesome, thank you! I hope that you enjoy the other videos. Phillip
Thank you very much. I am your follower from Syria. I have benefited a lot from your explanation
Very clear and perfect explanation. without any issue I could install both software. Thanks Phillip :)
Thank you so much! Your tutorial was lucid and easy to follow.. Looking forward to seeing more of your content!
exactly what I was searching for, great channel btw! thanks
Thank you so much! I've been struggling for 2~3days to download SQL2022 in window 11! I should've watched this video much earlier! Thanks a lot!
Hello
I'm in the middle of instalation. After the first part, before you say we have to install 'the front ', appeared a small window saying that I should restart the computer. You didn't get that message. Should I restart and then come back to install the 'front' ?(Continue instalation from min 20.20)
Hi x2. Thank you for your question. If the computer asks you to reboot, then I would do so. Phillip
Very thorough and easy to follow. Thank you.
Hi I just noticed that SSMS v20.2 no longer comes with Azure Data Studio
Hi Chi. Thank you for your message. That's right - if you want Azure Data Studio, then you need to download it separately. Phillip
Oh God, did they publish SQL Server 2022 Developer edition! 😀
I know. Finally!
You are brilliant!!! Well done!!!!
Thank you . Very detail .
I will sure buy one of your sql server courses
Hi Isiakaraheem. Thank you very much. I wish you well on your SQL learning journey. Phillip
You can also input dxdiag in the windows search bar on the bottom left
Thank you so much for the video, it really helped me save my time .
Thank u so much for the helpful tutorial. I was looking for this.
Hello, every time I try to connect to mysql database, I receive a message saying that 'This connector requires one or more additional components to be installed before it can be used.' I clicked on the 'Learn more' button and is said that I needed to install from MYSQL Community Downloads' the 'Connector/NET 9.1.0,' however, despite having downloaded it, I am still getting the same message! Can anyone help, please?
Hi Pauline. I'm afraid I've never used mySQL, so I don't know. Phillip
Very Great Session… Thank You So Much 🙏
This video helped a lot. Thank you very so much!
Very understandable, thank you!
Hello I got the following problem when trying to connect to the server: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (Framework Microsoft SqlClient Data Provider). Could you help me with this?
Edit: nvm, solved by checking the "trust this server" option.
Hi May I know where can I find the trust this server option?
@@huanyanlim2981 Hello, I can't quite recall, but it came from a prompt on the right side on the screen, near the bottom there's one of the options that says "trust this server" and it's set to False, I changed it to True and I got the access needed. I'm sorry I can't remember it better because now I connect directly with just my user, it doesn't ask anymore.
@@huanyanlim2981 Hi again, I just checked and found it, on the server list in Azure Data Studio select the database you want to gain access to, then right click and hit the "Edit Connection" option, there a prompt on the right side of the screen should appear, navigate near the end of the list and you should find an option that's called "Trust server certificate", change the False to True and save, you should be able to connect now.
@@sirmudkipactuallythanks a bunch it worked
when connect to database engine and choise Desktop_98....... i can't connect but when i write loclhost it's normal it connected ??
Hi Ali. It depends what you have called your database engine. It sounds like it is on your computer, so localhost or . would work fine. Phillip
Sir you rock! Thank you for sharing this video.
Hi! Thank you for your video!
As I try to install the SQL Server Management Studio (SSMS) I get an error that says „Setup failed. Fatal error during installation (0x800706643)”. It also says a previous installation required a reboot of the machine and even though I restart the computer and run the setup again I get the same error. I tried versions 19.0.2 and 18.12.1. Which could be the problem?
Came back to say I've found a solution thanks to the creator of this video: th-cam.com/video/V-ZfxYCOC3I/w-d-xo.html
Thank you very much sir from sri lanka.
Thank you so much for your gratitude! It means a lot to me that my content is reaching viewers all the way in Sri Lanka. Phillip
Can Someone help me, I am getting error while installing it on my PC? Error: External component has thrown error.
Hi Saurabhkumarmodi. Unfortunately, you haven't provided enough specific details for me to help you. Phillip
Very helpful thank you very much!
sir when i connect to ssms I use loclhost then I can connect to ssms why ? i want answer please
Hi Ali. It appears that you have installed SQL Server on your computer. In which case, to connect to it, you can use . or localhost. Phillip
hello, i followed all the steps on the video but I'm still getting challenges to connect to a server. is there anything i can do?
Hello Hayford. Thank you for your question. Please have a look at th-cam.com/video/PbRSOVbB5Ks/w-d-xo.html . Phillip
Database Engine service and analysis services is failed what to do now?
Hi Harika. What is the detailed error/comment? Phillip
Excuse me , please
I trayed to download sql server 2022 yesterday and this message appeared for me
setup account privileges "failed"
Hi Khaled. Thank you for your message. I would try downloading the full program, and then right-hand clicking on it and selecting "Run as Administrator". Phillip
thank you, very helpful. keep going
Hi thanks for the video,
I have a challenge, my machine gets stuck for hours right after clicking yes from the “do you want this application to make changes to your computer” message☹️ been stuck since yesterday on “getting things ready” please assist
Hi. I would try right-hand clicking on the application before running it, maybe holding the Shift key down, and select "Run as Administrator". See if that works. Phillip
wonderful - super helpful
Iam not able to see data base engine configuration
Very useful ❤
Nice information. Thanks a lot. I have a query. Let me know whether can we upgrade ssis 2014 packages and deploy on sql server 2022 db catalog. Also can we deploy sql server 2022 on Azure VM and whether run ssis packages from Azure VM.
Hi Saket. Please see learn.microsoft.com/en-us/sql/integration-services/install-windows/upgrade-integration-services-packages-using-the-ssis-package-upgrade-wizard?view=sql-server-ver16 - and yes, you can deploy SQL Server 2022 on Azure VM. Phillip
@@SQLServer101 Hi, Thank you very much for your immediate responce. However the link what you provided is talking SSIS packages migration till 2019.
I don't think lower versions of SSIS package below 2019 can be migrated directly to SSIS 2022.
Thanks for the video. It is very useful.
wow ! thank you so much it was very helpful
Hi Please help to connect SSMS to server I had tried so many times every time i am getting same error
Hi Rahul. Assuming you have just installed SQL server on your computer, I would use the server name localhost or . (dot). Depending on your error, you might want to have a look at th-cam.com/video/rLL3LEIj2jM/w-d-xo.html . Phillip
I tried to download it but the MS afee webadvisor prevented me, althoug I disabled it and disabled real time scan.
Is there another way to download?
that was very nice thank you for these amazing way
I am unable to download the developer version. Once i click on it, it opens up a blank ‘untitled’ site. Pls assist
Hi Chinenye. Please go to www.microsoft.com/en-gb/sql-server/sql-server-downloads and try downloading it from there. Phillip
@@SQLServer101 Thanks, It eventually worked
Thank you very much, it's really helpful
excellent explanation, thank you very much
Tnx this video was really helpfull
Lenovo g500s model.
Intel CPU version: Intel (R) core ( TM) i3-3110M CPU@ 2.40 GZ
System memory: 6144 MB
Hi, the above information is my laptop configuration. I brought in 2013. Could you tell this configuration is enough for the run SQL server in my laptop. Please help me.
Hi Gopik. Yes, that should be enough to run SQL Server. I assume from the system memory that you have a 64-bit Windows. You should use a version which is comparable with your version of Windows. Phillip
It's fine if I use basic installation in developer edition?
Hi Daniel. It's fine by me if you use basic installation for the Developer edition. Phillip
Gracias Excelente vvideo Saludos desde Guanajuato Mexico
De nada y Saludos. Phillip
i failed to install database service engine and integration service. could you please help me with that.
Hi. Thank you for your question. I'm afraid that you haven't given enough information. I would look at the error code (probably about 8 characters), and then Google it. Phillip
Hey man! Thank you for this useful video. I encounter a problem when installing the Analysis Service. - Can you please tell me what this means please?
TITLE: Microsoft SQL Server 2022 Setup - The service could not be started. Reason: Service 'MSOLAP$MSSQLSERVER2022' start request failed.
Additionally, the error refers me to 'Connect your SQL Server to Azure Arc'. But I don't need Azure
Further down the line, there is this other error saying:
No connection could be made because the target machine actively refused it 127.0.0.1:2382 (System)
Hi - I would ask the question in Microsoft Q&A. You will need to share the Summary.txt log file generated by SQL Server Setup on the last installation. Go to learn.microsoft.com/en-us/answers/ to ask that question. Phillip
I got problem, it said the location for installing is not valid etc
Hi Andrew. I can't help with "etc" - that is too vague. Ensure that you have enough space on your hard drive, and you have proper administrative rights. Phillip
@@SQLServer101 sorry for the explaination, the problem said "please provide a valid location, the specified directory is not valid becauss this directory is compressed or is in a compressed directory. Im using C:\Program Files\Miscrosoft SQL Server"
Thank you so much for this video
Excellent vedio well presented.other guys comments says it all.
thanks bro it work
Error installing SQL Server Database Engine Services Instance Features . how to fix
Error code: 0x851A001A
Hi Kiet. Thank you for your message. Please have a look at learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size#resolutions . Phillip
@@SQLServer101 I don't know what to do
My installation process failed with error, can u help me. It said the system cannot find the file specified
Hi Rohan. I would try downloading the installation file again. Phillip
What version of Windows 11 are you using?
Hi Ismetsolen. I was using the version current as of December 2022. Phillip
Great tutorial! This belongs on the Microsoft site.
why do i get an error that says that it needs elevation? im using the admin account
Hi Pipilina. Thank you for your question. I don't know, but try right-hand clicking the file and select "Run as administrator" if that option exists. Phillip
Thanks for a great video
Thank you very much!
Hello brother, I got an error while connecting SSMS to Database engine services, I have selected the server name that is visible below the database engine services. Can you please help me on this??
Hi Deepak. Thank you for your question. If you have installed SQL Server on your own computer, then try localhost or . (a dot). If you have installed it on another computer, please ask their DBA for the connection details. Phillip
@@SQLServer101 its not connected
Yes it's not connected
Except analysis services all are failed 😢
Thank you!
Thanks for work
Thanks for the video
❤❤❤❤ Thanks sir
how can i force sql server developer edition to use more cpu
Hi. You can increase the max degree of parallelism (MAXDOP) setting by running
EXEC sp_configure 'max degree of parallelism', 8; -- replace 8 with the number of processors you want to use
RECONFIGURE;
Phillip
@@SQLServer101 will try it surely
I like your PC theme, where is it from?
Hi. It’s just the default on my computer. Phillip
أخيرا اشكرك بالعربى
Thanks 😂
Thank you so much
thankyou for the video very good
database engine failed help me?
Hi Meliqez. It depends what the detailed error message says. Phillip
Good day. I can’t find my server name please help 😢
Hi. If you have installed SQL Server onto your computer, then try . or localhost
Phillip
mine just says this and it makes no sense, literally did everything correct:
TITLE: Microsoft SQL Server 2022 Setup
------------------------------
The following error has occurred:
Attempted to perform an unauthorized operation.
Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.
getting bored of it.
Hi TheJWRB. Please have a look at learn.microsoft.com/en-us/troubleshoot/sql/database-engine/install/windows/error-set-up-update-instances . Phillip
@@SQLServer101 I managed to fix it but thank you 🙏
@@SQLServer101 I fixed it by uninstalling bullguard and then trying the process again 😄
Good video.
SERVER NAME IS MISSING please help
now done
What does SQL server do for me as a SolidWorks User?
Hi Hatemmohammed. I'm afraid I don't know, as I'm not a SolidWorks user. Phillip
@@SQLServer101 To pirate Solidworks and get all the features you need to download and install sql server and use this video to set up some parts of the application, like the electrical components.
Спасибо большое!
Debug option provided or not??
Hi Ashish. Please have a look at superuser.com/questions/1012087/how-to-debug-unattended-installation-of-ms-sql-server-2012 . Phillip