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)