Run Microsoft SQL Server on a Mac (M1/M2)

Рет қаралды 46,456

Күн бұрын

SQL Server is a very popular RDMS, but running it on a Mac hasn't been possible - until now!
In this tutorial, we'll show you how to run Microsoft SQL Server on a Mac (M1/M2). This guide will help you get started with Microsoft SQL Server and provide some tips and advice on how to run the software on a Mac.
If you're looking to move your SQL Server data to a Mac or set up your Mac to study data then this video is for you. We'll show you how to install and set up Microsoft SQL Server on a Mac, and then we'll teach you how to run SQL Server Management Studio in a VM to connect to the Database Engine. By the end of this video, you'll be able to run Microsoft SQL Server on a Mac.
You can get Parallels here:
prf.hn/click/camref:1101lumT6
Get a copy of Parallels here: (affiliate link)
prf.hn/l/Y3zodAR
Install Docker for Mac silicon here:
docs.docker.com/desktop/insta...
Install SQL Server on Mac (after installing Docker) here:
kb.parallels.com/en/129699
AI to help with e-mail overwhelm: try.sanebox.com/wgme43jv1x6y
Would you like to learn Microsoft Whiteboard?
I've launched a course on Microsoft Whiteboard! Over 2 hours of tips, tricks, and skills. This course is designed to make you a Whiteboard Wizard!
To celebrate the launch, there is a 30% Discount if you use the code Launch30 at checkout. It's limited to only 50 enrollments, so you'll hurry if you want the discount.
frank-s-site-a22b.thinkific.c...
My Favourite Gear
Here is my Amazon Store - I try to keep it updated 😁
Canada www.amazon.ca/shop/learningan...
US Store www.amazon.com/shop/learninga...
Social Links
📸 Instagram - / learning_and_tech
🧑‍🤝‍🧑 Facebook - / learningtechnologychannel
🐤 Twitter - / frankbergdoll
🌏 BLOG (Franks Class) - www.franksclass.ca
🌐 Learning Mindset Website - learningmindset.ca
Some links may support this channel via affiliate programs
#SQL #Mac #SSMS #data

Пікірлер: 233

@gajendrakc813 6 ай бұрын

When I go to "features in development", there is no " Use Rosetta ..." box that I can click on. What might be causing the issue?

@LearningandTechnology 6 ай бұрын

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.

@imxd1698 6 ай бұрын

@@LearningandTechnology facing same issue

@imxd1698 6 ай бұрын

found it, its now under General in settings

@LearningandTechnology 6 ай бұрын

@@imxd1698Fantastic! Thanks - I’ll pin this comment to make sure every knows

@salenajsh6891 6 ай бұрын

How did you find it? @@imxd1698

@namlongpham5624 7 ай бұрын

2 days of struggling and finally your solution worked. Thank you very much

@olivesierra3521 9 ай бұрын

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!

@dollins8297 4 ай бұрын

My IP address won't connect for some reason

@dollins8297 4 ай бұрын

I got it:)

@koosbrandt4499 10 ай бұрын

Much appreciated because this is just what I needed. Clear and helpfull.

@georgemiyahara6576 8 ай бұрын

Brilliant! I could finally set-up this bad boy! I appreciate you so much Frank!

@LearningandTechnology 8 ай бұрын

Excellent! Thank you for watching and commenting - have fun with data!

@user-zj6tr3os1x 6 ай бұрын

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 🙏

@LearningandTechnology 6 ай бұрын

This makes me very happy

@anhnguyenquoc6679 2 ай бұрын

1 month of struggling and finally your solution worked. Thank you very much

@anhnguyenquoc6679 2 ай бұрын

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?

@sehassenhiru 5 ай бұрын

Thank you very much After days of Struggling I managed to install

@WithoutCold 3 ай бұрын

Great tutorial! Thank you very much! I'm able to use SQL on my Macbook now :)

@markslima1557 5 ай бұрын

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!

@giann411 Ай бұрын

can you use visual studio code 2022 and work with the data bases from the docker sql? thank u sm!!

@markslima1557 Ай бұрын

@@giann411 yes absolutely got docker working with sql server

@user-wd2gb1vw8p 5 ай бұрын

Thank you very much!!! It is really very useful, thank you for your work and video)

@user-co8mn1mx3b 7 ай бұрын

This man is straight spittin. Very well done.

@doobip 4 ай бұрын

Thank You. I used to search for resolution for a long time.

@alandovi97 2 ай бұрын

Thanks a lot for your help. It worked for me.

@amanku3318 2 ай бұрын

This is really helpful, thanks a million

@Andrea-jl2wc 5 ай бұрын

you're the man Frank! Thanks a billion!

@aishausman1575 4 ай бұрын

IT WORKED! OMG I've been struggling all day thank you

@LearningandTechnology 4 ай бұрын

Hooray!

@aishausman1575 4 ай бұрын

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

@ahmedadnankhan 3 ай бұрын

very helpfull...thanks a lot sir

@dariaten-vo7ty 5 ай бұрын

thank you soooo much! it works!)

@ariyabintaku2241 9 ай бұрын

Thank you so much krub 😚

@saidguerrero6581 6 ай бұрын

Extremly usefull, thank you very much!!

@LearningandTechnology 6 ай бұрын

Glad it helped! Thank you for commenting too! Appreciate it!

@AllThingsHealing02 4 ай бұрын

Thank you sooooo much!!!!!

@DutchThought 9 ай бұрын

Thank you!!

@asedaog 6 ай бұрын

Thank you so much

@ArayaMsQ 10 ай бұрын

Thanks !

@minhnguyenduy285 4 ай бұрын

thank you so much!!!

@ekinci_io 7 ай бұрын

Life saver for Mac users!!! Appraciated!!

@LearningandTechnology 7 ай бұрын

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!

@ekinci_io 7 ай бұрын

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

@CarvalhoAntonio 8 ай бұрын

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

@xx-sn3vt 4 ай бұрын

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!

@davidbarefieldjr 4 ай бұрын

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.

@billymcintyre2206 3 ай бұрын

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.

@lekebello2422 6 ай бұрын

Hello, pls I have a very urgent question. Can something like this help me install a “Microsoft 2019 sever on my M1 Mac”

@simphiwewalaza3680 Ай бұрын

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

@kulyashdahiya2529 15 күн бұрын

simply best video out there

@LearningandTechnology 9 күн бұрын

Thanks!

@wazzadec16 6 ай бұрын

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

@LearningandTechnology 6 ай бұрын

It should be persistent and remain in place until deleted. There should be a way to save when you shutdown? Glad it was helpful!

@Ray-wd8fc 4 ай бұрын

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 4 ай бұрын

I often have students use the Import/Export wizard for simple Excel (csv) files to SQL That would be a good video…

@user-tg7np9qd6x 8 ай бұрын

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!

@LearningandTechnology 8 ай бұрын

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.

@Cinccinatti_C3 7 ай бұрын

Is their anyway to run windows 11 and install RSAT tools for administrators?

@user-mj4vu5bz4k 7 ай бұрын

Is full-text available for this sql instance?

@giann411 23 күн бұрын

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

@koosbrandt4499 10 ай бұрын

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?

@LearningandTechnology 9 ай бұрын

I don’t have any SSIS content here on KZfaq - at least not quite yet :)

@loveleelinz 9 ай бұрын

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!

@LearningandTechnology 9 ай бұрын

If it's an Intel chip, then you don't actually need Docker - you can just create a Virtual Machine and install SQL.

@foxe2206 7 ай бұрын

your the best

@HobbitPipeSmoke 6 ай бұрын

I got this error in Terminal : ///: Any help? docker: Error response from daemon: received unexpected HTTP status: 503 Service Unavailable. See 'docker run --help'.

@MichaelRemyXD 6 ай бұрын

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 ?

@LearningandTechnology 6 ай бұрын

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

@user-vr7of5ko9y 5 ай бұрын

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?

@wolfk1ssed334 3 ай бұрын

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?

@LearningandTechnology 3 ай бұрын

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.

@NolanPeru-e9e 2 күн бұрын

my mac is intel core, do i still need to go through the same steps or its different, Thanks

@shaliniabcd 6 ай бұрын

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?

@LearningandTechnology 6 ай бұрын

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.

@ReinerSaddey 5 ай бұрын

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?

@LearningandTechnology 5 ай бұрын

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.

@giann411 Ай бұрын

How can i find files from sql, im trying to find a restored db bak but it wont appear in files

@zoevega405 2 ай бұрын

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?

@LordMufasa14 4 ай бұрын

Worked for me using it for school. I'll update if it doesn't work out.

@paulh6933 8 ай бұрын

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

@LearningandTechnology 8 ай бұрын

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.

@rashidaoje7386 9 ай бұрын

@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

@mrmrhmi3947 6 ай бұрын

i have the same problem, if you have already solved it can you help me?

@amanrayat7215 6 ай бұрын

i aslo have a same problem @@mrmrhmi3947

@lesliedancy6816 22 күн бұрын

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.

@rodrigueze.2261 10 ай бұрын

Hi Frank, I have a parallels 19. Can you you explain how can I install sql server, please.

@LearningandTechnology 10 ай бұрын

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) kzfaq.info/get/bejne/mdVmh86E38mUo2w.html

@user-sr6nu4dp1y 3 ай бұрын

Hi, can we use SSRS on an M2 Mac using Parallels? Thanks!

@LearningandTechnology 3 ай бұрын

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.

@MML945 6 ай бұрын

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.

@LearningandTechnology 6 ай бұрын

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!

@MML945 6 ай бұрын

I understand you, but please let me know when you do it.@@LearningandTechnology

@ipktunay5179 7 ай бұрын

Hello Frank, I am not seeing the Rosetta feature too. I have a m1 chip .Any suggestions on what to do?

@ekinci_io 7 ай бұрын

Hey! It is on the general settings and already selected. Go ahead, it should work!

@andricknatividad7526 4 ай бұрын

Does it work in m3?

@salihemrebicer8391 7 ай бұрын

hocam kralsin. greetings from Türkiye

@LearningandTechnology 7 ай бұрын

Welcome!

@salihemrebicer8391 7 ай бұрын

@@idrisagiragac 😂 konuyla alakalı gezdiğim 10. video, sadece bu hocam doğru adımları veriyor. 🤟🏼

@ekinci_io 7 ай бұрын

ayni hisleri tasiyorum!! :D@@salihemrebicer8391

@selin1789 6 ай бұрын

@@salihemrebicer8391m3 mac için de uygun mudur tekniği?

@selin1789 6 ай бұрын

@@salihemrebicer8391 m3 de de aynu şekilde indirilir mi? Bir de harddisk e yüklenilerek kullanılabilir mi?

@doctorg1 2 ай бұрын

You are the best, mssql running. but How can I restore or attach an existent database?

@LearningandTechnology 2 ай бұрын

Once installed - you can connect using a client tool (SSMS, Data studio, etc) and restore that way.

@borgehansen6680 9 ай бұрын

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

@LearningandTechnology 9 ай бұрын

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.

@borgehansen6680 9 ай бұрын

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

@LearningandTechnology 9 ай бұрын

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

@soofiishaa 7 ай бұрын

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!

@LearningandTechnology 7 ай бұрын

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

@soofiishaa 7 ай бұрын

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

@LearningandTechnology 7 ай бұрын

@@soofiishaa ah! Yes - you can install them in a single Docker

@AS-do5st 25 күн бұрын

Hi I have problem with login and Password. With login I have to use? Still have error 18456

@4404 7 ай бұрын

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

@4404 7 ай бұрын

Microsoft.Data.SqlClient.SqlException: 'Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.'

@BelloUsman-f8r Ай бұрын

Hello Mr. Frank please where do i find the command prompt i will put in the Terminal

@LearningandTechnology Ай бұрын

I’ve linked it in the description for the video - can copy and paste it - just change the password to something you like

@avinabdas2864 2 ай бұрын

From where you got the username? it is throwing login error for "sa" as username

@LearningandTechnology 2 ай бұрын

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.

@yadnyikeebhole1374 2 ай бұрын

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

@LearningandTechnology 2 ай бұрын

It should be the password for Admin permissions on the Mac

@user-fy5ph9sd9f 6 ай бұрын

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?

@MichaelRemyXD 6 ай бұрын

Maybe the connection string you used

@user-un4hc 7 ай бұрын

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?

@LearningandTechnology 7 ай бұрын

The Intel Macs are much easier! You can install Windows Server and SQL in a VM. They are x86 (Intel) programs.

@user-un4hc 7 ай бұрын

@@LearningandTechnology Thanks for the reply Mr. Frank This means I have to download the Windows environment and download Sql Right inside it, right?

@sami1456 8 ай бұрын

i can t connect to a local server on my mac?

@kevinstarofficial 10 ай бұрын

or we can control the docker sql server on mac through azure data studio for mac so it eliminates the need for parallels

@LearningandTechnology 10 ай бұрын

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.

@LearningandTechnology 10 ай бұрын

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.

@tomasgarcia3134 5 ай бұрын

I love you

@joshuathomasbrooks9450 26 күн бұрын

Is there somewhere or somehow to copy the script for terminal?

@LearningandTechnology 26 күн бұрын

yes - I put it in the description for the video

@LearningandTechnology 10 ай бұрын

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

@bingchillinhuehue 6 ай бұрын

how did you get the virtual window 11 tab?

@bingchillinhuehue 6 ай бұрын

its using parallels, but you need to pay subscription for it

@parimashelat1716 6 ай бұрын

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

@LearningandTechnology 6 ай бұрын

It may be possible that it’s no longer in development and now part of the install. Does the rest of the install work?

@parimashelat1716 6 ай бұрын

@@LearningandTechnology after the terminal step, I don’t see the application in the container

@LearningandTechnology 6 ай бұрын

@@parimashelat1716 hmmm - they may have changed where the Rosetta check mark is - look under settings/preferences

@HaithamKhaiyat 4 ай бұрын

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?

@LearningandTechnology 4 ай бұрын

It’s the M1 chip issue

@HaithamKhaiyat 4 ай бұрын

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

@adeelshahid3485 5 ай бұрын

In SQl management server i am stuck at username. What should i put there?

@thinhdrake7250 5 ай бұрын

metoo

@JD-ey8hw 6 ай бұрын

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 :/.

@LearningandTechnology 6 ай бұрын

Azure Data Studio will work across multiple architectures - it may be the better option

@JD-ey8hw 6 ай бұрын

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

@rc13k10 10 ай бұрын

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.

@borgehansen6680 6 ай бұрын

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?

@LearningandTechnology 6 ай бұрын

I’m wondering if there is a firewall running on the Mac that’s blocking access?

@happycoin6046 5 ай бұрын

@@LearningandTechnology Im having the same problem. Even went to network -> firewall and disabled it, and it still don't work :,(

@LearningandTechnology 5 ай бұрын

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.

@joem4102 5 ай бұрын

HERO

@asison1000 8 ай бұрын

I can't find the rosseta option, Im with mac M2

@salinasingh1372 6 ай бұрын

I also do not have the rosetta option, this is so frustrating. Have you found a solution?

@shalinkaushik3999 6 ай бұрын

Does this method will work with VMwareFusion 13 on Windows 11 arm? thanks

@LearningandTechnology 6 ай бұрын

I haven’t tested that configuration unfortunately

@shalinkaushik3999 6 ай бұрын

@@LearningandTechnology thanks for the response I did tested above config on the VMwareFusion version 13 with windows 11 arm and it worked successfully.

@LearningandTechnology 6 ай бұрын

@@shalinkaushik3999 awesome! Thank you for coming back to let everyone know - much appreciated! Great work!

@happycoin6046 5 ай бұрын

@@shalinkaushik3999 Im using VMwareFusion as well, but I can't connect to my Mac IP, is this something you encountered as well?

@Enrique_Rodriguez 4 ай бұрын

why does the login username needs to be "sa"?

@LearningandTechnology 4 ай бұрын

It doesn't really - sa is just the SQL default Admin account.

@saikrishnak0303 4 ай бұрын

Is parellels free to use? I see only a 14 day trial.

@LearningandTechnology 4 ай бұрын

It is not free to use. You can try it and see if it is useful for you. I think I have a discount in the description.

@erminoje 6 ай бұрын

What's the point of installing the server engine in Docker and the management studio in parallels? Why not install both in parallels?

@LearningandTechnology 6 ай бұрын

You can’t install it in a VM if you have an M1/2 chip.

@erminoje 6 ай бұрын

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

@robeatz5409 6 ай бұрын

is there anyway to use it using Azure

@LearningandTechnology 6 ай бұрын

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 kzfaq.info/get/bejne/pdxiatic1b3LlIU.html

@robeatz5409 6 ай бұрын

I am sorry I meant to say Azure data studio along with docker! @@LearningandTechnology

@huevosrancheros135 5 ай бұрын

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?

@LearningandTechnology 5 ай бұрын

It would work without Internet once it’s set up. The container is local to the Mac Mini.

@huevosrancheros135 5 ай бұрын

@@LearningandTechnology I guess I'm more asking is this possible without being connected to the local network?

@LearningandTechnology 5 ай бұрын

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

@huevosrancheros135 5 ай бұрын

@@LearningandTechnology but then for example would I have to run visual studio on the macOS?

@LearningandTechnology 5 ай бұрын

@@huevosrancheros135 no - just Azure Data Studio

@gijduvon6379 7 ай бұрын

Docker 14.26.1 doesn't have "Use Rosetta" option anymore

@yousefmahmoud-ij9rz 6 ай бұрын

You will find it in settings > general I think they moved there since it is not a “features in development” anymore

@rema8073 9 ай бұрын

im not getting the rosetta feature on docker why??

@LearningandTechnology 9 ай бұрын

Did you click on the settings? Top right?

@rema8073 9 ай бұрын

yes the option is not even showing up in the settings@@LearningandTechnology

@LearningandTechnology 9 ай бұрын

@@rema8073 are you using an M1/M2 Mac?

@rema8073 9 ай бұрын

yes m2 mac@@LearningandTechnology

@rema8073 9 ай бұрын

everything else downloaded and worked but i just dont have that feature@@LearningandTechnology

@geo0305 4 ай бұрын

why are we writing the ip address of our internet instead of localhost as server name?

@LearningandTechnology 4 ай бұрын

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

@geo0305 4 ай бұрын

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

@ArbazAbid 9 ай бұрын

Not working "(null): The system administrator (SA) password specified is too long" and password I set was hello123

@LearningandTechnology 9 ай бұрын

I would try again - that seems like an issue on your specific install. I’ve had several students do installs over the past few weeks with no issues.

@ArbazAbid 9 ай бұрын

@@LearningandTechnology can you please share the container command for terminal, with the pass that should work.

@LearningandTechnology 9 ай бұрын

@@ArbazAbid it’s in the description - I’ve placed it there. Make sure to change the password if you want something new - also, make it complex with upper/lower case and special characters

@foxe2206 7 ай бұрын

I have the same problem, please tell me what is the solution

@foxe2206 7 ай бұрын

I solved the problem. My problem was because the password was so weak

@IkbalDemirdoven 3 ай бұрын

where is URL ? you forgot to put it ?

@LearningandTechnology 3 ай бұрын

All the URL’s are in the Description - check it out.

@shannabanna1 5 ай бұрын

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

@LearningandTechnology 5 ай бұрын

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 kzfaq.info/get/bejne/etynZ8qap7q-p2Q.html

@harrisra4944 2 ай бұрын

Looks like he used "parralels" which allows you to run windows.

@user-hi4nt9sb5j 2 ай бұрын

wtf i need parallels to use this video?

@LearningandTechnology 2 ай бұрын

Nope. You only need parallels IF you want to use Windows 11 and SSMS. You can install Data Tools and be fine to connect with that (or any other client that connects to SQL)

@PerpetualPreponderer 3 ай бұрын

Why not just run everything in the Parallels Windows VM itself???

@LearningandTechnology 3 ай бұрын

SQL won’t run on an ARM system. The VM on an M1 (even Windows 11) is ARM - so SQL won’t install.

@PerpetualPreponderer 3 ай бұрын

@@LearningandTechnology oh?! ok so that option's out for me. Any suggestions on the best solution? Am a student, on course until July. I will need to run Power BI as well, so am really scratching my head on this one...

@LearningandTechnology 3 ай бұрын

@@PerpetualPreponderer PowerBI runs fine on the Windows 11 VM - it’s just the SQL. Another option is to run SQL in Azure - I have some videos on that too. That’s often what my students do.

@PerpetualPreponderer 3 ай бұрын

@@LearningandTechnology hmm...however using the method in this video, I don't need to worry about Windows licence correct? Can I also then run Power BI in docker?

@LearningandTechnology 3 ай бұрын

@@PerpetualPreponderer it’s all trial or Developer licenses for students - so you’re good there. Yes - you can use Docker