Path: csiph.com!usenet.pasdenom.info!news.albasani.net!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: comp.databases.ms-sqlserver,microsoft.public.sqlserver.programming,alt.windows7.general Subject: Re: Problem Reinstalling SQL Server Express 2008 under Windows 7 Followup-To: comp.databases.ms-sqlserver Date: Thu, 19 Apr 2012 22:46:03 +0200 Organization: Erland Sommarskog Lines: 26 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 8bit Injection-Info: mx04.eternal-september.org; posting-host="nBFDv6s1VJQDuF1w6hpX2A"; logging-data="19040"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18amkVK+0W9HaecNLA0oZOf" User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) Cancel-Lock: sha1:j8glvX1gFhuTPYMLxKSAephWcY4= Xref: csiph.com comp.databases.ms-sqlserver:993 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 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. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx