I am able to connect to the mssql server database and choose the table that contains the spatial data. However, as soon as the layer is added, I get the 'crash dumped' error with a message saying
"minidump written to C:"

The database is hosted on azure

On a smaller database, I can see the nodes/location display briefly before the crash occurs.

I have tested the issue on a much smaller database that contained 1 row/entry and the crash still occurs but it's usually after I add another layer (e.g. open streetmap layer)