I have installed the x64 SQL Server 2008 R2 Express with default settings and run MBSA 2.3 Microsoft analizer (using default settings too). Tried on clean Windows 8 installation (not 8.1) and Windows 7 with the same result. It shows three SQL Server instances:
- SQLEXPRESS (32-bit)
I don't understand why there are three of them (SQL Server Configuration Manager shows only one). For the first, authentication mode is Windows, for the rest two - mixed. Here is the question about such multiple instances was asked and the answer is that "MSSQL10.TEST_DB is the instance ID for the SQL Server Database Engine of the instance, TEST_DB", so in my case, it seems that MSSQL10_50.SQLEXPRESS is the instance ID for SQL Server Database Engine of the SQLEXPRESS instance.
I have two questions:
How can it be that SQL Server Database Engine instance has different authentication mode than corresponding SQL Server Instance?
Why 32-bit instance reported although I installed only 64-bit version?
Also, this question seems to be related to this issue, but there is no answer :(.
UPD: corrected the question, now it should be clearer
UPD2: SQL Server 2008 Discovery Report:
UPD3: MBSA Report screenshots:
UPD4: MBSA Report for SQLEXPRESS (32-bit) instance: