Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #997

Re: Problem Reinstalling SQL Server Express 2008 under Windows 7

Show all headers | View raw

On Thu, 19 Apr 2012 22:46:03 +0200, Erland Sommarskog
<esquel@sommarskog.se> 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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Problem Reinstalling SQL Server Express 2008 under Windows 7 Gene Wirchenko <genew@ocis.net> - 2012-04-18 14:54 -0700
  Re: Problem Reinstalling SQL Server Express 2008 under Windows 7 Big Steel <YouCanRun@ButYouCannotHide.com> - 2012-04-18 21:10 -0400
    Re: Problem Reinstalling SQL Server Express 2008 under Windows 7 Gene Wirchenko <genew@ocis.net> - 2012-04-18 18:20 -0700
      Re: Problem Reinstalling SQL Server Express 2008 under Windows 7 Char Jackson <none@none.invalid> - 2012-04-18 22:06 -0500
  Re: Problem Reinstalling SQL Server Express 2008 under Windows 7 Erland Sommarskog <esquel@sommarskog.se> - 2012-04-19 22:46 +0200
    Re: Problem Reinstalling SQL Server Express 2008 under Windows 7 Gene Wirchenko <genew@ocis.net> - 2012-04-19 20:18 -0700
      Re: Problem Reinstalling SQL Server Express 2008 under Windows 7 Erland Sommarskog <esquel@sommarskog.se> - 2012-04-20 09:17 +0200
    Re: Problem Reinstalling SQL Server Express 2008 under Windows 7 Gene Wirchenko <genew@ocis.net> - 2012-04-19 22:29 -0700
      Re: Problem Reinstalling SQL Server Express 2008 under Windows 7 Erland Sommarskog <esquel@sommarskog.se> - 2012-04-20 09:22 +0200
        Re: Problem Reinstalling SQL Server Express 2008 under Windows 7 Gene Wirchenko <genew@ocis.net> - 2012-04-20 08:18 -0700
          Re: Problem Reinstalling SQL Server Express 2008 under Windows 7 Erland Sommarskog <esquel@sommarskog.se> - 2012-04-21 00:20 +0200

csiph-web