3

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:

  • MSSQL10_50.SQLEXPRESS
  • SQLEXPRESS
  • 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:

  1. How can it be that SQL Server Database Engine instance has different authentication mode than corresponding SQL Server Instance?

  2. 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:enter image description here

UPD3: MBSA Report screenshots:enter image description hereenter image description here

UPD4: MBSA Report for SQLEXPRESS (32-bit) instance: enter image description here

  • Sorry, but your question is very unclear - the SQL Server installation process creates a single instance. It sounds like you have multiple instances installed, and our expecting them to magically be setup the same? – Max Vernon Mar 10 '15 at 13:07
  • @MaxVernon: Yes, it creates a single instance. SQl Server Configuration Manager shows only one instance too. In fact, the only thing that shows more than one instance is MBSA and I don't understand why. – matumba Mar 10 '15 at 13:15
  • @MaxVernon: I am expecting to see only one instance, but there are three. Two of them explained in thread I'm refering too (although I don't clearly understand the answer). If I got it right, MSSQL10_50.SQLEXPRESS correspond to DB Engine, and SQLEXPRESS to the SQL Server instance itself (which is something more than just DB Engine?). And origin of the third one I do not understand completely. – matumba Mar 10 '15 at 13:34
  • A SQL server has different auth modes because you made it so asking why to us doesn't makes sense. If it is showing 32 bit instance how could we tell you, may be somebody installed and you were not aware. – Shanky Mar 10 '15 at 13:34
  • 2
    You are correct, you only have single instance of SQL server express. Now what other help you need ? – Shanky Mar 10 '15 at 14:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.