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

[@LearningandTechnology]

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

[@clarksontejiri4630]

what do I do when the password does not work

[@olivesierra3521]

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]

My IP address won't connect for some reason

[@dollins8297]

I got it:)

[@namlongpham5624]

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

[@macarlasanchez1432]

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!

[@LearningandTechnology]

@@macarlasanchez1432 with power BI - I also recommend using a VM to run the desktop software. I'm working on a video about that tonight!

[@markslima1557]

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

[@dcmg1982]

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!

[@anhnguyenquoc6679]

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

[@anhnguyenquoc6679]

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?

[@aishausman1575]

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

[@LearningandTechnology]

Hooray!

[@aishausman1575]

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

[@sehassenhiru]

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

[@ibukunoluwa3607]

Thank you so much for this video, I can finally run SSMS on my M1 via Parallels *excited*

[@SmithIRL]

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

[@phoenixshed-okara5415]

This was super helpful!!!...now i can continue my data analytics training on my mac

[@CuriousVibeswithme]

Hi, I am from India. Love your videos. Keep up this good work Sir.

[@setarehseraj5922]

Thank you so much!!!! It was excellent easy complete instruction! I did it so fast, no problem with this video!

[@Марина-э3ф2я]

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]

This makes me very happy

[@dbbjunior]

Thank you for sharing! It really helped me. God bless you!

[@TellaTrix]

Thank you for this video being dotnet developer really help me cool stuff.

[@WithoutCold]

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

[@koosbrandt4499]

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

[@ekinci_io]

Life saver for Mac users!!! Appraciated!!

[@LearningandTechnology]

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]

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

[@georgemiyahara6576]

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

[@LearningandTechnology]

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

[@doobip]

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

[@ИлонаСмоляк]

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

[@fbcreativemedia]

Excellent tutorial. Thanks... Worked right away

[@ariellemcknight323]

I am so thankful for you…truly

[@LearningandTechnology]

@@ariellemcknight323 I’m grateful for YOU! Thank you for watching and taking the time to comment too!

[@alandovi97]

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

[@amanku3318]

This is really helpful, thanks a million

[@MML945]

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]

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]

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

[@JamieYurick]

This man is straight spittin. Very well done.

[@ThatoMetsing-r4g]

Finally, something that worked. 💃 thanks

[@saidguerrero6581]

Extremly usefull, thank you very much!!

[@LearningandTechnology]

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

[@devmaharaj4640]

Super helpful for me, a KISS from my side....

[@gajendrakc813]

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]

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]

@@LearningandTechnology facing same issue

[@imxd1698]

found it, its now under General in settings

[@LearningandTechnology]

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

[@salina.16]

How did you find it? @@imxd1698

[@salihemrebicer8391]

hocam kralsin. greetings from Türkiye

[@LearningandTechnology]

Welcome!

[@salihemrebicer8391]

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

[@ekinci_io]

ayni hisleri tasiyorum!! :D@@salihemrebicer8391

[@selin1789]

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

[@selin1789]

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

[@davidbarefieldjr]

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.

[@Andrea-jl2wc]

you're the man Frank! Thanks a billion!

[@wazzadec16]

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]

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]

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]

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

[@doctorg1]

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

[@LearningandTechnology]

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

[@ahmedadnankhan]

very helpfull...thanks a lot sir

[@setarehseraj5922]

I have a questio tho: how to add database file from mac.

[@LearningandTechnology]

@@setarehseraj5922 once the SQL server is running - you can restore a back-up, run a database setup script, or even start building tables from scratch. If you’re just starting, I recommend you visit the Microsoft site and get a sample AdventureWorks database. Just search “AdventureWorks sample database” and there are quite a few you can grab.

[@AbdiwasacOsman-q7c]

Thanks sir ❤ I can’t believable

[@rashidaoje7386]

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

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

[@amanrayat7215]

i aslo have a same problem @@mrmrhmi3947

[@LordMufasa14]

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

[@lucashartman7735]

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.

[@cookinghistory177]

the option is in general now

[@tibotierenteyn]

@@cookinghistory177 Thanks! Was also looking for it

[@paulh6933]

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]

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.

[@kevinstarofficial]

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

[@LearningandTechnology]

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]

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.

[@emmadotson8521]

How can I be able to access all of my SSMS stuff when I am not at home and cannot connect to the original server???

[@LearningandTechnology]

That would require setting up a network remote access environment. There are some solutions that are easier than others. Generally, if I need a database available remotely then I’ll build that database in a Cloud service.

[@hg-oz5ui]

How much RAM and Storage is needed for this to work well? Im currently looking into getting a Macbook Air or Pro

[@LearningandTechnology]

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

[@monseleon9128]

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

[@LearningandTechnology]

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

[@monseleon9128]

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

[@xx-sn3vt]

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!

[@borgehansen6680]

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]

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

[@happycoin6046]

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

[@LearningandTechnology]

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.

[@HaithamKhaiyat]

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]

It’s the M1 chip issue

[@HaithamKhaiyat]

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

[@user-un4hc]

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]

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

[@user-un4hc]

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

[@Abhishek.sharma499]

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]

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.

[@panugantijayanthkumar6468]

Docker container running and pausing and restarting, not constantly running

[@MarinaKarin-z3t]

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]

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.

[@zerut7264]

Unable to install sql database engine on parallels

[@LearningandTechnology]

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

[@dariaten-vo7ty]

thank you soooo much! it works!)

[@rodrigueze.2261]

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.

[@LearningandTechnology]

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

[@giann411]

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

[@kulyashdahiya2529]

simply best video out there

[@LearningandTechnology]

Thanks!

[@soofiishaa]

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]

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]

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

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

[@gijduvon6379]

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

[@yousefmahmoud-ij9rz]

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

[@NolanPeru-e9e]

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

[@billymcintyre2206]

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.

[@parimashelat1716]

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]

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]

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

[@LearningandTechnology]

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

[@ReinerSaddey]

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]

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.

[@loveleelinz]

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]

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

[@faisalnk4631]

how can i install sql on mac m3

[@LearningandTechnology]

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

[@avinabdas2864]

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

[@LearningandTechnology]

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.

[@shwetaagarwal5465]

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

[@LearningandTechnology]

@@shwetaagarwal5465 yes - you can. I wanted to show SSMS - that required Windows

[@wolfk1ssed334]

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]

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.

[@juanhuenchun8908]

What is the software used in your virtualization of Windows?

[@LearningandTechnology]

@@juanhuenchun8908 I use Parallels. I should have a link in the Description if you are interested in trying it out.

[@emresoylu9661]

Is that possible to install windows server on Mac(M1/m2)?

[@koosbrandt4499]

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]

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

[@yadnyikeebhole1374]

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]

It should be the password for Admin permissions on the Mac

[@borgehansen6680]

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]

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]

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

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

[@aldoussnow9156]

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]

@@aldoussnow9156 the Windows environment was just to run SSMS and it totally optional. You can run Azure Data Studio directly on your Mac

[@aldoussnow9156]

@@LearningandTechnology got it, all figured out. thanks a lot for this tutorial.

[@MichaelRemyXD]

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]

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

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

[@FaustoEdmundoBarreraGómez]

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?

[@dcmg1982]

Ok, but how did you installed the SSL Ssrver management in the windows vm, I always get an error message.

[@JD-ey8hw]

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]

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

[@JD-ey8hw]

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

[@user-sr6nu4dp1y]

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

[@LearningandTechnology]

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.

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

[@daga747]

@@LearningandTechnology Sorry, I does not find the promp, could you help me

[@LearningandTechnology]

@ docs.docker.com/desktop/setup/install/mac-install/

[@rodrigueze.2261]

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

[@LearningandTechnology]

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) kzbin.info/www/bejne/maCZhZ6Jr8hjqZo

[@jeremymoore6052]

You saved my @s$$! I ran into zero issues. Too bad it took me all day to finally find this video.

[@joshuathomasbrooks9450]

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

[@LearningandTechnology]

yes - I put it in the description for the video

[@ipktunay5179]

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

[@ekinci_io]

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

[@4404]

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]

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

[@Enrique_Rodriguez]

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

[@LearningandTechnology]

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

[@ariyabintaku2241]

Thank you so much krub 😚

[@zoevega405]

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?

[@AS-do5st]

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

[@lesliedancy6816]

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.

[@erminoje]

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

[@LearningandTechnology]

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

[@erminoje]

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

[@ang-g5h]

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]

Maybe the connection string you used

[@shalinkaushik3999]

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

[@LearningandTechnology]

I haven’t tested that configuration unfortunately

[@shalinkaushik3999]

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

[@LearningandTechnology]

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

[@happycoin6046]

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

[@huevosrancheros135]

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]

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

[@huevosrancheros135]

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

[@LearningandTechnology]

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

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

[@LearningandTechnology]

@@huevosrancheros135 no - just Azure Data Studio

[@giann411]

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