From: genew@ocis.net   
      
   On Thu, 19 Apr 2012 22:46:03 +0200, Erland Sommarskog   
    wrote:   
      
   >Gene Wirchenko (genew@ocis.net) writes:   
   >>      I installed SQL Server Express 2008 on it.  I also installed SQL   
   >> Server Denali.  The Denali installation ended up replacing my SSMS   
   >> with the Denali one.  Because of some differences in the behaviour of   
   >> the SSMS, I wanted 2008's SSMS back.   
   >   
   >No, installing SQL 2012 does not replace SSMS 2008. I have both versions   
      
        I was specifically referring to Denali.  It did overwrite (or at   
   least, override) SSMS 2008.   
      
   >installed my system. (However, naîvely accepting "do you want to transfer   
   >your settings for SSMS 2008 to SQL Server 2012, some of the settings   
   >were transferred in the other direction.) Mind you, this was developer   
   >edition, not Express, but I fail to see that should make a difference.   
   >   
   >>      I then installed SQL Server 2008 Express.  The installation was   
   >> successful.  Well, that is what I was told.  There was no SSMS!   
   >   
   >A plain installation of SQL 2008 Express does not include SSMS. You   
   >need SQL 2008 Express with Advanced Services, as I recall.   
      
        I just spent a couple hours trying to sort out the versions.  I   
   think I got it, but complications did ensue.   
      
        I am running Windows 7 on my test box so I went with the 64-bit   
   versions.  The files I settled on were:   
             SQLEXPRADV_x64_ENU.exe   (version 10.00.1600.22)   
             SQLEXPR_x64_ENU.exe      (version 10.00.5500.00) (SP3)   
             SQLManagementStudio_x64_ENU.exe   
   I was going to install them in that order.   
      
        The first one throws a compatibility error.  On previous runs, I   
   have gotten two errors: 1) an error in the menu about an unhandled   
   exception and 2) near the end of the installation, I get:   
             Operation fialed with 0x8007000B   
             An attempt was made to load a program with an incorrect   
   format.   
   but the installation appears to succeed.  (Whether it actually does, I   
   do not know.  It does run.)  I aborted on this file after getting the   
   compatibility error.   
      
        I installed SP3 and had no SSMS as you indicated.   
      
        I then installed the last program.  It threw a compatibility   
   error, but I continued.   
      
        I now have a 64-bit SSE 2008 installation which apparently works,   
   but does it really?   
      
        Am I using the correct versions of files?  Are there versions   
   that do not throw compatibility errors?   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)