That's what I call a perfectly done video - and the voice and the accent are also perfect for us non native English speakers - it's crystal clear. Merci.
Thanks in a million! Very well explained. Great content. Awesome. I couldn't find this explanation--simply put anywhere else. “Great teachers are hard to find”. Grade: A++ 💥
This video shows how to install the 2019 Express version. If you want to install the 2022 Express version, please go to czcams.com/video/PBG40wvhiG0/video.html . Phillip
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: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.) i have installed sql server developer edition. can you please help me to get through this error.
Hello I’m trying to install sql server on my Pc but it keeps giving this pop up.( There was an error while checking Rules of sql server setup) Any help please?
Hi Kedapey. Thank you for your question. Please see learn.microsoft.com/en-us/answers/questions/1072293/sql-server-setup-fails-oops-there-was-an-error-whi . Phillip
For some reason the current installer just skips from the install process straight to trying to automatically connect.. so some sql server.. and since I won't disable my firewall, not to mention the whole network it would be used in is off the grid.. it of course cannot connect, and promptly fails the entire thing with that 2068119551 general error, specifically 40 (Named Pipes Provider) "unable to connect to SQL server". It is dumb of them too. I am just now trying to install the server, then the manager tool.. so obviously there is no sql anything to connect to yet, why the heck is it trying to connect to something that has no way of existing?!?
Hi Tech. 10 Gb is the limit for SQL Server Express. Could you split your data into multiple databases? If you are using it for business, then you will need to upgrade. However, have you thought about using Azure SQL Database. That is US$3,300/month per vCore for General Business Use, together with $2.50 for 10 Gb/month - and you will always have the latest version of Azure SQL Database. That might be slightly cheaper than $55,000 for a year. See czcams.com/video/n59n9M1vLm8/video.html for some details, and azure.microsoft.com/en-gb/pricing/details/azure-sql-database/single/ for pricing. Phillip
Thank you sir sure My Friend is Using it for business he has a Yahama 2 wheeler bike showroom I am Software technician and a admin guy told him to buy but sir is it possible it without lossing past years data and install crack version is available or have to purchase it offical please 🥺 Let me know the answer sir, and thanks 🙏🏻 for Replying and clearing my doubt ASAP,
Installing software from a USB, I got error code 27506 which is password doesn’t meet Windows Policy requirements because the password is too short. How can I keep the same length of the password and change it on the program file? Or is the only solution to shorten the windows required password?
Hi Lee. Thank you for your question. Unless you have a need for Polybase, I was not select it - you will see at 13'49" that I have not checked it. If you do have a need for it, you will know which one you should use. Phillip
Hello, and thank you for your comment. I don't quite know what you mean. However, if you are referring to a Named Instance, it can be called whatever you would like. Phillip
last time, SQL server consumed 350 gb driving me crazy, may I know why and how to avoid this? Google tells Server does this by adding cache memory, how can I limit server to 20 gb ? can I
Hi Anand. Please have a look at docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver15 . Phillip
Thank you so mmuch sir, this actually has help me as a beginner. please is it posible for me to email you on some question on challenges am having current so you could walk me through them?
Hi Benedict. In my courses, I have a Q&A section where you can ask me questions. Please go to my website, IDoData.com, where you can find more information on how to learn SQL using my Udemy courses. Phillip
Thank you for your comment. Please have a look at stackoverflow.com/questions/47346445/oops-error-while-installing-sql-server-2017-developer-edition-on-windows-10
Yes you can! I use it in my courses to connect to an SQL Server on my own computer, for example. Have a look at the rest of my channel, where you can see how to connect and create SELECT statements etc - or for something more advanced, have a look at my website, www.filecats.co.uk, where I have more advanced courses.
Thank you for your comment. No - you can choose one or the other. The custom is there if you want to customise it; the basic is there if you are happy with the default settings. Phillip
Hi Donald. If you install SQL Server on your machine, then the default server name is either localhost (one word) or . (a period/full stop/dot). Phillip
Hi Mark. "." is a shorthand for "localhost" - it is the SQL server that you have installed onto your computer. You could also use its full name as well, but "." works well for me! Keep learning! Phillip
I have Microsoft SQL server management studio(mssms) in my laptop can I install SQL server express directly or can I uninstall the mssms and start installing SQL server express. Please reply
That's what I call a perfectly done video - and the voice and the accent are also perfect for us non native English speakers - it's crystal clear. Merci.
One years later it’s real useful Thank you 😊
same problem
Incredible video to learn how to install this software. Thank you!!
Clear and accurate explanation which is very easy to follow💚
This was extremely helpful for installing 2022 Express. Thank you!
One of the best video tutorial for installation
Thanks for the video. Didn't setup a SMSS earlier, but i was able to after i watched this. Very helpful!
Thanks in a million! Very well explained. Great content. Awesome. I couldn't find this explanation--simply put anywhere else. “Great teachers are hard to find”. Grade: A++ 💥
Have always been hesitant to use SQL Express, bcoz I wasn't aware of it, Thanks for this video, will use it now.
Thank you very much for explaining everything in such a detailed matter. This video was a big help!
This video shows how to install the 2019 Express version. If you want to install the 2022 Express version, please go to czcams.com/video/PBG40wvhiG0/video.html . Phillip
Thank you so much for this detailed video.
I had to delete and reinstall SSMS and this video helped me very much. Thank you
Glad it helped
good video. it helped me solve a little bit of confusion.
Exactly what I needed for my situation, good stuff homie.
Mine only worked once I did start/run the ssms as administrator, but thank you
Really helpful... thank you buddy
OMG IT HELPS ME ALOT HUHU THANKYOU SUPER DUPER MUCHHH!!!!
ITS A GOOD VEDIO FOR BETTER UNDERSTANT.
Great video with a great explanation
Clear cut explanation.
Very well explained video 👍
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: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)
i have installed sql server developer edition. can you please help me to get through this error.
Thanks a lot! Great tutorial!
clear explanation nice tq
awesome guide - thank you
Thanks you so much very helpful ❤️
It was a great help
thanks a Lot, Very helpful
Very good explanation!!!
Thank you. Welldone.
Hello
I’m trying to install sql server on my Pc but it keeps giving this pop up.( There was an error while checking Rules of sql server setup)
Any help please?
Hi Kedapey. Thank you for your question. Please see learn.microsoft.com/en-us/answers/questions/1072293/sql-server-setup-fails-oops-there-was-an-error-whi . Phillip
Thank you so much, sir.
Wait, that voice... Is that you, Phillip!? I took your Tableau Udemy course, lol.
Hi Porter. Yes, it's me. I hope you enjoyed the Tableau Udemy course. Phillip
For some reason the current installer just skips from the install process straight to trying to automatically connect.. so some sql server.. and since I won't disable my firewall, not to mention the whole network it would be used in is off the grid.. it of course cannot connect, and promptly fails the entire thing with that 2068119551 general error, specifically 40 (Named Pipes Provider) "unable to connect to SQL server".
It is dumb of them too. I am just now trying to install the server, then the manager tool.. so obviously there is no sql anything to connect to yet, why the heck is it trying to connect to something that has no way of existing?!?
Thank you so much.... 👏👏🙏🙏
Thank you
Excellent tutorial video all points clearly explained
Glad it was helpful!
Thank you very much 🙏
Thanks bro
Subscribed
hey i am getting an error that this installer is not supported tried the usestrongcrypto thing also ,help me out please.
Thanks a ton MAN
helping me mine client server sdk not showing , in feature selection??
Awesome video!
A certificate was explicitly revoked by user its issuer setup failed error
Thanks you 😊
Thanks friend!!
After 10gb of database its asking me to 55k for an year for another 10gb did i should have to pay for them or any crack version available there sir...
Hi Tech. 10 Gb is the limit for SQL Server Express. Could you split your data into multiple databases?
If you are using it for business, then you will need to upgrade. However, have you thought about using Azure SQL Database. That is US$3,300/month per vCore for General Business Use, together with $2.50 for 10 Gb/month - and you will always have the latest version of Azure SQL Database. That might be slightly cheaper than $55,000 for a year. See czcams.com/video/n59n9M1vLm8/video.html for some details, and azure.microsoft.com/en-gb/pricing/details/azure-sql-database/single/ for pricing. Phillip
Thank you sir sure My Friend is Using it for business he has a Yahama 2 wheeler bike showroom I am Software technician and a admin guy told him to buy but sir is it possible it without lossing past years data and install crack version is available or have to purchase it offical please 🥺 Let me know the answer sir, and thanks 🙏🏻 for Replying and clearing my doubt ASAP,
thanks
THANK YOU!!!!
Installing software from a USB, I got error code 27506 which is password doesn’t meet Windows Policy requirements because the password is too short. How can I keep the same length of the password and change it on the program file? Or is the only solution to shorten the windows required password?
appreciate
how can i change from sql server dev to sql express
error decompressing sql server media 2019 how to fix the issue
thank you very much :)
Apka instal ho Gya kia
Mine isn't installing i am getting an oops at the end
Thank u....
thank you
Thanks !
which polybase configuration should I use? the standalone option or the other one?
Hi Lee. Thank you for your question. Unless you have a need for Polybase, I was not select it - you will see at 13'49" that I have not checked it. If you do have a need for it, you will know which one you should use. Phillip
Excellent
Must I add 2019 express at the end?
Hello, and thank you for your comment. I don't quite know what you mean. However, if you are referring to a Named Instance, it can be called whatever you would like. Phillip
@@SQLServer101 Yea the name instance, I got it all set up. Thanks!
Great!
While installing it is showing Unable to install sql server exit code decimal attempted to perform an unauthorised operation
Hello Sahla. It's that decimal code which you have omitted that I would need in order to help you. Phillip
last time, SQL server consumed 350 gb driving me crazy, may I know why and how to avoid this? Google tells Server does this by adding cache memory, how can I limit server to 20 gb ? can I
Hi Anand. Please have a look at docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver15 . Phillip
Thank you so mmuch sir, this actually has help me as a beginner. please is it posible for me to email you on some question on challenges am having current so you could walk me through them?
Hi Benedict. In my courses, I have a Q&A section where you can ask me questions. Please go to my website, IDoData.com, where you can find more information on how to learn SQL using my Udemy courses. Phillip
SQL server installation cenetr sy age nhi ho rha ..kindly bta dy
thanks!
SQL Server installation error how to solve please help me sir
How can i get hold of you. I am having issues with my analytical services
you save my day 😃
Can you plz help me
I am having an error saying please input a valid location of the file
Hi Ibrahim. I suggest creating a subfolder somewhere, and moving the file there. Phillip
Thanks alot!
Getting error message "oops cannot decompress SQL server media"
Thank you for your comment. Please have a look at stackoverflow.com/questions/47346445/oops-error-while-installing-sql-server-2017-developer-edition-on-windows-10
great
Great tuto, that is up to date.
Can the SSMS connect to any SQL server (with given permission, password, ports...) or only to Azure SQL servers?
Yes you can! I use it in my courses to connect to an SQL Server on my own computer, for example. Have a look at the rest of my channel, where you can see how to connect and create SELECT statements etc - or for something more advanced, have a look at my website, www.filecats.co.uk, where I have more advanced courses.
Is it actually possible to change the Installation path for SSMS?
Hello Fabrizio. It is possible, but it's not trivial. Have a look at sqlx86.com/2018/12/28/installing-ssms-to-a-different-location/ . Phillip
Do we need to install both basic and custom type?
Thank you for your comment. No - you can choose one or the other. The custom is there if you want to customise it; the basic is there if you are happy with the default settings. Phillip
Is it possible to get back to the prompt at 7:30 after closing it?
Hi Be. I don't think that you can. Phillip
@@SQLServer101 too bad, though small, but it looks like a nice GUI. They even put a smiley face on it :(
hello boys
How do I get the server name?
Hi Donald. If you install SQL Server on your machine, then the default server name is either localhost (one word) or . (a period/full stop/dot). Phillip
@@SQLServer101 thank you
Good
hello sir i can't see the list how do i get server
Hi Rxxr. If you have a local server, then try using either localhost or . The last one is a period/full stop/dot. Good luck.
@@SQLServer101 tried this not work too
Nice tutorial. Why have a "." as server name though?
Hi Mark. "." is a shorthand for "localhost" - it is the SQL server that you have installed onto your computer. You could also use its full name as well, but "." works well for me! Keep learning! Phillip
Internet speed omg 🙄😱
Unable to install SQL Server (setup exe) Exit code (decimal): 2068054016
help me
Thank you
thank you
I have Microsoft SQL server management studio(mssms) in my laptop can I install SQL server express directly or can I uninstall the mssms and start installing SQL server express. Please reply
Hi It's. Yes, you can do either. Phillip
Thank you