Extremely helpful for a Chartered Accountant like me in Finance Department who is using MacBook Air and learning SQL for the first time - Instructions were crystal clear and perfect. Since I was getting error setting up the SQL connection, I ended up searching and this video helped solve the error ! Thanks !
@snewm-xh1cx9 ай бұрын
This may help some people: If you used a different password and got the error message: 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: TCP Provider, error: 40 - Could not open a connection to SQL Server) Then it may be because your password did not meet SQL Server password policy requirements Your password must be at least 8 characters and contain characters from three of the following four sets: Uppercase letters, Lowercase letters, Base 10 digits, and Symbols. Hope that may help someone (And thanks for the video!!)
@pravallikamadabhattula85229 ай бұрын
Thank you for your info....before you. have to uninstall Docker and again re-install docker and set the password in terminal by using below conditions for the password below I'm mentioning in the BOLD. Your password must be at least 8 characters and contain characters from three of the following four sets: Uppercase letters, Lowercase letters, Base 10 digits, and Symbols.
@gowtham31824 ай бұрын
It works
@SaurabhGupta-wh5ww4 ай бұрын
thanks
@joel_himself4 ай бұрын
omg life saver
@mellowmeow96343 ай бұрын
thank you
@mahmoudblackjack12 күн бұрын
“An excellent and clear explanation! The steps to install SQL were very easy to follow, and I really appreciate how you covered potential issues and their solutions. You saved us a lot of time and effort. Thank you for your outstanding work and amazing clarity! 🌟 Much love and respect from Palestine 🇵🇸❤”
@poojababerwal79387 ай бұрын
Ohhh god finally somebody shared something efficient. Thankyou for the clear explanation. It worked!
@hariparajuli8 ай бұрын
Awesome. Finally found a solution through your video after many trials and errors. Thanks.
@amy_mishra3 ай бұрын
Finally got the SQL working on Mac. Thanks a lot :)
@navaneethkhussanagari3953Ай бұрын
howww bro plz help me
@TheViitinhow4 ай бұрын
Thank you so much! i've been ignoring my SQL classes, because I didn't understand how to intall all these program on MacOs. So now I can finally move afford. Gratidão, diretamente, do Brasil!
@abijaffa54306 ай бұрын
Thanks for sharing this! The instructions are crystal clear. It worked the first time around -you gained a new subscriber!
@TamNell12 күн бұрын
My godness!! Thankyou sooo sooo much!!!! Finally after few others videos on youtube didnt work, then I found yours and it ACTUALLY WORK!
@emerson37993 ай бұрын
Holy Moly!! How happy I am to have found your tutorial video. You're a life saver! 👍👍
@chriz_SEАй бұрын
Long live to you my friend, Genius! Thank you so much for the video, had no idea from where to start !
@rabiiaceylan22 күн бұрын
i'm trying to make this happen for days.. thanks a lot
@engaudy3 ай бұрын
Great asset man! Thanks for explaining in a good neat approach
@vicheka92097 ай бұрын
it's work for my m1 thank you for sharing and please keep sharing for more
@nimashafernando27789 ай бұрын
Thank you so much .This is such a life saver .
@AygerimAsantur9 ай бұрын
Hi! Thanks for the video! I am learning Alex the analyst BootCamp and needed to install the SQL server. your video is helping me. at the end when i try to connect this occurs "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: TCP Provider, error: 40 - Could not open a connection to SQL Server)" what to do here?
@himanshurathi12428 ай бұрын
same here!
@CMG58173 ай бұрын
same here...
@jumkye3 ай бұрын
Same here
@maybee3953 ай бұрын
has anyone figured out how to get around this ?
@AygerimAsantur3 ай бұрын
nah, I even quit learning data analytics-not because of this, but still, why is it so difficult
@becauseiwanttoanime95418 ай бұрын
Thank you very much, easy to understand and worked perfectly!
@May-lu8jtАй бұрын
Hello, this appears to me in min 14:12, (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: TCP Provider, error: 40 - Could not open a connection to SQL Server).. what should I do?
@paramilyАй бұрын
I have the same error message! It's because the password doesn't fit! Your password must have 1) Upper case + 2) Lower case + 3) Special character + 4) digits. It works perfectly after resetting the password. Give it a try!
@ashwineekumarroutray140419 күн бұрын
same here
@true.living55692 күн бұрын
did you solve this error?
@May-lu8jt2 күн бұрын
@ I solved it by selling the Mac and buying HP ..
@prasadkondapalli7871Ай бұрын
Thanks bro… It’s worked beautifully 🎉
@dianastryzhak63928 ай бұрын
Briliant! Simplified my life! 🎉
@jamilarahmanova72043 ай бұрын
Thanks a lot for explaining step by step
@brunogammaАй бұрын
Thanx, man!!! Really saved me!
@josepenaherrera13048 ай бұрын
This was amazing and really intuitive, thanks!
@ayodejiajayi451510 ай бұрын
Thank you so much. It just worked. I kept having issues when I changed my user name. Is "SA" a default?
@Codeandcozzy9 ай бұрын
thank you for the amazing video. i want to ask how could we delete ''azure sql edge" 10:00. i dowloaded it 2 time and now it take 4gb on my mac.
@ashikmia32126 ай бұрын
Impressive and helpful. i love it 🥰
@shahz26874 ай бұрын
Thank you! It was very helpful. But how are we meant to connect the SQL server on Azure after we have closed docker and Azure (e.g. when we restart or shut down our Mac and have to turn on Azure and docker again)? I keep getting an error like: 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: TCP Provider, error: 40 - Could not open a connection to SQL Server). It worked the first time I connected the server following your instructions. But how to connect it again after we have closed docker and Azure?
@izakdelacruz58733 ай бұрын
Have you figured this out?
@shahz26873 ай бұрын
@@izakdelacruz5873 still not yet
@abby_blair97883 ай бұрын
Have you tried rewriting the code in the terminal to make a new docker container?
@doehnerc39683 ай бұрын
Same here, and I tried to use a new user name and password following the policy but still can't connect to the sql
@gowthamraj79662 ай бұрын
in 12:57 the server is excited, and when i run it.. after few seconds, it is coming error.. do reply please!?
@tilakbhati98282 ай бұрын
could you find the exited error resolution ?
@wordonice44577 ай бұрын
Thanks for this. Works like a charm!
@kaverigadhe37066 ай бұрын
Hi thank you so much for this crisp and clear video. it was a great help for me Thanks again.
@senabakr5 ай бұрын
I have no restore option in my azure data studio, can you help me
@frochaol5 ай бұрын
thank you bro, this is a really helpful information !!!
@malarvaniv31095 ай бұрын
hey! My mac is 11.6 version ..It's not supporting ..Is there a docker that suits my Mac version?
@jagaes68 ай бұрын
Thank you so much for your video. I'm sorry for my question - I just literally have no idea - is SSMS also in Azure or I have to install something extra?
@DegsyboyGomes3 ай бұрын
i think this no longer connects after the latest mac os updates or the latest docker updates - i to can no longer connect via azure data studio - but i can connect via sqlcmd. I havent figured out how to fix this yet...
@abby_blair97883 ай бұрын
I just installed docker (intel core) and azure for the first time today but first I had to update my mac air, 13 inch, to the most recent sonoma 14.0. I was running on the 11.0.01 before that lol. After following the video everything is up and running. Maybe your terminal needs to be reset??
@rishukumar75865 ай бұрын
Mounting a volume does not work on Docker for Mac for this image
@Hudsonn867 ай бұрын
At the last step, I tried to connect to SQL Server on the Azure interface, and it said: "Login failed for user 'SA'" Can you plz help me out?
@JPrasca5 ай бұрын
x2
@user-fc3bs8et1uАй бұрын
Same Did you find any way
@RishikaReddy-y4o5 күн бұрын
how do we connect this SQL server to powerbi? i tried using server name as localhost, it sent me an error msg saying "server not found". Could you please help me with this
@sushritsaha52876 ай бұрын
It all WORKS fine except CLR based functionality. CLR-based functionality - whether it be the instance-level "CLR Integration" option (which enables custom / user-created assemblies); data types geometry, geography, and hierarchyid; built-in functions such as COMPRESS, DECOMPRESS, FORMAT, AT TIMEZONE; or a few other features - are not available in Azure SQL Edge. There is no way around this (at least not at this time). If any of this functionality is required, then using Azure SQL Edge as a platform is not an option. (Yeah, it kinda sucks, but that's how it goes.) P.S. The CLR-based data types and built-in functions are not controlled via sp_configure 'clr enabled'. If they are available on the platform, then they cannot be disabled (outside of enabling fiber-mode / lightweight pooling, which is not something anyone should do).
@KennieFIRE6 ай бұрын
Yup kinda sad
@Firas_Marabi4 ай бұрын
After I dad that , how we connect to visual studio and what is the connection string ?
@Leiferiksson954 ай бұрын
Thank you so much! It worked!! Thanks!
@suprayaskalyan90983 ай бұрын
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: TCP Provider, error: 40 - Could not open a connection to SQL Server) how to solve?
@tobycharles42772 ай бұрын
I have this same error. Were you able to resolve it?
@Shadow8-z6wАй бұрын
Before connecting in azure studio database, go to docker-->in containers--> run the sql container there's an action button to start -->then connect hope this helped.
@danyalghayas654918 күн бұрын
@@Shadow8-z6w I followed your foorsteps, but now I have this, how to fix this error? A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - Undefined error: 0)
@Shadow8-z6w17 күн бұрын
@ I don’t know how to fix that brother, maybe try re installing it.
@blancaying82094 ай бұрын
I absolutely followed everything you presented however I was lost at where you created a table. How could I create a table please?
@ofoegbujuliet81873 ай бұрын
Very helpful. Thanks
@mylawpoint72310 ай бұрын
Very crisp and clear. It worked for me. Though I got a dquote issue in the Terminal where the command had a password with @ symbol. Could you also put up a video on adding the AdventureWorks database on Mac's with M1/M2/M3 ? Thanks!
@abigail_nyathi9 ай бұрын
so we are to remove the @
@mylawpoint7239 ай бұрын
@@abigail_nyathi - if that was a question, then yes. It worked for me after I removed the @ from my password.
@exoticsnowman32008 ай бұрын
Tysm i can finally use it for school
@sreenivassremathtirumala89895 ай бұрын
Thanks quite clear.
@YouMustQuestionEverything9 ай бұрын
Upon reboot of MacOS Ventura, Docker starts up fine automatically but the container fails to start automatically. It has to be manually started up. Any help would be much appreciated. Thank you.
@giovannifontes87595 ай бұрын
Thank you, the video was very helpful
@lauramac.6 ай бұрын
This was perfect... Thank you! Is there a way to add an Express server instead of Developer using Docker?
@KylieDiLalla6 күн бұрын
When I go to Docker, Apple Chip is not an option and I have M4 on my MacBook. Apple Intel Chip was not compatible. How can I fix this?
@BrandonRubenGonzalezRamirez9 ай бұрын
thank you so much. It just worked 👍
@linhvuquach2 ай бұрын
it's helpful, thank you so much.
@sahilapte77358 ай бұрын
can we do the connection directly on vs code itself using the ms sql server connection
@RaghavVerma-nl1kk6 ай бұрын
Thanks alot bro it worked finally 😘😘😘😘😘😘😘😘😘😘😘😘😘😘😘😘😘😘😘😘😘😘😘
@MiloMontang29 күн бұрын
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - Undefined error: 0) what to do
@kamraannrajaani374210 күн бұрын
Same issue with me too
@HeinWaiHtet-s8p9 ай бұрын
Hello, I can't find restore option in my Azure Data Studio. could you guide me how to solve it.
@skullNSK2 ай бұрын
Very helpful, Thanks! Not showing import wizard when i right click on database name. What to do?
@richardayensu17117 ай бұрын
The version of my Mac is 11.6.8, but the docker takes version 12 or later. Is there a docker that suits my Mac version?
@jorgebotero72196 ай бұрын
Can SQL Oracle be installed in the same way for an M3?
@odunayofajuko66007 ай бұрын
Thank you so much, the video was very helpful.
@matthewkk508718 күн бұрын
I cant start it I have tried too many ways what should I do ?
@VuTien29078 ай бұрын
Thank you very much. Very helful video.
@rayadsakyar61222 ай бұрын
when i run "localhost" for server name in the Azure data studio, i get error? please how or where i can find the server name? im very new beginner
@44killua9 ай бұрын
hello there I accidentally used the SA username I can't open the server now, can you help me how to fix it? I want to changed the username but idk how and what's the code, thank you so much I really appreciate for your respond it would really help me!
@BadalSona5 ай бұрын
Hi how can we create container for oracle 19c same proceaa using docker container
@TaylorNewman-Farr2 ай бұрын
i keep getting quote> when running the image in the terminal. I copied and pasted the same text into my terminal and changed the password according to the sql server password requirements and it's not working. am i doing something wrong?
@ashwineekumarroutray140419 күн бұрын
is localhost same for everyone in server???
@marcoreyes11807 ай бұрын
I have a intel core i5 in my mac, after installed the image i try it to run but the run stop as soon is started. Is There a solution for that?
@egorkizim3683Ай бұрын
Could not load file or assembly 'System.Threading.ThreadPool, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. The system cannot find the file specified. Can someone help?
@amukherg8 ай бұрын
Thank you so much ! this really works
@sahildhola9337Ай бұрын
Hi im creating a web api i want to connect servers with my api but i don't konw to get servers name or something that help me to connect with SQL HELP ME PLEASE
@NischitSapkota9 ай бұрын
Hi, will the connection if my restart my device , and what should I do start the image running again if I reboot my device?
@sakshamrajput1410 ай бұрын
I had got a problem in installing MySQL at apply configuration my server is not starting please solve my problem (Windows)
@user-rv4rx4zm6l4 ай бұрын
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: TCP Provider, error: 40 - Could not open a connection to SQL Server)
@PoojaSingh-hf1ht3 ай бұрын
Same. what did you do then?
@chandanbhuyan140710 ай бұрын
Hello sir. Pls tell me which linux distribution u are using. While I am practicing I couldn't find out where problem
@YouMustQuestionEverything9 ай бұрын
He's using macos on an apple system.
@AliShah0752 ай бұрын
Thank you 😍
@joshuamanuelmadlangbayan54158 ай бұрын
how to fix the "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: TCP Provider, error: 40 - Could not open a connection to SQL Server)" when connecting to the azure data studio? please help
@vibhorsharma24367 ай бұрын
getting any solution, please let me know i m getting same
@adrianana5331Ай бұрын
How to persist data on this ? is it possible ?
@ashwineekumarroutray140419 күн бұрын
while new connection in azure studio app after giving username and password while clicking connect i am getting this error message"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: TCP Provider, error: 40 - Could not open a connection to SQL Server)"
@shubhamgarg50999 күн бұрын
did you resolve this ?
@shravankumar7961Ай бұрын
I did not changed the password in terminal and it shows Cannot connect to the database due to invalid OwnerUri (Parameter 'OwnerUri') how can i set the password
@Dorik8882 ай бұрын
Thank you so much!
@batboy09Ай бұрын
The container is exiting automatically after starting. Please help!!!
@camilacarnevale9889 ай бұрын
Hi! I get an error on my last step: 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: TCP Provider, error: 40 - Could not open a connection to SQL Server) any idea of how to fix it?
@shivamop56969 ай бұрын
Did it got fixed ? Cause I have the same issue
@NischitSapkota9 ай бұрын
I was having the same problem mam . I deleted Docker and Azure Data studio , rebooted the device and reinstalled the applications. It worked like a charm. Try reinstalling and rebooting , it will work.
@linhanhnguyen46899 ай бұрын
i have the same problem but i figured it out. It's because i set the password is 123, i see the "view detail" in container in docker and it said "password specified is too long". So i deleted that container and made a new one with the password that have letter in their. I MADE IT!! go see if you are having the same problem
@alejandrosanhueza65639 ай бұрын
The password must contain at least one uppercase letter and numbers, now works for me.
@farshaadmusic7 ай бұрын
thank you. you saved my life
@melon61463 ай бұрын
i press connect and the screen "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: TCP Provider, error: 40 - Could not open a connection to SQL Server)", how to fix?
@maybee3953 ай бұрын
hi, were you able to fix this ?? having the same problem
@melon61463 ай бұрын
@@maybee395 no, i cannot fix this
@maybee3953 ай бұрын
@@melon6146 oops! thanks
@melon61463 ай бұрын
@@maybee395 i fixed it, were you able to fix this? do you need my help?
@jithujohan6903 ай бұрын
@@melon6146 i need your help
@javieralejandroperalta1758Ай бұрын
Nice guide! Anybody have the permission denied problem? I've experiencing this problem lately. When the container starts or when I make an action in the database. I cant find the solution anywhere! I have an M3 Mac
@paramilyАй бұрын
I have the same error! It's because the password doesn't fit! Your password must have 1) Upper case + 2) Lower case + 3) Special character + 4) digits. It works perfectly after resetting the password. Give it a try!
@prasanthkumar591819 күн бұрын
@@paramilyIam still facing issue.Please tell me how to reset password
@diguvapilkar853123 күн бұрын
It says wrong instance or server name when i entered localhost
@q0000h520962096 ай бұрын
why using Azure instead of SQL server management studio
@amirkhanashvili7 ай бұрын
When I try to connect the SQL in Azure: I keep getting the error: 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: TCP Provider, error: 40 - Could not open a connection to SQL Server). Can you please help?
@SathishKnv-gd8bf6 ай бұрын
Same error for me as well
@lilrabbitcuz4 ай бұрын
Same
@haanshaamhaan4 ай бұрын
try setting a password that includes uppercase letters and numbers
@TuanNguyen-og1nz9 ай бұрын
How t create a backup file , please
@gagansingh348121 күн бұрын
Is this azure studio free or need to create AZURE ACCOUNT
@ayshaalthaf47552 ай бұрын
It worked but I when it’s not getting connected, Why ..? Please anyone help
@cyberSecurityWithChanura4 ай бұрын
thank good you save my life 👻👻👻
@tusharch0Ай бұрын
For those who facing issue 1. Use strong password as recommended 2. Install stable version of docker use 4.32.0 3. Thanks me 😊
@arturopadilla46196 ай бұрын
I can’t find the restore option can anyone help
@СергейКошельник-н9н6 ай бұрын
Thanks!
@ArchitStreams8 ай бұрын
I did all the steps, and when pressed `Connect`, it's loading infinitely