I have used Azure Data studio in the past to manage and run queries on remote MS SQL Server using my Mac. This open source free software was my choice until I did not have to use MSSQL Server anymore.
Azure Data Studio is a free, light-weight tool that runs on Windows macOS, and Linux, for managing SQL Server, Azure SQL Database, and Azure Synapse Analytics.
docs.microsoft.com
I have also sued a third party app before that which may be expensive but may be an option
Compare the best SQL Server software for Mac of 2025 for your business. Find the highest rated SQL Server software for Mac pricing, reviews, free demos, trials, and more.
Azure Data Studio (Microsoft), DBVisualizer, DBeaver, Jetbrains DataGrip (more for development though) just from the top of my head.
What you’ll not find with any of these though is the same level of deep integration with Sql Server that SSMS gives you. Some (like Azure Data Studio and DBVisualizer) do give a level of access to Sql Agent, Azure Data Studio has a raft of plugins for other bits of functionality that SSMS supports out the box.
However nothing but nothing comes close sadly to SSMS on Windows for the deep integration.
That said, I find that I can now do ~90% of my daily work outside Windows now using any one of the three - and usually I can do more as well as the other tools do provide features that SSMS do not.