14,501 questions
SSMS is a pure Windows Application, there is no version for Mac.
But you can use Azure Data Studio on Mac with the same (and some more) features:
Microsoft SQL Management Studio for Mac
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 31%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Jassim Al Rahma
1,616
Reputation points
Hi,
Is there any Mac version for Microsoft SQL Management Studio?
Where can I get it from?
Thanks,
Jassim
SQL Server | Other
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2023-05-04T06:02:18.6933333+00:00 Hi @Jassim Al Rahma
Has your issue been resolved? Please checking in to see if the below suggestions helped. If this answers your query, do click
Accept AnswerandUp-Votefor the same. And, if you have any further query do let us know.Best regards,
Aniya
-
Anonymous
2023-05-05T08:47:03.28+00:00 Hi @Jassim Al Rahma
Did these answers help you? If the answer is useful, please click
Accept Answerto let others with similar questions quickly find answers. If you have any questions, please feel free to let me know.Best regards,
Aniya
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 2%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZN%3C/text%3E%3C/svg%3E)
ÖZGÜN TEKSOY 5 Reputation points2024-02-11T17:10:40.0766667+00:00 Hello, I use azure because I use Mac but I have a problem. How can I open the .bak file in Mac?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 48%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYS%3C/text%3E%3C/svg%3E)
Yong Shao 0 Reputation points2024-02-28T22:04:44.5033333+00:00 I installed Azure data studio on my mac, but cannot connect to MS Fabric lakehouse SQL endpoint. Anyone knows how? thank you in advance
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 9%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Deny Dermawan Sabri 0 Reputation points2024-06-13T04:02:16.62+00:00 How to draw erd based on implemented data structure using azure data studio as ssms do?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 30%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Hitesh81 1 Reputation point2024-07-04T09:03:49.37+00:00 Azure Data Studio is not comparable to SSMS
MS is blocking all Data management /scripts generation etc on Azure Data Studio
SSMS runs only on windows, I am not sure why they cant build one for Mac and 64-bit these days.
dacpac/bacpac might be good but they are flaky and not suitable.
or atleast they should release extension with all features of SSMS to Azure Data Studio
Sign in to comment
Accepted answer
-
Olaf Helper 47,441 Reputation points2023-04-27T10:17:23.64+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 97%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Akash kr. sinha 0 Reputation points2024-03-21T09:22:19.9066667+00:00 Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 40 - Could not open a connection to SQL Server)
for mac m2 chip
i am unable to fix this error, help me
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 80%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVE%3C/text%3E%3C/svg%3E)
Vlček Josef 0 Reputation points2025-02-25T10:16:15.6833333+00:00 If ADS or VSC have same functionality as SSMS, how can I run tasks -> generate script. I use it a lot on SSMS, but cant find it in ADS or VSC. For ADS, there is a plugin for that, but it seems only for Windows.
So is there a way to generate insert scripts with data in ADS or VSC?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 67%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
Jarle F 0 Reputation points2025-03-26T11:01:40.91+00:00 And now? Microsoft is retiring Azure Data Studio next year and claiming users should use an inferior product like VS Code with more advanced features only being available in SSMS.
Sign in to comment -
3 additional answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RahulRandive 10,486 Reputation points Volunteer Moderator2023-04-27T11:38:49.3866667+00:00 Thanks for your question.
As per Microsoft document, https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16
SSMS is available only as a 32-bit application for Windows. If you need a tool that runs on operating systems other than Windows, we recommend Azure Data Studio. Azure Data Studio is a cross-platform tool that runs on macOS, Linux, and Windows. For details, see Azure Data Studio.
Please let us know if you need any additional information.
Thank you.
-
Jassim Al Rahma 1,616 Reputation points
2023-04-27T14:10:25.3433333+00:00 I tried the Azure Data Studio but when I create a connection it's asking me to Create a New firewall rule and then when I click on Add an Account I get the following error
-
RahulRandive 10,486 Reputation points Volunteer Moderator
2023-04-27T14:56:11.9033333+00:00 The account which you are using to login has multiple tenants in Azure?
Can you please try login with SQL Server admin account.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 76%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Basem Mahmoud 0 Reputation points2023-08-15T09:39:40.8266667+00:00 Azure data studio doesn't have all features as Export database as SSMS.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 77%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Jeff Tucker 90 Reputation points2025-04-22T13:17:37.1233333+00:00 I know this is an old post, but just commenting that Azure Data Studio is now retiring, and I believe the suggest is to use VS Code instead. As of right now though, the VS Code SQL connector is a bit buggy. Hopefully that gets improved soon!
Sign in to comment -
-
Anonymous
2023-04-28T06:06:56.1533333+00:00 Hi @Jassim Al Rahma
You can check this link to see the operating systems currently supported by SSMS: https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16#ssms-system-requirements.
As Olaf and Rahul say, if you need tools that run on operating systems other than Windows, we recommend Azure Data Studio.
If these answers are helpful, please click
Accept AnswerandUp-Votefor the same. If you have any questions, please feel free to let us know.Best regards,
Aniya
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 25%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Don Price 0 Reputation points2025-05-05T08:35:37.5133333+00:00 Hi,
As mentioned earlier, Microsoft SQL Server Management Studio (SSMS) is officially available only for Windows, and unfortunately, there is no native Mac version of SSMS.
However, if you're using a Mac and need to manage SQL Server databases, you have a few good alternatives:
- Azure Data Studio – A cross-platform tool from Microsoft that works on macOS and supports SQL Server.
dbForge Studio for SQL Server via virtualization – You can run the Windows version of dbForge Studio for SQL Server on a Mac using virtualization tools like Parallels or VMware.
Devart has a detailed guide on how to install and work with SQL Server on a Mac, including using dbForge Studio: https://www.devart.com/dbforge/sql/studio/install-sql-server-on-mac.html