How To Install SQL Server on Mac (M1 | M2 | M3)

[@trickster5855]

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 !

[@mahmoudblackjack]

“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 🇵🇸❤”

[@TheViitinhow]

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!

[@poojababerwal7938]

Ohhh god finally somebody shared something efficient. Thankyou for the clear explanation. It worked!

[@abijaffa5430]

Thanks for sharing this! The instructions are crystal clear. It worked the first time around -you gained a new subscriber!

[@hariparajuli]

Awesome. Finally found a solution through your video after many trials and errors. Thanks.

[@amy_mishra]

Finally got the SQL working on Mac. Thanks a lot :)

[@navaneethkhussanagari3953]

howww bro plz help me

[@emerson3799]

Holy Moly!! How happy I am to have found your tutorial video. You're a life saver! 👍👍

[@rawiaabuamro9254]

This appeared to me (: 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)

[@nicolledelgado331]

Same issue here, did you find any solution?

[@sidibeobed4064]

Hi! Thank you for your video but I still have this issue for my first connexion: 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)

[@kaaviyau]

Your password doesn't meet SQL standards. 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.

[@chriz_SE]

Long live to you my friend, Genius! Thank you so much for the video, had no idea from where to start !

[@TamNell]

My godness!! Thankyou sooo sooo much!!!! Finally after few others videos on youtube didnt work, then I found yours and it ACTUALLY WORK!

[@snewm-xh1cx]

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!!)

[@pravallikamadabhattula8522]

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.

[@gowtham3182]

It works

[@SaurabhGupta-wh5ww]

thanks

[@joel_himself]

omg life saver

[@mellowmeow9634]

thank you

[@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!

[@ashwineekumarroutray1404]

same here

[@true.living5569]

did you solve this error?

[@May-lu8jt]

@ I solved it by selling the Mac and buying HP ..

[@chinedunwasolu4913]

@@May-lu8jt LOL

[@engaudy]

Great asset man! Thanks for explaining in a good neat approach

[@RishikaReddy-y4o]

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

[@rabiiaceylan]

i'm trying to make this happen for days.. thanks a lot

[@becauseiwanttoanime9541]

Thank you very much, easy to understand and worked perfectly!

[@vicheka9209]

it's work for my m1 thank you for sharing and please keep sharing for more

[@nimashafernando2778]

Thank you so much .This is such a life saver .

[@dianastryzhak6392]

Briliant! Simplified my life! 🎉

[@AygerimAsantur]

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?

[@himanshurathi1242]

same here!

[@CMG5817]

same here...

[@jumkye]

Same here

[@maybee395]

has anyone figured out how to get around this ?

[@AygerimAsantur]

nah, I even quit learning data analytics-not because of this, but still, why is it so difficult

[@josepenaherrera1304]

This was amazing and really intuitive, thanks!

[@kaverigadhe3706]

Hi thank you so much for this crisp and clear video. it was a great help for me Thanks again.

[@AmanVerma-dy6dn]

How to fix this 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)

[@SonTa-Telamon]

same omg

[@kaaviyau]

Your password doesn't meet SQL standards. 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.

[@SonTa-Telamon]

@@kaaviyau tks

[@kaaviyau]

@@SonTa-Telamon np ^_^

[@gowthamraj7966]

in 12:57 the server is excited, and when i run it.. after few seconds, it is coming error.. do reply please!?

[@tilakbhati9828]

could you find the exited error resolution ?

[@wordonice4457]

Thanks for this. Works like a charm!

[@jamilarahmanova7204]

Thanks a lot for explaining step by step

[@brunogamma]

Thanx, man!!! Really saved me!

[@prasadkondapalli7871]

Thanks bro… It’s worked beautifully 🎉

[@ashikmia3212]

Impressive and helpful. i love it 🥰

[@suprayaskalyan9098]

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?

[@tobycharles4277]

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.

[@danyalghayas6549]

@@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-z6w]

@ I don’t know how to fix that brother, maybe try re installing it.

[@SonTa-Telamon]

@@danyalghayas6549did you re-connect it?

[@frochaol]

thank you bro, this is a really helpful information !!!

[@DegsyboyGomes]

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_blair9788]

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??

[@Hudsonn86]

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?

[@JPrasca]

x2

[@user-fc3bs8et1u]

Same Did you find any way

[@Codeandcozzy]

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.

[@rishukumar7586]

Mounting a volume does not work on Docker for Mac for this image

[@daithaolung298]

The server was not found or not accessible so it cannot be connected somebody assist me with this

[@senabakr]

I have no restore option in my azure data studio, can you help me

[@MiloMontang]

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

[@kamraannrajaani3742]

Same issue with me too

[@mylawpoint723]

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_nyathi]

so we are to remove the @

[@mylawpoint723]

@@abigail_nyathi - if that was a question, then yes. It worked for me after I removed the @ from my password.

[@malarvaniv3109]

hey! My mac is 11.6 version ..It's not supporting ..Is there a docker that suits my Mac version?

[@ayodejiajayi4515]

Thank you so much. It just worked. I kept having issues when I changed my user name. Is "SA" a default?

[@Leiferiksson95]

Thank you so much! It worked!! Thanks!

[@blancaying8209]

I absolutely followed everything you presented however I was lost at where you created a table. How could I create a table please?

[@YouMustQuestionEverything]

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.

[@sahilapte7735]

can we do the connection directly on vs code itself using the ms sql server connection

[@Firas_Marabi]

After I dad that , how we connect to visual studio and what is the connection string ?

[@HeinWaiHtet-s8p]

Hello, I can't find restore option in my Azure Data Studio. could you guide me how to solve it.

[@ofoegbujuliet8187]

Very helpful. Thanks

[@odunayofajuko6600]

Thank you so much, the video was very helpful.

[@giovannifontes8759]

Thank you, the video was very helpful

[@rayadsakyar6122]

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

[@skullNSK]

Very helpful, Thanks! Not showing import wizard when i right click on database name. What to do?

[@shahz2687]

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?

[@izakdelacruz5873]

Have you figured this out?

[@shahz2687]

@@izakdelacruz5873 still not yet

[@abby_blair9788]

Have you tried rewriting the code in the terminal to make a new docker container?

[@doehnerc3968]

Same here, and I tried to use a new user name and password following the policy but still can't connect to the sql

[@lauramac.]

This was perfect... Thank you! Is there a way to add an Express server instead of Developer using Docker?

[@ashwineekumarroutray1404]

is localhost same for everyone in server???

[@matthewkk5087]

I cant start it I have tried too many ways what should I do ?

[@jagaes6]

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?

[@richardayensu1711]

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?

[@TaylorNewman-Farr]

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?

[@jorgebotero7219]

Can SQL Oracle be installed in the same way for an M3?

[@sreenivassremathtirumala8989]

Thanks quite clear.

[@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

[@batboy09]

The container is exiting automatically after starting. Please help!!!

[@ashwineekumarroutray1404]

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)"

[@shubhamgarg5099]

did you resolve this ?

[@chandanbhuyan1407]

Hello sir. Pls tell me which linux distribution u are using. While I am practicing I couldn't find out where problem

[@YouMustQuestionEverything]

He's using macos on an apple system.

[@melon6146]

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?

[@maybee395]

hi, were you able to fix this ?? having the same problem

[@melon6146]

@@maybee395 no, i cannot fix this

[@maybee395]

@@melon6146 oops! thanks

[@melon6146]

@@maybee395 i fixed it, were you able to fix this? do you need my help?

[@jithujohan690]

@@melon6146 i need your help

[@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?

[@linhvuquach]

it's helpful, thank you so much.

[@joshuamanuelmadlangbayan5415]

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

[@vibhorsharma2436]

getting any solution, please let me know i m getting same

[@BadalSona]

Hi how can we create container for oracle 19c same proceaa using docker container

[@VuTien2907]

Thank you very much. Very helful video.

[@amukherg]

Thank you so much ! this really works

[@exoticsnowman3200]

Tysm i can finally use it for school

[@BrandonRubenGonzalezRamirez]

thank you so much. It just worked 👍

[@camilacarnevale988]

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?

[@shivamop5696]

Did it got fixed ? Cause I have the same issue

[@NischitSapkota]

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.

[@linhanhnguyen4689]

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

[@alejandrosanhueza6563]

The password must contain at least one uppercase letter and numbers, now works for me.

[@marcoreyes1180]

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?

[@adrianana5331]

How to persist data on this ? is it possible ?

[@RaghavVerma-nl1kk]

Thanks alot bro it worked finally 😘😘😘😘😘😘😘😘😘😘😘😘😘😘😘😘😘😘😘😘😘😘😘

[@user-rv4rx4zm6l]

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-hf1ht]

Same. what did you do then?

[@sakshamrajput14]

I had got a problem in installing MySQL at apply configuration my server is not starting please solve my problem (Windows)

[@NischitSapkota]

Hi, will the connection if my restart my device , and what should I do start the image running again if I reboot my device?

[@diguvapilkar8531]

It says wrong instance or server name when i entered localhost

[@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

[@farshaadmusic]

thank you. you saved my life

[@rawiaabuamro9254]

plz i need solution to "connection error".

[@sushritsaha5287]

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).

[@KennieFIRE]

Yup kinda sad

[@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!

[@prasanthkumar5918]

@@paramilyIam still facing issue.Please tell me how to reset password

[@q0000h52096209]

why using Azure instead of SQL server management studio

[@Dorik888]

Thank you so much!

[@AliShah075]

Thank you 😍

[@TuanNguyen-og1nz]

How t create a backup file , please

[@ayshaalthaf4755]

It worked but I when it’s not getting connected, Why ..? Please anyone help

[@amirkhanashvili]

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-gd8bf]

Same error for me as well

[@lilrabbitcuz]

Same

[@haanshaamhaan]

try setting a password that includes uppercase letters and numbers

[@arturopadilla4619]

I can’t find the restore option can anyone help

[@gagansingh3481]

Is this azure studio free or need to create AZURE ACCOUNT

[@Kalabaidya]

Docker run command not working

[@sumitaneja4362]

Perfect..!!

[@СергейКошельник-н9н]

Thanks!