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++ 💥
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
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 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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-n59n9M1vLm8.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,
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?!?
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 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
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.
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PBG40wvhiG0.html . 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. 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
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 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
