Is it possible for me to connect to a MSSQL database server with MySQL Workbench?
You cannot use MySQL Workbench as a Microsoft SQL Server client.
But technically speaking, yes, you can connect to a Microsoft SQL Server database using ODBC if you are using the database migration wizard.
Source: https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-connection.html