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 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!
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?
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 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.
@@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.
@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
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! 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
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.
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.
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.
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.
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, 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)
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?
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.
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.
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 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?
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!!
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.
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.
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
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?
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
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!
I got this error in Terminal : ///: Any help? docker: Error response from daemon: received unexpected HTTP status: 503 Service Unavailable. See 'docker run --help'.
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)
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?
@@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.
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Dvw4giBTZw0.html
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) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-co6TkSzc0s8.html
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?
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.
@@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.
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 ...
Thank you! This really helped me. I was wondering why I couldn't connect to localhost with my VM when I could through the Mac app. Instead I put my IP address in Azure and it connected instantly.
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.
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.
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) 😀
@@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.
Localhost should resolve to the IP of the system in question. It’s a matter of choice - it’s beyond the scope of the video, but using static IPs and DNS is what I’d normally doing I wanted remote clients to resolve to the computer running SQL
@@LearningandTechnology i used hotspot to connect to internet on my laptop and then tried to connect to my sql server the same way you did. obviously i had as my server name the ip address of my internet, but when i tried to connect with hotspot internet, i had an error.
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ov27ukpWgdQ.html
@@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 thanks for the response I did tested above config on the VMwareFusion version 13 with windows 11 arm and it worked successfully.