I managed to get SQL Server installed without issue using the script (https://github.com/jimm98y/MSSQLEXPRESS-M1-Install)
This all works fine except I can't get Visual Studio to compare the Live and Local database.
Code:
TITLE: Error
------------------------------
The type initializer for 'Microsoft.Data.SqlClient.TdsParser' threw an exception. (Microsoft.Data.SqlClient)
------------------------------
ADDITIONAL INFORMATION:
The type initializer for 'Microsoft.Data.SqlClient.SNILoadHandle' threw an exception. (Microsoft.Data.SqlClient)
------------------------------
An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) (Microsoft.Data.SqlClient)
------------------------------
BUTTONS:
OK
------------------------------