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

  Рет қаралды 54,124

Learning and Technology with Frank

Learning and Technology with Frank

Күн бұрын

Пікірлер: 255
@LearningandTechnology
@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
@clarksontejiri4630 12 күн бұрын
what do I do when the password does not work
@olivesierra3521
@olivesierra3521 11 ай бұрын
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
@dollins8297 6 ай бұрын
My IP address won't connect for some reason
@dollins8297
@dollins8297 6 ай бұрын
I got it:)
@markslima1557
@markslima1557 8 ай бұрын
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
@giann411 3 ай бұрын
can you use visual studio code 2022 and work with the data bases from the docker sql? thank u sm!!
@markslima1557
@markslima1557 3 ай бұрын
@@giann411 yes absolutely got docker working with sql server
@namlongpham5624
@namlongpham5624 9 ай бұрын
2 days of struggling and finally your solution worked. Thank you very much
@anhnguyenquoc6679
@anhnguyenquoc6679 5 ай бұрын
1 month of struggling and finally your solution worked. Thank you very much
@anhnguyenquoc6679
@anhnguyenquoc6679 5 ай бұрын
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?
@phoenixshed-okara5415
@phoenixshed-okara5415 Ай бұрын
This was super helpful!!!...now i can continue my data analytics training on my mac
@SmithIRL
@SmithIRL 22 күн бұрын
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 :)
@xx-sn3vt
@xx-sn3vt 6 ай бұрын
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!
@Марина-э3ф2я
@Марина-э3ф2я 8 ай бұрын
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
@LearningandTechnology 8 ай бұрын
This makes me very happy
@Ray-wd8fc
@Ray-wd8fc 6 ай бұрын
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
@LearningandTechnology 6 ай бұрын
I often have students use the Import/Export wizard for simple Excel (csv) files to SQL That would be a good video…
@lucashartman7735
@lucashartman7735 12 күн бұрын
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
@cookinghistory177 10 күн бұрын
the option is in general now
@sehassenhiru
@sehassenhiru 7 ай бұрын
Thank you very much After days of Struggling I managed to install
@rodrigueze.2261
@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
@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)
@fbcreativemedia
@fbcreativemedia Ай бұрын
Excellent tutorial. Thanks... Worked right away
@davidbarefieldjr
@davidbarefieldjr 7 ай бұрын
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.
@aishausman1575
@aishausman1575 7 ай бұрын
IT WORKED! OMG I've been struggling all day thank you
@LearningandTechnology
@LearningandTechnology 7 ай бұрын
Hooray!
@aishausman1575
@aishausman1575 7 ай бұрын
@@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.
@ekinci_io
@ekinci_io 9 ай бұрын
Life saver for Mac users!!! Appraciated!!
@LearningandTechnology
@LearningandTechnology 9 ай бұрын
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
@ekinci_io 9 ай бұрын
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
@koosbrandt4499
@koosbrandt4499 Жыл бұрын
Much appreciated because this is just what I needed. Clear and helpfull.
@gajendrakc813
@gajendrakc813 8 ай бұрын
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
@LearningandTechnology 8 ай бұрын
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
@imxd1698 8 ай бұрын
@@LearningandTechnology facing same issue
@imxd1698
@imxd1698 8 ай бұрын
found it, its now under General in settings
@LearningandTechnology
@LearningandTechnology 8 ай бұрын
@@imxd1698Fantastic! Thanks - I’ll pin this comment to make sure every knows
@salenajsh6891
@salenajsh6891 8 ай бұрын
How did you find it? @@imxd1698
@WithoutCold
@WithoutCold 6 ай бұрын
Great tutorial! Thank you very much! I'm able to use SQL on my Macbook now :)
@doobip
@doobip 6 ай бұрын
Thank You. I used to search for resolution for a long time.
@MarinaKarin-z3t
@MarinaKarin-z3t 10 ай бұрын
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
@LearningandTechnology 10 ай бұрын
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.
@wazzadec16
@wazzadec16 8 ай бұрын
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
@LearningandTechnology 8 ай бұрын
It should be persistent and remain in place until deleted. There should be a way to save when you shutdown? Glad it was helpful!
@rashidaoje7386
@rashidaoje7386 11 ай бұрын
@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
@mrmrhmi3947 8 ай бұрын
i have the same problem, if you have already solved it can you help me?
@amanrayat7215
@amanrayat7215 8 ай бұрын
i aslo have a same problem @@mrmrhmi3947
@koosbrandt4499
@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
@LearningandTechnology 11 ай бұрын
I don’t have any SSIS content here on KZbin - at least not quite yet :)
@borgehansen6680
@borgehansen6680 11 ай бұрын
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
@LearningandTechnology 11 ай бұрын
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
@borgehansen6680 11 ай бұрын
@@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
@LearningandTechnology 11 ай бұрын
@@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!
@ThatoMetsing-r4g
@ThatoMetsing-r4g Ай бұрын
Finally, something that worked. 💃 thanks
@user-un4hc
@user-un4hc 9 ай бұрын
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
@LearningandTechnology 9 ай бұрын
The Intel Macs are much easier! You can install Windows Server and SQL in a VM. They are x86 (Intel) programs.
@user-un4hc
@user-un4hc 9 ай бұрын
@@LearningandTechnology Thanks for the reply Mr. Frank This means I have to download the Windows environment and download Sql Right inside it, right?
@amanku3318
@amanku3318 5 ай бұрын
This is really helpful, thanks a million
@monseleon9128
@monseleon9128 2 ай бұрын
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
@LearningandTechnology 2 ай бұрын
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
@monseleon9128 2 ай бұрын
@@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
@soofiishaa
@soofiishaa 10 ай бұрын
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
@LearningandTechnology 10 ай бұрын
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
@soofiishaa 10 ай бұрын
@@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
@LearningandTechnology 10 ай бұрын
@@soofiishaa ah! Yes - you can install them in a single Docker
@giann411
@giann411 3 ай бұрын
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!!
@ИлонаСмоляк
@ИлонаСмоляк 8 ай бұрын
Thank you very much!!! It is really very useful, thank you for your work and video)
@alandovi97
@alandovi97 4 ай бұрын
Thanks a lot for your help. It worked for me.
@billymcintyre2206
@billymcintyre2206 5 ай бұрын
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.
@MML945
@MML945 8 ай бұрын
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
@LearningandTechnology 8 ай бұрын
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
@MML945 8 ай бұрын
I understand you, but please let me know when you do it.@@LearningandTechnology
@georgemiyahara6576
@georgemiyahara6576 11 ай бұрын
Brilliant! I could finally set-up this bad boy! I appreciate you so much Frank!
@LearningandTechnology
@LearningandTechnology 11 ай бұрын
Excellent! Thank you for watching and commenting - have fun with data!
@doctorg1
@doctorg1 5 ай бұрын
You are the best, mssql running. but How can I restore or attach an existent database?
@LearningandTechnology
@LearningandTechnology 5 ай бұрын
Once installed - you can connect using a client tool (SSMS, Data studio, etc) and restore that way.
@shaliniabcd
@shaliniabcd 9 ай бұрын
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
@LearningandTechnology 9 ай бұрын
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.
@paulh6933
@paulh6933 11 ай бұрын
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
@LearningandTechnology 11 ай бұрын
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.
@simphiwewalaza3680
@simphiwewalaza3680 3 ай бұрын
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
@loveleelinz
@loveleelinz 11 ай бұрын
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
@LearningandTechnology 11 ай бұрын
If it's an Intel chip, then you don't actually need Docker - you can just create a Virtual Machine and install SQL.
@NolanPeru-e9e
@NolanPeru-e9e 2 ай бұрын
my mac is intel core, do i still need to go through the same steps or its different, Thanks
@JamieYurick
@JamieYurick 9 ай бұрын
This man is straight spittin. Very well done.
@ReinerSaddey
@ReinerSaddey 7 ай бұрын
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
@LearningandTechnology 7 ай бұрын
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.
@zoevega405
@zoevega405 4 ай бұрын
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?
@MichaelRemyXD
@MichaelRemyXD 8 ай бұрын
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
@LearningandTechnology 8 ай бұрын
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) 😀
@HaithamKhaiyat
@HaithamKhaiyat 6 ай бұрын
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
@LearningandTechnology 6 ай бұрын
It’s the M1 chip issue
@HaithamKhaiyat
@HaithamKhaiyat 6 ай бұрын
@@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.
@Andrea-jl2wc
@Andrea-jl2wc 8 ай бұрын
you're the man Frank! Thanks a billion!
@CarvalhoAntonio
@CarvalhoAntonio 11 ай бұрын
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
@lekebello2422
@lekebello2422 9 ай бұрын
Hello, pls I have a very urgent question. Can something like this help me install a “Microsoft 2019 sever on my M1 Mac”
@ahmedadnankhan
@ahmedadnankhan 5 ай бұрын
very helpfull...thanks a lot sir
@FaustoEdmundoBarreraGómez
@FaustoEdmundoBarreraGómez 7 ай бұрын
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?
@borgehansen6680
@borgehansen6680 8 ай бұрын
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
@LearningandTechnology 8 ай бұрын
I’m wondering if there is a firewall running on the Mac that’s blocking access?
@happycoin6046
@happycoin6046 8 ай бұрын
@@LearningandTechnology Im having the same problem. Even went to network -> firewall and disabled it, and it still don't work :,(
@LearningandTechnology
@LearningandTechnology 8 ай бұрын
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.
@ipktunay5179
@ipktunay5179 9 ай бұрын
Hello Frank, I am not seeing the Rosetta feature too. I have a m1 chip .Any suggestions on what to do?
@ekinci_io
@ekinci_io 9 ай бұрын
Hey! It is on the general settings and already selected. Go ahead, it should work!
@kevinstarofficial
@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
@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
@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.
@avinabdas2864
@avinabdas2864 4 ай бұрын
From where you got the username? it is throwing login error for "sa" as username
@LearningandTechnology
@LearningandTechnology 4 ай бұрын
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.
@rodrigueze.2261
@rodrigueze.2261 Жыл бұрын
Hi Frank, I have a parallels 19. Can you you explain how can I install sql server, please.
@LearningandTechnology
@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
@lesliedancy6816
@lesliedancy6816 3 ай бұрын
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.
@saidguerrero6581
@saidguerrero6581 8 ай бұрын
Extremly usefull, thank you very much!!
@LearningandTechnology
@LearningandTechnology 8 ай бұрын
Glad it helped! Thank you for commenting too! Appreciate it!
@juanhuenchun8908
@juanhuenchun8908 2 ай бұрын
What is the software used in your virtualization of Windows?
@LearningandTechnology
@LearningandTechnology 2 ай бұрын
@@juanhuenchun8908 I use Parallels. I should have a link in the Description if you are interested in trying it out.
@Cinccinatti_C3
@Cinccinatti_C3 9 ай бұрын
Is their anyway to run windows 11 and install RSAT tools for administrators?
@BelloUsman-f8r
@BelloUsman-f8r 3 ай бұрын
Hello Mr. Frank please where do i find the command prompt i will put in the Terminal
@LearningandTechnology
@LearningandTechnology 3 ай бұрын
I’ve linked it in the description for the video - can copy and paste it - just change the password to something you like
@kulyashdahiya2529
@kulyashdahiya2529 2 ай бұрын
simply best video out there
@LearningandTechnology
@LearningandTechnology 2 ай бұрын
Thanks!
@LêĐăngNguyễn-f9o
@LêĐăngNguyễn-f9o 19 күн бұрын
You save my life
@dariaten-vo7ty
@dariaten-vo7ty 7 ай бұрын
thank you soooo much! it works!)
@user-sr6nu4dp1y
@user-sr6nu4dp1y 5 ай бұрын
Hi, can we use SSRS on an M2 Mac using Parallels? Thanks!
@LearningandTechnology
@LearningandTechnology 5 ай бұрын
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.
@DanyloBodnar
@DanyloBodnar 10 ай бұрын
Is full-text available for this sql instance?
@shwetaagarwal5465
@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
@LearningandTechnology Ай бұрын
@@shwetaagarwal5465 yes - you can. I wanted to show SSMS - that required Windows
@aldoussnow9156
@aldoussnow9156 2 ай бұрын
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
@LearningandTechnology 2 ай бұрын
@@aldoussnow9156 the Windows environment was just to run SSMS and it totally optional. You can run Azure Data Studio directly on your Mac
@aldoussnow9156
@aldoussnow9156 2 ай бұрын
@@LearningandTechnology got it, all figured out. thanks a lot for this tutorial.
@LordMufasa14
@LordMufasa14 6 ай бұрын
Worked for me using it for school. I'll update if it doesn't work out.
@salihemrebicer8391
@salihemrebicer8391 10 ай бұрын
hocam kralsin. greetings from Türkiye
@LearningandTechnology
@LearningandTechnology 10 ай бұрын
Welcome!
@salihemrebicer8391
@salihemrebicer8391 9 ай бұрын
@@idrisagiragac 😂 konuyla alakalı gezdiğim 10. video, sadece bu hocam doğru adımları veriyor. 🤟🏼
@ekinci_io
@ekinci_io 9 ай бұрын
ayni hisleri tasiyorum!! :D@@salihemrebicer8391
@selin1789
@selin1789 8 ай бұрын
@@salihemrebicer8391m3 mac için de uygun mudur tekniği?
@selin1789
@selin1789 8 ай бұрын
@@salihemrebicer8391 m3 de de aynu şekilde indirilir mi? Bir de harddisk e yüklenilerek kullanılabilir mi?
@yadnyikeebhole1374
@yadnyikeebhole1374 4 ай бұрын
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
@LearningandTechnology 4 ай бұрын
It should be the password for Admin permissions on the Mac
@parimashelat1716
@parimashelat1716 8 ай бұрын
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
@LearningandTechnology 8 ай бұрын
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
@parimashelat1716 8 ай бұрын
@@LearningandTechnology after the terminal step, I don’t see the application in the container
@LearningandTechnology
@LearningandTechnology 8 ай бұрын
@@parimashelat1716 hmmm - they may have changed where the Rosetta check mark is - look under settings/preferences
@AS-do5st
@AS-do5st 3 ай бұрын
Hi I have problem with login and Password. With login I have to use? Still have error 18456
@panugantijayanthkumar6468
@panugantijayanthkumar6468 Ай бұрын
Docker container running and pausing and restarting, not constantly running
@HobbitPipeSmoke
@HobbitPipeSmoke 8 ай бұрын
I got this error in Terminal : ///: Any help? docker: Error response from daemon: received unexpected HTTP status: 503 Service Unavailable. See 'docker run --help'.
@wolfk1ssed334
@wolfk1ssed334 5 ай бұрын
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
@LearningandTechnology 5 ай бұрын
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.
@giann411
@giann411 3 ай бұрын
How can i find files from sql, im trying to find a restored db bak but it wont appear in files
@erminoje
@erminoje 8 ай бұрын
What's the point of installing the server engine in Docker and the management studio in parallels? Why not install both in parallels?
@LearningandTechnology
@LearningandTechnology 8 ай бұрын
You can’t install it in a VM if you have an M1/2 chip.
@erminoje
@erminoje 8 ай бұрын
@@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.
@huevosrancheros135
@huevosrancheros135 8 ай бұрын
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
@LearningandTechnology 8 ай бұрын
It would work without Internet once it’s set up. The container is local to the Mac Mini.
@huevosrancheros135
@huevosrancheros135 8 ай бұрын
@@LearningandTechnology I guess I'm more asking is this possible without being connected to the local network?
@LearningandTechnology
@LearningandTechnology 8 ай бұрын
@@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
@huevosrancheros135 8 ай бұрын
@@LearningandTechnology but then for example would I have to run visual studio on the macOS?
@LearningandTechnology
@LearningandTechnology 8 ай бұрын
@@huevosrancheros135 no - just Azure Data Studio
@gijduvon6379
@gijduvon6379 9 ай бұрын
Docker 14.26.1 doesn't have "Use Rosetta" option anymore
@yousefmahmoud-ij9rz
@yousefmahmoud-ij9rz 8 ай бұрын
You will find it in settings > general I think they moved there since it is not a “features in development” anymore
@ariyabintaku2241
@ariyabintaku2241 11 ай бұрын
Thank you so much krub 😚
@ang-g5h
@ang-g5h 8 ай бұрын
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
@MichaelRemyXD 8 ай бұрын
Maybe the connection string you used
@asedaog
@asedaog 8 ай бұрын
Thank you so much
@JD-ey8hw
@JD-ey8hw 8 ай бұрын
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
@LearningandTechnology 8 ай бұрын
Azure Data Studio will work across multiple architectures - it may be the better option
@JD-ey8hw
@JD-ey8hw 8 ай бұрын
@@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.
@shalinkaushik3999
@shalinkaushik3999 8 ай бұрын
Does this method will work with VMwareFusion 13 on Windows 11 arm? thanks
@LearningandTechnology
@LearningandTechnology 8 ай бұрын
I haven’t tested that configuration unfortunately
@shalinkaushik3999
@shalinkaushik3999 8 ай бұрын
@@LearningandTechnology thanks for the response I did tested above config on the VMwareFusion version 13 with windows 11 arm and it worked successfully.
@LearningandTechnology
@LearningandTechnology 8 ай бұрын
@@shalinkaushik3999 awesome! Thank you for coming back to let everyone know - much appreciated! Great work!
@happycoin6046
@happycoin6046 8 ай бұрын
@@shalinkaushik3999 Im using VMwareFusion as well, but I can't connect to my Mac IP, is this something you encountered as well?
@robeatz5409
@robeatz5409 9 ай бұрын
is there anyway to use it using Azure
@LearningandTechnology
@LearningandTechnology 9 ай бұрын
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 kzbin.info/www/bejne/paeVaKihpbyamrM
@robeatz5409
@robeatz5409 9 ай бұрын
I am sorry I meant to say Azure data studio along with docker! @@LearningandTechnology
@rema8073
@rema8073 11 ай бұрын
im not getting the rosetta feature on docker why??
@LearningandTechnology
@LearningandTechnology 11 ай бұрын
Did you click on the settings? Top right?
@rema8073
@rema8073 11 ай бұрын
yes the option is not even showing up in the settings@@LearningandTechnology
@LearningandTechnology
@LearningandTechnology 11 ай бұрын
@@rema8073 are you using an M1/M2 Mac?
@rema8073
@rema8073 11 ай бұрын
yes m2 mac@@LearningandTechnology
@rema8073
@rema8073 11 ай бұрын
everything else downloaded and worked but i just dont have that feature@@LearningandTechnology
@joshuathomasbrooks9450
@joshuathomasbrooks9450 3 ай бұрын
Is there somewhere or somehow to copy the script for terminal?
@LearningandTechnology
@LearningandTechnology 3 ай бұрын
yes - I put it in the description for the video
@AllThingsHealing02
@AllThingsHealing02 7 ай бұрын
Thank you sooooo much!!!!!
@bingchillinhuehue
@bingchillinhuehue 8 ай бұрын
how did you get the virtual window 11 tab?
@bingchillinhuehue
@bingchillinhuehue 8 ай бұрын
its using parallels, but you need to pay subscription for it
@saikrishnak0303
@saikrishnak0303 7 ай бұрын
Is parellels free to use? I see only a 14 day trial.
@LearningandTechnology
@LearningandTechnology 7 ай бұрын
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.
@ArayaMsQ
@ArayaMsQ Жыл бұрын
Thanks !
@minhnguyenduy285
@minhnguyenduy285 7 ай бұрын
thank you so much!!!
@adeelshahid3485
@adeelshahid3485 7 ай бұрын
In SQl management server i am stuck at username. What should i put there?
@thinhdrake7250
@thinhdrake7250 7 ай бұрын
metoo
@shannabanna1
@shannabanna1 8 ай бұрын
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
@LearningandTechnology 8 ай бұрын
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 kzbin.info/www/bejne/eqfaZZqfd7mNrZI
@harrisra4944
@harrisra4944 4 ай бұрын
Looks like he used "parralels" which allows you to run windows.
@andricknatividad7526
@andricknatividad7526 6 ай бұрын
Does it work in m3?
@Enrique_Rodriguez
@Enrique_Rodriguez 6 ай бұрын
why does the login username needs to be "sa"?
@LearningandTechnology
@LearningandTechnology 6 ай бұрын
It doesn't really - sa is just the SQL default Admin account.
@DutchThought
@DutchThought 11 ай бұрын
Thank you!!
Micro-learning in MINUTES with AI
16:41
Learning and Technology with Frank
Рет қаралды 1 М.
How To Install SQL Server on Mac (M1 | M2 | M3) (2024)
16:51
ProgrammingKnowledge
Рет қаралды 66 М.
Un coup venu de l’espace 😂😂😂
00:19
Nicocapone
Рет қаралды 10 МЛН
Крутой фокус + секрет! #shorts
00:10
Роман Magic
Рет қаралды 40 МЛН
Every parent is like this ❤️💚💚💜💙
00:10
Like Asiya
Рет қаралды 26 МЛН
Apple Silicon and .Net Devs BIGGEST struggle, SOLVED!
14:29
Alex Ziskind
Рет қаралды 30 М.
How To Install SQL Server on Mac M1 & M2 | Latest for 2022
12:13
Data With Dominic
Рет қаралды 212 М.
Macbook'a SQL Server Yüklemek - Docker Kullanarak!!
13:12
Machineiva
Рет қаралды 28 М.
How to Set Up SQL Server with Docker (2024)
6:00
Database Star
Рет қаралды 2,1 М.
How to Use VS Code to Run SQL on a Database
15:06
Database Star
Рет қаралды 288 М.
SQL Tutorial for Beginners
44:57
Kevin Stratvert
Рет қаралды 2,2 МЛН
Mac vs PC for Data Science (SPOILER: Don't get a Mac...)
9:36
Luke Barousse
Рет қаралды 218 М.