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.
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 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++ 💥
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?
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?!?
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
Got an error The accout that is running SQL server setup doesn't have one or all of the following rights, the right to backup files and directories, the ....
Hi Galaxy. I would download the SQL Server file, and then put it in an easy to find directory, such as C:/b, and then run the installation file from there. Phillip
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
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 ua-cam.com/video/n59n9M1vLm8/v-deo.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,
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
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
This video shows how to install the 2019 Express version. If you want to install the 2022 Express version, please go to ua-cam.com/video/PBG40wvhiG0/v-deo.html . Phillip
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
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
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
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 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
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
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
This was extremely helpful for installing 2022 Express. Thank you!
Clear and accurate explanation which is very easy to follow💚
Incredible video to learn how to install this software. 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!
Thank you very much for explaining everything in such a detailed matter. This video was a big help!
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 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.
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?
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?!?
good video. it helped me solve a little bit of confusion.
Exactly what I needed for my situation, good stuff homie.
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
Got an error The accout that is running SQL server setup doesn't have one or all of the following rights, the right to backup files and directories, the ....
Hi Galaxy. I would download the SQL Server file, and then put it in an easy to find directory, such as C:/b, and then run the installation file from there. Phillip
I had to delete and reinstall SSMS and this video helped me very much. Thank you
Glad it helped
Thank you so much for this detailed video.
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 :(
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
hey i am getting an error that this installer is not supported tried the usestrongcrypto thing also ,help me out please.
Clear cut explanation.
helping me mine client server sdk not showing , in feature selection??
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 ua-cam.com/video/n59n9M1vLm8/v-deo.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,
error decompressing sql server media 2019 how to fix the issue
Mine only worked once I did start/run the ssms as administrator, but thank you
how can i change from sql server dev to sql express
A certificate was explicitly revoked by user its issuer setup failed error
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
How can i get hold of you. I am having issues with my analytical services
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
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!
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
ITS A GOOD VEDIO FOR BETTER UNDERSTANT.
Mine isn't installing i am getting an oops at the end
This video shows how to install the 2019 Express version. If you want to install the 2022 Express version, please go to ua-cam.com/video/PBG40wvhiG0/v-deo.html . Phillip
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
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
Great video with a great explanation
SQL server installation cenetr sy age nhi ho rha ..kindly bta dy
Really helpful... thank you buddy
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
OMG IT HELPS ME ALOT HUHU THANKYOU SUPER DUPER MUCHHH!!!!
Thank you so much 👏
SQL Server installation error how to solve please help me sir
Thanks you so much very helpful ❤️
clear explanation nice tq
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
Thank you so much.... 👏👏🙏🙏
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
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
Very well explained video 👍
awesome guide - thank you
thanks a Lot, Very helpful
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.
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 so much, sir.
Thanks a lot! Great tutorial!
Very good explanation!!!
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
Thank you. Welldone.
It was a great help
Excellent tutorial video all points clearly explained
Glad it was helpful!
Thanks you 😊
Thank you very much 🙏
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
Thanks bro
Subscribed
Thank u....
thanks
Excellent
thank you
appreciate
Awesome video!
you save my day 😃
Can you plz help me
Internet speed omg 🙄😱
Thanks a ton MAN
thank you very much :)
Apka instal ho Gya kia
Thanks friend!!
THANK YOU!!!!
Thanks !
great
thanks!
hello boys
Good
Thanks alot!
Great!
Unable to install SQL Server (setup exe) Exit code (decimal): 2068054016
help me
Thank you
Thank you
thank you
Thank you