How To Install SQL Server on Mac M1 & M2 | Latest for 2022
ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2024
- How to Install SQL Server and SQL Server Management Studio on Your Mac with M1 & M2 Apple Chip. With IDE. Latest for 2022 (MacOS Monterey). Step by Step Guide.
Docker Run Command :
docker run -e "ACCEPT_EULA=1" -e "MSSQL_SA_PASSWORD={password}" -e "MSSQL_PID=Developer" -e "MSSQL_USER=SA" -p 1433:1433 -d --name=sql mcr.microsoft.com/azure-sql-edge
(Change the password inside the curly braces {} and don't include the curly braces when you run the command.)
Example :
docker run -e "ACCEPT_EULA=1" -e "MSSQL_SA_PASSWORD=Password123" -e "MSSQL_PID=Developer" -e "MSSQL_USER=SA" -p 1433:1433 -d --name=sql mcr.microsoft.com/azure-sql-edge
Keywords :
Install SQL server on mac
Install SQL Server Management Studio on mac
Install SSMS on mac
Install SQL server on mac m1 m2
Install SQL Server Management Studio on mac m1 m2
Install SSMS on mac m1 m2
Install SQL server on mac azure
Install SQL server on mac 2021
SQL server
#mac #macbook #sql #sqlserver
![Installing MySQL Database On MacOS [Apple Chip and Intel] | Install the Right Way Step By Step Guide](http://i.ytimg.com/vi/ODNSrWSq7tw/mqdefault.jpg)
![[DRIP] ‘Love, Maybe’ PREVIEW](http://i.ytimg.com/vi/U7hwHp95m1k/mqdefault.jpg)
Hi Dominic! I'm starting my Data Analyst bootcamp and with this video you helped me in my first challenge (install SQL on my Mac). I saw a lot of videos and read many forums where the solution passed by installing a virtual machine, which is paid. Hopefully I came to here! Thanks a lot !🙏
Hi Dominic - Great video and super useful - it helped me out setting sql up! Although for setting the SA_PASSWORD when connecting docker with azure..., please make a note for the future that the password must be at least 8 characters long and contain characters from three of the following four sets: Uppercase letters, Lowercase letters, Base 10 digits, and Symbols... I ran into this issue and I'm sure (based on the comments) that plenty of folks had the same problem too - I hope this helps - cheers
Glad it helped!
Hello I going through the same issue but since the password has been put already in the query and running where exactly should I change it for it to work in the data azure studio while making the connection. I keep getting errors with the initial password in the query. If someone can help please
Dude, you are a lifesaver thank you so much...
You too Dominic !
@@daisyzongo6978 Are you still having this trouble ?
@@eirikureiriksson5035 I have it, how to change the password ?
Thank you Dominic! One little pitfall I noticed is that when running the command line (provided in video description), I had to replace double quote to single quote to get it work, not sure why, but I think is worth sharing, might help some of you who's having trouble.
It wasn't working for me until I tried this - thank you!!
thank you sososo much!
Works for me too now. thanks
Thanks! Faced the same issue and resolved with ur comment!
Hi Dominic, great video. However on the final step I am getting following error on my mac:
TCP Provider, error 40 - could not open a connection to SQL server: Could not open a connection to SQL Server
Any help will be appreciated.
Did you find any solutions to this error?
and now, did someone find it?
@@grandelle219 well here's what worked for me: you just need to go to your Docker, open Containers tab, click on your sql container and run it (the status should change to "Running").
Hi, What solved my problem was creating a new password with at least 8 digits, including uppercase and lowercase letters, special characters, and numbers. The first password I created was not letting me connect to the server, then I redid the process and created a new password, and it connected to the Server. I hope this helps.
This worked for me, thank you @@gabrielmartins64646
Worked great, but one thing to add is that you have to go into advanced settings when starting the connections for the first time and set your port to 1433 which is what the terminal code that is programmed to grab. Hopefully that helps someone as it took me about 45 minutes of troubleshooting to realize.
Thanks, worked for me!
Thank you so much for sharing this!! This is so helpful! For anyone who has issue connecting, it might be the port bit. Go to advance settings > pop in 1433 in port.
Thank you for your well-detailed tutorial, but I am still having issues with connecting to the Azure Data Studio. I am getting the error "Login failed for user 'SA'." Please can you advise on what I am doing wrong?
It is frustrating. Great video though!
I have been battling with this for months. This video is a life saver. It made it so easy. Thank you so much.
For everyone with this error showing: " 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) ", you can fix it by deleting the container and creating another one by taking the exemple from the description of the video. This one worked for me..
thank you so much. God bless you immensely
not worked
where is the container and how to create another
??
@Carmensitaaa01
If deleting container and creating another one did not work for you, generate your password with numbers, uppercase letters, lowercase letters and symbols. This worked for me.
Thank you so much Dominic.. I am from finance background no knowledge on computers.. but wanted to learn SQL.. this video helped me to install the SQL with ease.. thank you so much.. wish you more success..
I'm on the same boat as an Accountant, trying to install and learn SQL and other data bases to add to my resume. 😊
Hi Dominic- please I was stuck at the place where you said I should copy the code and run it in the terminal. Please I don't have a terminal on my laptop as I am new in this. What terminal do you suggest I download?
I tried exactly what others stated in the comments about the password requirements, but when I changed the password inside the terminal, I'm getting "zsh: event not found: 0". When I used your full command without changing the password, I had no issues until creating the connection and I'm getting a connection error that says " 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: Could not open a connection to SQL Server)".... Any advice would be greatly appreciated! I'm a little frustrated at this point lol
lol im having the same issue right now
@@ryang9363 have you been able to resolve? having same issue
I have the same issue. Have you find a solution ?
Please do share if you find the solution to it, im struggling w the same
hey,, @kaylamichelmorris1457 @ryang9363 @izufri8694 I solved the issue, there's this thing called "trust server certificate" change it to "true". if its not anywhere in the connection details screen, click "advanced..." in the bottom right, you may find it there
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: Could not open a connection to SQL Server), why ?
Same here. Did you get it figured out? Please assist if you can :)
Same problem is occurring with me
Someone please help with this
Please provide solutions
Please provide with solutions if you have any
Hi Dominic, I followed all the steps as it is but when I am adding a connection, I am running into an 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: Could not open a connection to SQL Server)
Please help me. How can I connect with you?
I also had this issue and don't know how to fix it😭
SAME!!! definitely something going on here...
I am also facing the same issue. Please update here if you find any solution for this issue.
@@AruLcommentsOMG I'm here combing the comments for the same issue! WHYYY 🫠
Hi All, @SimplyBreana. I found the solution you need to remove the Azure from the docker and need to re-install (the same steps) once it is done. At the time you need to modify the password through terminal code use password like 'Password12345' or some password with long char and numeric combination. This will work for sure. Let me know if this works.
Please help!!!! getting error on the 9:21
Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=1; handshake=14999;
are you solved this problem
Thank you so much. Other guides doesn't work. I tried to install for hours until I found you!
I spent a lot of days to find a effective guide. I finally found! Thank you so much!!!
Hi! I’m having problems at the end, when i have to connect Azura to a server. It says: TCP Provider, error: 40 - Could not open a connection to SQL Server: Could not open a connection to SQL Server.
Can you help me? Thanks
Did you figure it out? I'm having the same issue.Thanks
Not sure if this may be seen but I'm getting an error that keep saying 'Failed to login user'. I followed all the steps to a tee, anybody have any recommendations as to why this could happen? Any helps is super appreciated!
I was facing some issues with getting docker images running with Mac M2. This video really helped. Thank you!!
Glad it helped!
Sir in the last stage when else create connection it shows instance specific error occurred while establishing a connection to SQL server . The network not found accessible. Verity instance name correct and configure to allow Remote connections provider : TCP
Same, How did you solve this?
I have a 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: 35 - An internal exception was caught)
Did you find any solutions?
Hello, Dominic. Thanks for your tutorial its great but I have problem. I have CONNECTION ERROR. Need this option: enable trust certificate I press ENABLE TRUST CERTIFICATE and I get Login failed for user 'SA'. Please help. George
The simplest way to install and very straightforward. Thank you!!!
Thank you so much! The information is very detailed and has been incredibly helpful. I encountered an issue with the "docker engine stopped" during the process, only to realize later that I had not yet upgraded my Mac. After completing the upgrade, all the other processes ran smoothly.
Well explained, thanks. Regarding the central memory of your Mac (Mini or MacBook or iMac or...). Will 16 GB central memory be sufficient for using Docker and Azure Data Studio ?
Hi Dominic. Thanks for the video. It was truly a lifesaver. I do have a challenge though. I have been running my scripts for days without issues until the need arose to restart my Mac because it froze. Since then, I have been unable to create a connection from azure data studio. Any pointers?
Hi Domnic - im stuck at the last step in azure data studio. please suggest what to select in Data base, trust server certificate, server group & encrypt. i have tried certified as true but it gives error. Requesting your help on this.
same to me..
@@akmalabadillah3872 I'm having the same problem
Could you help me please?
(provider: TCP Provider, error: 40 - Could not open a connection to SQL Server: Could not open a connection to SQL Server)
hi, do you find the solution of this problem? i have the same
Thanks for the tutorial!! so much helpful!, so I should use this command every time that I run the images?
Hi Wendi, so once you have setup things as instructed in the video, the next time you want to use it you just have to open the docker application on your mac and click the play button next to the container holding your sql image. Once you see the docker container is running you can connect Azure Studio to the image in the same way as in the video. Sometimes azure data studio will remember that you have previously connected to this imaged and will show you the old connection and you just have to restart the connection by right clicking and connecting. Cheers !
@@datawithdominic awesome!! Thanks for the instruction :)
OMG this video helps a lot!!! I have M2 Macbook and was giving me quite a tough time at the Azure connection step. If anyone ever encounter some connection error 35 like I do, please try put "localhost, 1433" and try again. If it kept saying that connection fail to login "username" please try remove the container and run command in terminal again removing all the " quotation marks. This whole set up process took me 5 hours today..... so much research.
remove container from where and how? got error 35
Thanks a lot, I was just about to give up, but I found your comment. These type of comments help a lot, and thanks for commenting it and helping others to solve their errors too.
remove the container from docker, just go to docker, and click on containers, if status column is not running, remove it and basically do what the comment says@@pralhadgautam
this solved it for me, thank you so much!
Fantastic comment - this also fixed my issue
really good video and good comments too. I might add that if the azure cannot connect and throws 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) "---- than you probably didn't start the docker. go to docker then to the containers tab and on the proper container (for me it is called sql) just press start. and now try to connect again. everything should be fine! A lot of the problems that someone could face during the procedure are already solved down on the comments' session !
I am currently having this problem but also I don't know what to put as the username... I am a bit confused
@@cathyordinola5816 you don’t need to change the username. Just let it as it is . Just put a strong password cause otherwise it might not work(did not have that issue personally but some others do refer to this problem).
"A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught)" I get this error on the last step. So close yet so far
Fixed. Works! Thank you!
can you say how you fixed it please
@@noyes6007 Yes please
Thanks! Helped a lot! Trying to learn SQL and the tutorials didnt talk about how to make things work for Apple Silicon!
Hi Dominic, why does my azure connection page look different from yours? What should I input into the fields? Instead of username and password it has account, database, and server group.
Hi,
thank you so much for this video. I have only one question left: Is ist possible to run a second, and named instance?
So one sql instance with only the "servername" and one with "servername\myinstance"?
Thank you! It's helpful. The solution for the following error is to create a password at least 8 digits. '"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: Could not open a connection to SQL Server)"
Hey, I'm having that issue right now at the moment, I made my password like 12 characters long but I still get the same error.
Amazing walkthrough bro loved the way you explain each step! WORKED FOR ME!
Can't connect to the server on Azure due to connection 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). Is there a way to solve this? Many thanks!
i can't connect it. it says"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)"
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: CSP Provider, error: 40 - Could not open a connection to SQL Server)
I have such a connection problem in azure data
Hi Dominic, when I try to create a connection with sql in azure data studio, it represents the error of "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: Could not open a connection to SQL Server)". How could I solve it, could you please give me some advice?
same problem
Excellent video! Been struggling to get SQL loaded onto my M1 for a long long time. Until now :)
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)
Unable to connect to localhost. Getting 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)
Thank you so much for making this video dear! Every step is very clear and works smoothly! God bless you!
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: Could not open a connection to SQL Server)
I get that exact error. No idea how to resolve this issue. Any ideas out there?
@@charlescartwright3470 Got the same issue. Able to fix by deleting the existing sql image. Re-run the last command with changes on the current password to something stronger - "the password must be at least 8 characters long and contain characters from three of the following four sets: Uppercase letters, Lowercase letters, Base 10 digits, and Symbols.."
@@jusnainimuslim1895 thaks a lot ! That's exactly what happen to me and the way to solved it. Change for a strongest pass and Voilà
@@jusnainimuslim1895 Thank you!!! That really helps!
@@jusnainimuslim1895 hi could you please help me out Hi I have been trying to download SQL on my Mac OS and I have tried with various means and still can't get through it. Everything was going really fine when I downloaded Azure there as an error which came on the screen stating "A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught)" I would really request you to kindly help me out as I need to download all my setups asap. Thank You.
Hi Dominic, thank you for the video. I have an issue with my Azure Data Studio. Your screen for manage localhost server shows the 'Restore' button in the GUI as well as in the drop down but where as mine does not. How to resolve this? please help!
Hi I have been trying to download SQL on my Mac OS and your has really helped me out but likewise I have tried with various means and still can't get through it. Everything was going really fine when I downloaded Azure there as an error which came on the screen stating "A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught)" I would really request you to kindly help me out as I need to download all my setups asap. Thank You.
I got the same just now. What did you do? A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - 136)
please write to me when you find out
I am also facing the same issue. If someone can help with the solution.
@@pallavisinha7338 i am also facing same issue if you find the solution please tell me
@@pallavisinha7338 ok i got the solution you just have to install rosetta 2 on your macbook then try to reconnecting again after quitting the azure data app that is all your connection will be established successfully.
It really worked for me after I look and try some tutorials, yours is the one that worked. Owe you a lot.
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - 35180026)... can you please help me
same problem...did you get it sorted and , if so, how? Ta.
bro help me
@@nickwhite5090 do you know how to solve it
Thank you Dominic! your vid helped me out so much, I had to sub.
In 9:23 after clicking Connect, A tab appeared with "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: Could not open a connection to SQL Server)"
same
"I got the same error, were you able to fix it?"
I was not able to fix it. Was waiting for a response. I guess I will just reformat my whole laptop and start from beginning and find another way
@@anthonettemaemagalso8777 still wont work
@@anthonettemaemagalso8777 THANKS! 🙂
Hi, thank you for this video, do you know if it's possible to access a database set up in SQL Server on Mac M1 (as you described) from Visual Studio for mac?
Would also like to know this.
I want to thank you about excellent video. I got very much help when I configured MS SQL Server and Azure data Studio first time into M1 MacBook. Good Work!
Hi Dominic, I am on the last step and it does't work for me. When I am trying tio connect to Azure, it shows me a 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: Could not open a connection to SQL Server)" I really need your help 😞😞😞
Me too... did you fix it?
@@rachelnavarro2897 me too! any luck??
Me too!! anyone manage to solve this?
Thanks Dominic, clear and straightforward explanation.
Hi, I've followed each of the steps as shown and was able to execute all of them till the second last one. In the last step, while trying to establishing connection, I'm getting a connection error😥. Any idea anyone why it can be and how can I sort it?
Thanks!
same🥲
@@nandinisaudari8790 may be someone from the tread can help us!
me too
I’ts perfect. I have only one problem, every time I turn on my pc I say the connection is off. I try (from azure data studio) to log in but it return error. What can I do? Thanks
Stop the docker image and restart it
Thank you Dominic. This was super helpful. Fantastic job on breaking down the installation of sql server on mac !!
Hi Dominic, thanks for this in details video. However I got stuck at the final stage, Step 6. I am getting a connection error. Not sure how to resolve it. Which says "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: Could not open a connection to SQL Server)"
Any idea how to resolve this?
I am also having this issue!
I resolved this issue by following the comment posted by @Juan Moctezuma " password must be at least 8 characters long and contain characters from three of the following four sets: Uppercase letters, Lowercase letters, Base 10 digits, and Symbols "
@@aravindmyaka Thanks for your reply but it did not resolve the issue. The password has been put already in the query and running where exactly should I change it for it to work in the data azure studio while making the connection? I put up the password while creating a new connection. Now I am getting "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)" error. Should I delete the Sql container in docker and restart the process?
@@shashankkharat1040 i had the same issue after changing the PW. Then i deleted the container and created a container with same user name "SA". now it is working
@@m.velamjegan1625 how to delete the container?
For those having user name error please be sure you also delete "{}" before adding your new password other way add it while connecting
ahh thank you so much that fixed my problem!
thanks dear, very helpful cheers..
i have a question plzm
How to connect the sql-server on Rider for dotnet mvc web devlopment?
something Migrations and connectionString on the Jason file?
there are 2 problems on Azure sql Edge server: 1. Microsoft said they would not support the ARM any more, it means they would not support Azure SQL edge. 2. The azure sql edge has 1TB database size limitation. I just got the issue.
Thanks, I was making mistakes in m1/M2 chips because I am a new macbook user, this video was very useful.
For anyone who is having issue because of the wrong password format, you can remove the container using "docker rm containerid" and then run the command again with correct password format i.e., uppercase, lowercase, special character and minimum 8 in length. Your container will run again and you are good to establish the connection in the azure data studio with the new password. Hope this helps if someone facing this issue.
I use macbook air m2, I changed password and i could connect, but when i turn off the app , I lost the connection again and had to do the above steps again, anyone have the same problem?
The correct password format helped me. Thanks!
@@DungVu-yt4fz having the same issue. I use mcbook pro m1. did you find any solution ?
I have the same problem on m1pro@@DungVu-yt4fz
@@joemamaa420hi I have the same issue did u find a solution
..worked perfectly..I just switched to Mac M2 and this video totally helped...I'm very grateful.
Just wanted to thank you for the video. Finally after trying so long, I have been able to install it. Kudos for the work.
Hi buddy! thanks a millions! , if I install this Azure Studio no need to install SQL 2019 or 2022 right? I was trying from 2 days without success in my M2
That’s right, just azure studio and docker with sql container as shown in the video
Subrat sir i want to talk to you...i have mac m2 and not able to connect ....can you give me your Instagram handle please
@@datawithdominic hello can you help me as the SA in logging in doesnt work :(
@@SDpictures i also have the M2 what type of error you got?
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught) :- getting this error. Can anyone help plz?
If facing any issue just delete the docker container and then the image and follow all the steps again, also keeping the password given in the example is the best...
Hi Dominic, I used the same Docker Run Command link you posted without changing the password. im beginning to get an error whenever i tried log in to the 'sa' login .. Please can you assist me getting this error fix
same here. have you found a solution to this?
Yes same
@@wissaagunoy6307 same any update
Thank you soooooooo much! So simple, straightforward forward AND works smoothly!👍
i continue to experience errors...are you willing to share how you navigated?
Thanks very much for the video
but I get this error when I try to connect to the server (Login failed for user 'SA'.)
I am having this same issue.
Thanks for making this video. It really helped me to run SQL Server on my Mac M1 Air.
hello please Im stuck at the. create a connection area. whenever I try setting it this is the outcome from the terminal docker: Error response from daemon: Conflict. The container name "/sql" is already in use by container "a8e144d29a02c0de9cbd9e227f6329c39b83fad6e6b751e7110f09ebc590ac1e". You have to remove (or rename) that container to be able to reuse that name.
and whenever I try to connect form the application this is the outcome Microsoft.Data.SqlClient.SqlException (0x80131904): Login failed for user 'SA'.
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) I know this is a lot but can you please help me
absolutely loved this tutorial, thank you. Do you also have tutorials on jmeter?
Not yet!
There are a few missing parts here. How do you connect to the localhost if it does not exist? do you have to deploy a server first? Please respond to my answer.
None of the tutorial found on google work. Primarily because of format issues. Yours, however, worked for me! Thank you Indian brother!
Thank you! I have a problem that I can not can next to localhost again. The issue: A network-related or instance-specific error occurred while establishing a connection to SQL Server. error:40. Please help me 🙏🙏🙏🙏🙏🙏
same~
for creating a connection i have this error coming
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: Could not open a connection to SQL Server)
I'm struggling on the last step, what username and password are we suppose to be using? I'm using the same ones from the query but it's not connecting.
Thanks for the process, How can we upload bulk data Excel file into SQL server in mac, where the normal options are not shown here.
Hi Dominic, was struggling to install from past few weeks. This video really help me. Initial had an issue with connection, but was able to solve.
If we get a connection issue, mostly it will be of password length. When we set password, it should be of 8 characters long, should contain 1 upper case, 1 special character and combination of alphabets and numbers.
Also when keying in the server name, we need to key in as
localhost,1433
Hope this helps others in solving the issue.
I am still having this same issue. I tried exactly what you said but when I changed the password inside the terminal, I'm getting "zsh: event not found: 0". When I used his full command without changing the password, I had no issues until creating the connection and getting the connection issue that says " 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: Could not open a connection to SQL Server)".... Any advice would be greatly appreciated! I'm a little frustrated at this point lol
You are life saver. Thanks a lot.
This may be a silly question, but how do you reconnect to the server? Everything in the video worked for me, but then when I quit Azure and docker and tried to re-connect to the server, I get the below 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: Could not open a connection to SQL Server)
@@chrisjbeech1994 Everytime you quit docker, you need to again start the docker and start the sql container and then open the azure data studio and connect to your local db.
@@kaylamorris128hi I was in this same boat I just resolved mine myself I forgot to remove the bracket when typing my password can you check yours? Hope this helps:)
You're my hero!!!! thank you for a through and easy to follow video!!
Thank you so much!! The video was really helpful!
I have a problem: 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: Could not open a connection to SQL Server). How can I fix it, please!
Use a stronger password when you enter that command in terminal, uppercase, lowercase, numerical and more than or equal to 8 characters, then itll work.
i had some technical difficulties bc i am not that tech savvy lol but it worked!! thank you!
Again an error is coming
Below is the description
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)
@@kevenCodes Yes
can you help me with that
pls
Same problem
Hi! I'm having trouble locating the same image you selected Azure SQL Edge. Is there another image I can use?
Hi Dominic, I'm getting an error saying '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 next?
i watch so many videos and i can't install them but your video clip made it possible for me to install it. thanks for making such a useful video!
I got
Connection error
login failed for user 'SA'
anyone knows how to solve it
thanks in advance
do you know how to fix that error? I got the same one
Is it possible to install SSMS on Mac? Thanks a lot for the video.
hello, can anyone help me out i'm getting this error in azure data studio
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: 35 - An internal exception was caught)
same problem here did you find any solution
found the solution just go to docker and start the image and it will work again
@@ChandanKumar-mx7jx i figured it out thanks for reply anyways 👍
@@ChandanKumar-mx7jx how to start the image??
@@dinieazman9695 on right corner pause like button is made click it and it will start
Thank you so much!!!!!! I've been having problem connecting to the sql server and this solved it.
please how exactly did you solve the issue, I am facing the same issue
this videos was recommended by copilot to me to install sql server
Thank you!!! I was stuck all day yesterday trying to figure this out, this is incredibly helpful!!
can you help me with the last step for some reason it won't let me connect to the server
Yess same
@@Galacticgospel. same. I think my problem is that i did change the ID from SA but then I noticed that he has the same SA in 2 different locations so now I may need to re-do that section again but not sure how that can be done, if i just need to copy it again and this time not changing anything only the password that i created. Were you able to work on your error?
@@rachelnavarro2897 not really but i did find a page that lets me practice sql for free
@@Galacticgospel. ah que bien. me la pasas please? estoy aquí tratando de arreglar mi issue aun. Creo q es el ID q yo lo cambie a otro pero veo q cuando lo copy and paste solo cambie en un lado y en otro se quedo como SA aun.
This video is easy and straightforward, thanks a lot man.
Hi Dominic
Great Video First of all. Very easy to follow. I think I made a mistake somewhere but still getting an 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: 35 - An internal exception was caught)" not sure where did I go wrong ??
Just delete the container and image and repeat the process and use the password in the example it works just fine
Hello Dominic, how can I create a connection string ? it's very useful video, but if I wanna to create a connection string, how can I make it ?