Oh. My. Gosh. Thank you!!! I have been trying to set this up all. day. I have literally spent HOURS reading forums and watching videos on how to do this, but the IP address info was THE missing piece. Thanks a MILLION!
I'm so thankful for this video !! My teacher didn't help me, I'm behind on so many PowerBI lessons just because I couldn't run Microsoft SQL on my Mac and I grew very frustrated and sad. Knowledge is power and your work is amazing, I'm deeply grateful. I really hope you're aware of your impact and somehow there's a way we can repay all the good back. Thank you, thank you, thank you!
I just set this up on my MacBook Air M2 and it works great, super excited! Docker now has the Rosetta setting in 'General' and everything worked perfectly. Also I'm running Parallels 18 with Windows 11 and it worked great. Thank you so much for this tutorial super happy!
Ca I ask how did you installed SQL in your Parallels Windows VM, I have tried many installers and version with my M2 and none success. Thanks ahead for your advice!
When I connect visual studio code to sql server I get the error "the type initializer for microsoft.data.sqlclient.tdsparser threw an exception" can you help me?
@LearningandTechnology Hi Frank, I have downloaded the docker sor apple silicon chip and I have x86 running in parallels but the option to enable it on docker does not appear for me. Is there something I can do to solve this? I am using a MacBook with an M1 chip. Thanks
thanks for sharing this video, very grateful. one more question, do you know how to insert the data form Excel in to the database in Microsoft SQL. what is the right format for the file path ? thank. you so much.
You beautiful man, I'm starting a college course in SQL in which I need to use SSMS and as a complete noob I was able to follow these steps and get it working on Parallels on my M3 mac. Thank you sir :)
Of course my pleasure Frank! I watched tons of them but got errors with Macbook Air M2, 2022. Finally found your video and works perfectly! Thank you again Sir! @@LearningandTechnology
Thanks is much for your help on this! Lifesaver! When I shutdown Docker Mac or Windows 11 on Parallels, why does the SQL container go away afterwards? I have to go back to your link recopy the code into terminal and run the whole process again
I have a question. The Windows 11 that we install inside parallel is ARM version. But SQL Server Management Studio does not come with Arm version, how did you install SQL Server Management Studio inside windows which is ARM Version?
That is an issue. You need to run the container for SQL. For a lot of applications, we will run the databases in a Cloud service rather than local - or even different databases.
Great video! How can we set this up as a local host instead of using the IP? I find when I switch networks I am having to switch some settings to keep the connections going.
@@LearningandTechnology Your video along with "How to Restore a SQL Server Database on macOS Using Docker by Chritian Hur" really saved me a huge amount! thank you so much. If anyone is looking to load the AdventureWorks.bak file onto docker and use it via parallels on Mac please follow this.
Hi! Sorry I'm very new in all about the data analytics but I just wanted to know if a MacBook with this specifications would be enough to use the sql server, photon, R, Power bi and Microsoft access --> Apple M3 chip with 8-core CPU, 10-core GPU, 16-core Neural Engine 16GB unified memory 512GB SSD storage
That is a powerful system and excellent for Data Analysis. The tools you need are often available through Cloud Services as well. So through a combination of Virtual Machines or Cloud Services - you would be able to do the work. I have videos on these topics as well. It’s a little bit of a learning curve - but Macs are great systems for Data Analysis
@@LearningandTechnology Thank you so much! I've always been an apple client so I'll really want to keep it like that while using that software, thank you so much
Hey there! I ran into a hurdle immediately. The Rosetta option isn't there. I have a macbook pro m1 pro...not sure that excludes me from being able to do this? I downloaded the current docker desktop for apple silicon just a week ago, and it doesn't give me the Rosetta option. Any help is appreciated. Thanks and great video! Generally quick and you gave a.lot of information.
Thanks Frank! Does this mean that the database we create is housed on our mac computers and not on the azure cloud services? What about backups or security with what we create? Thanks!
Yes indeed! The Database is on the Mac and local. So you need to handle admin tasks such as back-up, access, high availability and such. For this reason, I do try to use Cloud Services - bit this is a good option for testing and learning or in cases where the Cloud is not an option.
Hello. Thank you for this video. Please let me know if you can help me troubleshoot something: When I run the "docker run -e.." command in the terminal it just hangs. I've tried several times and waited several hours. It hangs and no new Containers ever appear in the Containers tab in Docker.
I'm having problem with terminal, after pasting address from site shared by you, there password command pops up which is not coming in your case, not able to proceed
Hi Frank. When I try to connect to Docker contained SQL Server, I have a error message: "Cannot connect to (IP Address) Additional Information The type initializer for 'Microsoft.Data.SqlClient.TdsParser' threw an exception (Microsoft.Data.SqlClient) The type initializer for 'Microsoft.Data.SqlClient.SNILoadHandle' threw an exception (Microsoft.Data.SqlClient) Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x86.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) What can I've missed?
Sa is the default Admin account for SQL. You can see the script in the video and might need to make any small changes if you wanted to use something else. The login error is probably the password - not the username.
@@hg-oz5ui I'm using a Mac Mini M1 with 16GB RAM and am happy with it. I'm not running any massive databases or processes. Jiatnusingnit for learning and teaching.
@@zerut7264 correct - you can not install SQL on ARM (M1/2/3/4) architecture. Parallels on a Mac has to run ARM. That's also why you can't install Windows Server.
Hi! I followed all the steps but when connecting to the database it tells me "An existing connection was forcibly closed by the remote host (OS error 10054)" Did I miss something?
Thank you so much! I have additional questions, could you help me please? Can I run Visual Studio via Docker on M2? Can I run SSMS also via Docker? Thanks!
Yes - you can run different VMs via docker. I tend to use Parallels (there’s a link in the description for a discount) Parallels is a nice hypervisor that has some features I really like. I have some videos on that too! 😀
@@LearningandTechnology I already have a Parallels. It’s cool tool. My Visual Code is there. But I decided that it’s better to use Visual Studio, SQL Server and SSMS via one place - Docker. Does it make a sense or not? Thanks for answering)
I wonder which Parallels Desktop edition is required to run the SQL Server Management Studio (SSMS) on Apple Silicon. Standard? Pro? Or the App Store one? Looking at the MS download site I find under supported hardware: "1.8 GHz or faster x86 (Intel, AMD) processor. Dual-core or better recommended". No mention of Windows ARM at all?
SSMS will run on a Windows 11 VM. In the video, I’m using the ARM version. However, if you want to save a step, you can run Azure Data Studio to connect to the SQL Server - Data Studio has a version that runs on Macs.
Could have just used a docker vm for sql, azure data studio for your manager? i understand azure data studio is not a full blown sql manager, but i think it's pretty good
Azure Data Studio would definitely work. In the video, I wanted to show the Windows VM so that if there are any Windows-only tools you need you can see how they can be used.
Frank, I followed your instructions 100% for the server:2022-latest image using Docker Desktop on a Mac M1 with Rosetta turned on etc. However I cannot access the SQL Server from SSMS on a Parallels Windows 11 ARM VM using the IP address of the MacBook on which the docket image and container was created. Using Docker Desktop v4.27.1 - This is utterly frustrating - The container is there, I have a volume for the data - just cannot connect using the MacBook IP address - What am I missing here?
When you use SSMS, are you using SQL Authentication or Windows Authentication? You need to use SQL Authentication using the username and password from the script.
Help! I was able to install Parallels (Windows), Docker and get SSMS downloaded. However, I am having a problem with the IP address. When I add this to my SSMS with the password I am getting an error message that network not found error, can't connect to my home IP address.
Hi Frank, I hope you're doing well. Thank you for the video. I have a question: Could I connect to Visual Studio or Power BI with the server obtained? I've tried to do so, but I haven't been successful. Thank you for your time. Greetings from Peru.
@@rodrigueze.2261 hello there! The Sever should be available to VS or Power BI. VS has a version that runs on Mac, but for PowerBI you would need to run Power BI on a PC (or VM that allows it)
now im trying to access my database from parrallels to my hosting mac, i am able to connect it on SSMS but when i tried visual studio community it's just giving me errors like System.Data.SqlClient.TdsParser.ThrowException what could the problem be?
Thank you very much, in fact you can use the IDE for Mac Azure Data Studio without having to use Parallels, but for those who prefer the Windows IDE it is excellent. On the other hand, if you can show how to connect this database with R Studio it would be very helpful to me. Thanks again.
Good point - Azure Data Studio runs across a lot of platforms. I have some "R" videos on my roadmap - hopefully soon. My problem is that I'm interested in too many technologies :) haha! One video at a time!
Hi. Does it still work if im connected to new wifi network or would i have to copy a new IP address for every wifi network i connect to? And does it also work with visual Studio
Hi frank! greetings from Costa Rica, wanted to ask if theres any chance you can make a video about loading files to the docker container, like for example, for restoring a database in sql, its impossible to find the file because it wont show the windows files on the program, tysm anyway i need help with this!!
I got this error in Terminal : ///: Any help? docker: Error response from daemon: received unexpected HTTP status: 503 Service Unavailable. See 'docker run --help'.
@@LearningandTechnology Thanks for the reply! I ADS as an option but only found a free 1-month trial. I think I figured it out though. I was using the wrong link on that page and downloading/installing sql 2022 mistakenly.
Frank, just had a first view of this and will try this method. I have no prior knowledge with Docker. Once installed can I copy a .bak file to Docker and restore a Db from this .bak file? Doing a backup of a Db in the Docker container SQL using SSMS on the Windows11 on Parallels: 1) is that possible 2) where is the .bak file stored? Thanks! This looks promising. I wonder if there will ever by a SQL version that can run natively on ARM architecture...
The way to get the .bak file onto the database is to first set it all up as in the video - then, connect to it via SSMS and use SSMS (or Azure Data Studio) to restore the .bak file - then, "voila!" you will have your database.
@@LearningandTechnology Thanks, understood. What I am struggling with is how to define a particular folder in the macos file sytem as a volume in docker; and then how to refer to that volume when creating the image with a volume attached for data persistence as per the docker command that you linked to. Perhaps a separate video on that would help many novices like me. We are basically following a few instructions in order for the docker magic' to start working - really what's behind a docker image and its container is a nightmare to immediately understand.
@@borgehansen6680 Docker certainly has a lot more to it that would make some good videos! It’s a skill set that will become even more important in the future - so maybe some more videos would be a good idea. Thanks!
Hello Mr. Frank i have problem when i try to connect my sql server to my application via entity framework please check if it works with you and thanks ...
Using SSMS was meant as an example - I wanted to demonstrate the use of Windows-only tools. There are several options - including remote access from a different system entirely, etc.
Oh - and the other element was to support older tools for Business Intelligence that won’t work with Azure Data Studio. That’s a whole other set of work.
SQL requires a x86 architecture - and Parallels has an Ubuntu x86 VM that you “could” use. Here’s an easy way though: Run Microsoft SQL Server on a Mac (M1/M2) ua-cam.com/video/co6TkSzc0s8/v-deo.html
Hey! Amazing video, SQL server works great! Even though my Mac is only 8gb of ram and it's a M1 chip. What do you of installing the Microsoft VS? Since it will be out of support for the macOS devices? Or is better to use another platform like Rider? Thanks!
Unfortunately not. The SQL products are all Intel-based (SSRS, SSIS, SSAS, SSMS). The Parallels on an M1/2 chip set runs an ARM based version of Windows 11. This is also why we cannot install Windows Server into a VM on M1/2 chips. There are several options though (and I have videos here on most). We can run Cloud DB services on Azure (which is really the way things are going). We can run the install I show in this video - or we can run Infrastructure in the Cloud, build a VM, etc.
Hello, can you help me? I try to restore a database using SSMS, but only the container directories appear, I tried to import the database into the container but it doesn't work
@@LearningandTechnology Thank you, sir. I was lost for two days trying to figure out if I had installed fresh Windows 11. I found the answer in your unique video.
Hi Frank, This is working very well. Mac Mini M2, 24GB, 1TB. Now I am able to import XLSX directly into the SQL Server DB. I get the option to save the SSIS package, but I am curious as to which way to go to use SSIS to rerun the SSIS packages.. Do you have a learning for that?
Thanks for the tutorial, everything's working fine now. I'm wondering if there is a way to use a generic IP address. Since the VM on Parallels run under the host of the MacBook directly, this will be very neat since it would allow me to have the same connection string every time and it won't be dependent of the network I use. I work with developers and our codebase is the same for everyone, we all have the web.config inside a .NET project and the host is like .\SQLEXPRESS and I don't wan't to change it every time. Any idea ?
I’d have to try it out, but the “old school” guy in me wonders if a quick edit of the HOSTS file might solve this. I’m going to play around with this at some point - it should be possible one way or another other. (Although - editing everyone’s HOSTS file is very 1980’s) 😀
a bit confused with the tutorial. I installed parallels and I downloaded and installed windows 11.... Am I also supposed to run another virtual environment that has ubuntu??? Is there no way to just use windows 11?
Am I the only one who can't figure out how he magically pulled up Windows 11? I'm so lost. I'm running the container, I got my IP address, but where is he just opening Windows 11???
It only SEEMS like magic! You can do it too! It’s a virtual machine - here’s a video where I show you how: Use Windows, Linux, and more on a Mac - with Parallels 19 ua-cam.com/video/Dvw4giBTZw0/v-deo.html
@@LearningandTechnology Oh, thank you for clarifying. Yes, on my Mac M1 machine, I have Windows 11 on parallel and tried to install SQL Server Express, but it failed.
Absolutely! In fact, using Azure makes things even easier - as you are running the Database on Azure and not the local system. I have a video on how to do this as well. Here is the link: Build your first SQL Database in Azure Cloud Services ua-cam.com/video/ov27ukpWgdQ/v-deo.html
@@LearningandTechnology thanks for the response I did tested above config on the VMwareFusion version 13 with windows 11 arm and it worked successfully.
@@huevosrancheros135 that would also work if you used Azure Data Tools instead of SSMS to connect - because Data Tools can run natively on a Mac and then you could use “localhost”
Parallels is a must-have for anyone using a Mac and needing access to Windows and Linux. Here is my affiliate link to check it out: prf.hn/l/melkMOm
what do I do when the password does not work
Oh. My. Gosh. Thank you!!! I have been trying to set this up all. day. I have literally spent HOURS reading forums and watching videos on how to do this, but the IP address info was THE missing piece. Thanks a MILLION!
My IP address won't connect for some reason
I got it:)
I'm so thankful for this video !! My teacher didn't help me, I'm behind on so many PowerBI lessons just because I couldn't run Microsoft SQL on my Mac and I grew very frustrated and sad. Knowledge is power and your work is amazing, I'm deeply grateful. I really hope you're aware of your impact and somehow there's a way we can repay all the good back. Thank you, thank you, thank you!
@@macarlasanchez1432 with power BI - I also recommend using a VM to run the desktop software. I'm working on a video about that tonight!
2 days of struggling and finally your solution worked. Thank you very much
I just set this up on my MacBook Air M2 and it works great, super excited! Docker now has the Rosetta setting in 'General' and everything worked perfectly. Also I'm running Parallels 18 with Windows 11 and it worked great. Thank you so much for this tutorial super happy!
can you use visual studio code 2022 and work with the data bases from the docker sql? thank u sm!!
@@giann411 yes absolutely got docker working with sql server
Ca I ask how did you installed SQL in your Parallels Windows VM, I have tried many installers and version with my M2 and none success. Thanks ahead for your advice!
1 month of struggling and finally your solution worked. Thank you very much
When I connect visual studio code to sql server I get the error "the type initializer for microsoft.data.sqlclient.tdsparser threw an exception" can you help me?
Hi, I am from India. Love your videos. Keep up this good work Sir.
When I go to "features in development", there is no " Use Rosetta ..." box that I can click on. What might be causing the issue?
I’ll have to double-check. A few folks have mentioned this and I’m wondering if it’s now out of development and just part of Docker.
@@LearningandTechnology facing same issue
found it, its now under General in settings
@@imxd1698Fantastic! Thanks - I’ll pin this comment to make sure every knows
How did you find it? @@imxd1698
@LearningandTechnology Hi Frank, I have downloaded the docker sor apple silicon chip and I have x86 running in parallels but the option to enable it on docker does not appear for me. Is there something I can do to solve this? I am using a MacBook with an M1 chip. Thanks
i have the same problem, if you have already solved it can you help me?
i aslo have a same problem @@mrmrhmi3947
Thank you very much After days of Struggling I managed to install
This was super helpful!!!...now i can continue my data analytics training on my mac
thanks for sharing this video, very grateful. one more question, do you know how to insert the data form Excel in to the database in Microsoft SQL. what is the right format for the file path ? thank. you so much.
I often have students use the Import/Export wizard for simple Excel (csv) files to SQL
That would be a good video…
You beautiful man, I'm starting a college course in SQL in which I need to use SSMS and as a complete noob I was able to follow these steps and get it working on Parallels on my M3 mac. Thank you sir :)
Life saver for Mac users!!! Appraciated!!
You're welcome! Thank you very much for watching and taking the time to comment as well - it really helps the channel.
I'm glad it was useful!
Of course my pleasure Frank! I watched tons of them but got errors with Macbook Air M2, 2022. Finally found your video and works perfectly! Thank you again Sir! @@LearningandTechnology
Thanks is much for your help on this! Lifesaver! When I shutdown Docker Mac or Windows 11 on Parallels, why does the SQL container go away afterwards? I have to go back to your link recopy the code into terminal and run the whole process again
It should be persistent and remain in place until deleted. There should be a way to save when you shutdown?
Glad it was helpful!
Thank you so much for such a clear explanation! I've finally installed it on my Mac M1, and it turned out to be so easy 🙏
This makes me very happy
Much appreciated because this is just what I needed. Clear and helpfull.
Great tutorial! Thank you very much! I'm able to use SQL on my Macbook now :)
I have a question. The Windows 11 that we install inside parallel is ARM version. But SQL Server Management Studio does not come with Arm version, how did you install SQL Server Management Studio inside windows which is ARM Version?
That is an issue. You need to run the container for SQL. For a lot of applications, we will run the databases in a Cloud service rather than local - or even different databases.
Great video! How can we set this up as a local host instead of using the IP? I find when I switch networks I am having to switch some settings to keep the connections going.
IT WORKED! OMG I've been struggling all day thank you
Hooray!
@@LearningandTechnology Your video along with "How to Restore a SQL Server Database on macOS Using Docker by Chritian Hur" really saved me a huge amount! thank you so much. If anyone is looking to load the AdventureWorks.bak file onto docker and use it via parallels on Mac please follow this.
Thank You. I used to search for resolution for a long time.
You are the best, mssql running. but How can I restore or attach an existent database?
Once installed - you can connect using a client tool (SSMS, Data studio, etc) and restore that way.
Excellent tutorial. Thanks... Worked right away
Hi! Sorry I'm very new in all about the data analytics but I just wanted to know if a MacBook with this specifications would be enough to use the sql server, photon, R, Power bi and Microsoft access -->
Apple M3 chip with 8-core CPU, 10-core GPU, 16-core Neural Engine
16GB unified memory
512GB SSD storage
That is a powerful system and excellent for Data Analysis.
The tools you need are often available through Cloud Services as well. So through a combination of Virtual Machines or Cloud Services - you would be able to do the work.
I have videos on these topics as well. It’s a little bit of a learning curve - but Macs are great systems for Data Analysis
@@LearningandTechnology Thank you so much! I've always been an apple client so I'll really want to keep it like that while using that software, thank you so much
Hey there! I ran into a hurdle immediately. The Rosetta option isn't there. I have a macbook pro m1 pro...not sure that excludes me from being able to do this? I downloaded the current docker desktop for apple silicon just a week ago, and it doesn't give me the Rosetta option. Any help is appreciated. Thanks and great video! Generally quick and you gave a.lot of information.
the option is in general now
@@cookinghistory177 Thanks! Was also looking for it
Ok, but how did you installed the SSL Ssrver management in the windows vm, I always get an error message.
Thanks Frank! Does this mean that the database we create is housed on our mac computers and not on the azure cloud services? What about backups or security with what we create? Thanks!
Yes indeed! The Database is on the Mac and local. So you need to handle admin tasks such as back-up, access, high availability and such.
For this reason, I do try to use Cloud Services - bit this is a good option for testing and learning or in cases where the Cloud is not an option.
Hello. Thank you for this video. Please let me know if you can help me troubleshoot something: When I run the "docker run -e.." command in the terminal it just hangs. I've tried several times and waited several hours. It hangs and no new Containers ever appear in the Containers tab in Docker.
Brilliant! I could finally set-up this bad boy! I appreciate you so much Frank!
Excellent! Thank you for watching and commenting - have fun with data!
This is really helpful, thanks a million
Hello Mr. Frank, I have a MacBook that runs on an Intel processor. Should I apply the same instruction as you did, or is there another way?
The Intel Macs are much easier! You can install Windows Server and SQL in a VM. They are x86 (Intel) programs.
@@LearningandTechnology Thanks for the reply Mr. Frank This means I have to download the Windows environment and download Sql Right inside it, right?
I'm having problem with terminal, after pasting address from site shared by you, there password command pops up which is not coming in your case, not able to proceed
It should be the password for Admin permissions on the Mac
Hi Frank, I am not seeing the Rosetta feature. I have an intel chip so I downloaded the intel chip docker. Any suggestions on what to do? Thanks!
If it's an Intel chip, then you don't actually need Docker - you can just create a Virtual Machine and install SQL.
Hi Frank. When I try to connect to Docker contained SQL Server, I have a error message:
"Cannot connect to (IP Address)
Additional Information
The type initializer for 'Microsoft.Data.SqlClient.TdsParser' threw an exception
(Microsoft.Data.SqlClient)
The type initializer for 'Microsoft.Data.SqlClient.SNILoadHandle' threw an exception
(Microsoft.Data.SqlClient)
Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x86.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
What can I've missed?
Thank you very much!!! It is really very useful, thank you for your work and video)
This man is straight spittin. Very well done.
From where you got the username? it is throwing login error for "sa" as username
Sa is the default Admin account for SQL. You can see the script in the video and might need to make any small changes if you wanted to use something else.
The login error is probably the password - not the username.
can i not install azure data studio directly on mac and connect to the docker container which runs the sql server instead of running a virtual machine
@@shwetaagarwal5465 yes - you can. I wanted to show SSMS - that required Windows
Thanks a lot for your help. It worked for me.
How much RAM and Storage is needed for this to work well? Im currently looking into getting a Macbook Air or Pro
@@hg-oz5ui I'm using a Mac Mini M1 with 16GB RAM and am happy with it. I'm not running any massive databases or processes. Jiatnusingnit for learning and teaching.
Hello Mr. Frank please where do i find the command prompt i will put in the Terminal
I’ve linked it in the description for the video - can copy and paste it - just change the password to something you like
Unable to install sql database engine on parallels
@@zerut7264 correct - you can not install SQL on ARM (M1/2/3/4) architecture. Parallels on a Mac has to run ARM.
That's also why you can't install Windows Server.
Hi! I followed all the steps but when connecting to the database it tells me "An existing connection was forcibly closed by the remote host (OS error 10054)" Did I miss something?
my mac is intel core, do i still need to go through the same steps or its different, Thanks
Thank you so much! I have additional questions, could you help me please? Can I run Visual Studio via Docker on M2? Can I run SSMS also via Docker? Thanks!
Yes - you can run different VMs via docker. I tend to use Parallels (there’s a link in the description for a discount)
Parallels is a nice hypervisor that has some features I really like.
I have some videos on that too! 😀
@@LearningandTechnology I already have a Parallels. It’s cool tool. My Visual Code is there. But I decided that it’s better to use Visual Studio, SQL Server and SSMS via one place - Docker. Does it make a sense or not? Thanks for answering)
@@soofiishaa ah! Yes - you can install them in a single Docker
Hello Frank I have the m1 chip macbook pro and upon downloading the docker, i don't see the rosetta option in features in development
It may be possible that it’s no longer in development and now part of the install. Does the rest of the install work?
@@LearningandTechnology after the terminal step, I don’t see the application in the container
@@parimashelat1716 hmmm - they may have changed where the Rosetta check mark is - look under settings/preferences
I wonder which Parallels Desktop edition is required to run the SQL Server Management Studio (SSMS) on Apple Silicon. Standard? Pro? Or the App Store one? Looking at the MS download site I find under supported hardware: "1.8 GHz or faster x86 (Intel, AMD) processor. Dual-core or better recommended". No mention of Windows ARM at all?
SSMS will run on a Windows 11 VM. In the video, I’m using the ARM version.
However, if you want to save a step, you can run Azure Data Studio to connect to the SQL Server - Data Studio has a version that runs on Macs.
Could have just used a docker vm for sql, azure data studio for your manager? i understand azure data studio is not a full blown sql manager, but i think it's pretty good
Azure Data Studio would definitely work. In the video, I wanted to show the Windows VM so that if there are any Windows-only tools you need you can see how they can be used.
Frank, I followed your instructions 100% for the server:2022-latest image using Docker Desktop on a Mac M1 with Rosetta turned on etc. However I cannot access the SQL Server from SSMS on a Parallels Windows 11 ARM VM using the IP address of the MacBook on which the docket image and container was created. Using Docker Desktop v4.27.1 - This is utterly frustrating - The container is there, I have a volume for the data - just cannot connect using the MacBook IP address - What am I missing here?
I’m wondering if there is a firewall running on the Mac that’s blocking access?
@@LearningandTechnology Im having the same problem. Even went to network -> firewall and disabled it, and it still don't work :,(
When you use SSMS, are you using SQL Authentication or Windows Authentication?
You need to use SQL Authentication using the username and password from the script.
Help! I was able to install Parallels (Windows), Docker and get SSMS downloaded. However, I am having a problem with the IP address. When I add this to my SSMS with the password I am getting an error message that network not found error, can't connect to my home IP address.
Docker 14.26.1 doesn't have "Use Rosetta" option anymore
You will find it in settings > general
I think they moved there since it is not a “features in development” anymore
Hi Frank,
I hope you're doing well. Thank you for the video. I have a question: Could I connect to Visual Studio or Power BI with the server obtained? I've tried to do so, but I haven't been successful. Thank you for your time. Greetings from Peru.
@@rodrigueze.2261 hello there! The Sever should be available to VS or Power BI. VS has a version that runs on Mac, but for PowerBI you would need to run Power BI on a PC (or VM that allows it)
now im trying to access my database from parrallels to my hosting mac, i am able to connect it on SSMS but when i tried visual studio community it's just giving me errors like System.Data.SqlClient.TdsParser.ThrowException what could the problem be?
Maybe the connection string you used
Thank you very much, in fact you can use the IDE for Mac Azure Data Studio without having to use Parallels, but for those who prefer the Windows IDE it is excellent. On the other hand, if you can show how to connect this database with R Studio it would be very helpful to me. Thanks again.
Good point - Azure Data Studio runs across a lot of platforms.
I have some "R" videos on my roadmap - hopefully soon. My problem is that I'm interested in too many technologies :) haha! One video at a time!
I understand you, but please let me know when you do it.@@LearningandTechnology
Hi. Does it still work if im connected to new wifi network or would i have to copy a new IP address for every wifi network i connect to? And does it also work with visual Studio
Hi frank! greetings from Costa Rica, wanted to ask if theres any chance you can make a video about loading files to the docker container, like for example, for restoring a database in sql, its impossible to find the file because it wont show the windows files on the program, tysm anyway i need help with this!!
How can i find files from sql, im trying to find a restored db bak but it wont appear in files
I got this error in Terminal : ///: Any help?
docker: Error response from daemon: received unexpected HTTP status: 503 Service Unavailable.
See 'docker run --help'.
Can't get Sql management studio to install on my W11 VM in parallels. Even with the container running in docker. Just keep getting install errors :/.
Azure Data Studio will work across multiple architectures - it may be the better option
@@LearningandTechnology Thanks for the reply! I ADS as an option but only found a free 1-month trial. I think I figured it out though. I was using the wrong link on that page and downloading/installing sql 2022 mistakenly.
you're the man Frank! Thanks a billion!
Docker container running and pausing and restarting, not constantly running
Frank, just had a first view of this and will try this method. I have no prior knowledge with Docker. Once installed can I copy a .bak file to Docker and restore a Db from this .bak file? Doing a backup of a Db in the Docker container SQL using SSMS on the Windows11 on Parallels: 1) is that possible 2) where is the .bak file stored? Thanks! This looks promising. I wonder if there will ever by a SQL version that can run natively on ARM architecture...
The way to get the .bak file onto the database is to first set it all up as in the video - then, connect to it via SSMS and use SSMS (or Azure Data Studio) to restore the .bak file - then, "voila!" you will have your database.
@@LearningandTechnology Thanks, understood. What I am struggling with is how to define a particular folder in the macos file sytem as a volume in docker; and then how to refer to that volume when creating the image with a volume attached for data persistence as per the docker command that you linked to. Perhaps a separate video on that would help many novices like me. We are basically following a few instructions in order for the docker magic' to start working - really what's behind a docker image and its container is a nightmare to immediately understand.
@@borgehansen6680 Docker certainly has a lot more to it that would make some good videos! It’s a skill set that will become even more important in the future - so maybe some more videos would be a good idea. Thanks!
Hi I have problem with login and Password. With login I have to use? Still have error 18456
how can i install sql on mac m3
@@faisalnk4631 I don't have an M3 to test this, bitnit should be exactly the same process as an M1 or M2 as in this video.
Hello Mr. Frank
i have problem when i try to connect my sql server to my application via entity framework please check if it works with you
and thanks ...
Microsoft.Data.SqlClient.SqlException: 'Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.'
or we can control the docker sql server on mac through azure data studio for mac so it eliminates the need for parallels
Using SSMS was meant as an example - I wanted to demonstrate the use of Windows-only tools. There are several options - including remote access from a different system entirely, etc.
Oh - and the other element was to support older tools for Business Intelligence that won’t work with Azure Data Studio. That’s a whole other set of work.
Hi Frank, I have a parallels 19. Can you you explain how can I install sql server, please.
SQL requires a x86 architecture - and Parallels has an Ubuntu x86 VM that you “could” use.
Here’s an easy way though:
Run Microsoft SQL Server on a Mac (M1/M2)
ua-cam.com/video/co6TkSzc0s8/v-deo.html
Hi there, is there any way that I could do this but change the IP address to a static one instead of one that is dynamic?
That should be possible if you change the script. An easier way would be to create a DHCP reservation and then it will assign the same IP every time.
Hey! Amazing video, SQL server works great! Even though my Mac is only 8gb of ram and it's a M1 chip. What do you of installing the Microsoft VS? Since it will be out of support for the macOS devices? Or is better to use another platform like Rider? Thanks!
Hi, can we use SSRS on an M2 Mac using Parallels? Thanks!
Unfortunately not. The SQL products are all Intel-based (SSRS, SSIS, SSAS, SSMS). The Parallels on an M1/2 chip set runs an ARM based version of Windows 11. This is also why we cannot install Windows Server into a VM on M1/2 chips.
There are several options though (and I have videos here on most). We can run Cloud DB services on Azure (which is really the way things are going). We can run the install I show in this video - or we can run Infrastructure in the Cloud, build a VM, etc.
Hello Frank, I am not seeing the Rosetta feature too. I have a m1 chip .Any suggestions on what to do?
Hey! It is on the general settings and already selected. Go ahead, it should work!
Hello, can you help me? I try to restore a database using SSMS, but only the container directories appear, I tried to import the database into the container but it doesn't work
im not getting the rosetta feature on docker why??
Did you click on the settings? Top right?
yes the option is not even showing up in the settings@@LearningandTechnology
@@rema8073 are you using an M1/M2 Mac?
yes m2 mac@@LearningandTechnology
everything else downloaded and worked but i just dont have that feature@@LearningandTechnology
Great one. However, I wonder why SQL Server should not be installed directly on Windows 11 using Parallels Desktop on M1/M2? Is it a hardware thing?
It’s the M1 chip issue
@@LearningandTechnology Thank you, sir. I was lost for two days trying to figure out if I had installed fresh Windows 11. I found the answer in your unique video.
Extremly usefull, thank you very much!!
Glad it helped! Thank you for commenting too! Appreciate it!
What is the software used in your virtualization of Windows?
@@juanhuenchun8908 I use Parallels. I should have a link in the Description if you are interested in trying it out.
Hi Frank, This is working very well. Mac Mini M2, 24GB, 1TB. Now I am able to import XLSX directly into the SQL Server DB. I get the option to save the SSIS package, but I am curious as to which way to go to use SSIS to rerun the SSIS packages.. Do you have a learning for that?
I don’t have any SSIS content here on UA-cam - at least not quite yet :)
Thanks for the tutorial, everything's working fine now.
I'm wondering if there is a way to use a generic IP address. Since the VM on Parallels run under the host of the MacBook directly, this will be very neat since it would allow me to have the same connection string every time and it won't be dependent of the network I use. I work with developers and our codebase is the same for everyone, we all have the web.config inside a .NET project and the host is like .\SQLEXPRESS and I don't wan't to change it every time. Any idea ?
I’d have to try it out, but the “old school” guy in me wonders if a quick edit of the HOSTS file might solve this.
I’m going to play around with this at some point - it should be possible one way or another other.
(Although - editing everyone’s HOSTS file is very 1980’s) 😀
Finally, something that worked. 💃 thanks
a bit confused with the tutorial. I installed parallels and I downloaded and installed windows 11.... Am I also supposed to run another virtual environment that has ubuntu??? Is there no way to just use windows 11?
@@aldoussnow9156 the Windows environment was just to run SSMS and it totally optional. You can run Azure Data Studio directly on your Mac
@@LearningandTechnology got it, all figured out. thanks a lot for this tutorial.
Is their anyway to run windows 11 and install RSAT tools for administrators?
hocam kralsin. greetings from Türkiye
Welcome!
@@idrisagiragac 😂 konuyla alakalı gezdiğim 10. video, sadece bu hocam doğru adımları veriyor. 🤟🏼
ayni hisleri tasiyorum!! :D@@salihemrebicer8391
@@salihemrebicer8391m3 mac için de uygun mudur tekniği?
@@salihemrebicer8391 m3 de de aynu şekilde indirilir mi? Bir de harddisk e yüklenilerek kullanılabilir mi?
very helpfull...thanks a lot sir
Is there somewhere or somehow to copy the script for terminal?
yes - I put it in the description for the video
Am I the only one who can't figure out how he magically pulled up Windows 11? I'm so lost. I'm running the container, I got my IP address, but where is he just opening Windows 11???
It only SEEMS like magic! You can do it too! It’s a virtual machine - here’s a video where I show you how: Use Windows, Linux, and more on a Mac - with Parallels 19
ua-cam.com/video/Dvw4giBTZw0/v-deo.html
Looks like he used "parralels" which allows you to run windows.
In SQl management server i am stuck at username. What should i put there?
metoo
What's the point of installing the server engine in Docker and the management studio in parallels? Why not install both in parallels?
You can’t install it in a VM if you have an M1/2 chip.
@@LearningandTechnology Oh, thank you for clarifying. Yes, on my Mac M1 machine, I have Windows 11 on parallel and tried to install SQL Server Express, but it failed.
simply best video out there
Thanks!
Super helpful for me, a KISS from my side....
thank you soooo much! it works!)
Is full-text available for this sql instance?
how did you get the virtual window 11 tab?
its using parallels, but you need to pay subscription for it
is there anyway to use it using Azure
Absolutely! In fact, using Azure makes things even easier - as you are running the Database on Azure and not the local system.
I have a video on how to do this as well. Here is the link:
Build your first SQL Database in Azure Cloud Services
ua-cam.com/video/ov27ukpWgdQ/v-deo.html
I am sorry I meant to say Azure data studio along with docker! @@LearningandTechnology
I can't find the rosseta option, Im with mac M2
I also do not have the rosetta option, this is so frustrating. Have you found a solution?
Does this method will work with VMwareFusion 13 on Windows 11 arm? thanks
I haven’t tested that configuration unfortunately
@@LearningandTechnology thanks for the response I did tested above config on the VMwareFusion version 13 with windows 11 arm and it worked successfully.
@@shalinkaushik3999 awesome! Thank you for coming back to let everyone know - much appreciated! Great work!
@@shalinkaushik3999 Im using VMwareFusion as well, but I can't connect to my Mac IP, is this something you encountered as well?
Still in the process of setting this up but would it work offline without an internet connection or would I have to go down the Ubuntu path?
It would work without Internet once it’s set up. The container is local to the Mac Mini.
@@LearningandTechnology I guess I'm more asking is this possible without being connected to the local network?
@@huevosrancheros135 that would also work if you used Azure Data Tools instead of SSMS to connect - because Data Tools can run natively on a Mac and then you could use “localhost”
@@LearningandTechnology but then for example would I have to run visual studio on the macOS?
@@huevosrancheros135 no - just Azure Data Studio
Worked for me using it for school. I'll update if it doesn't work out.
Thanks sir ❤ I can’t believable
i can t connect to a local server on my mac?