Like an idiot, I downloaded and upgraded my 2005 SQL Server Express to the
2008 version, without first checking the newsgroups to look for problems I
might encounter. Well, I now have a SQL Server Express 2008 database, but
no Management Studio.

I'vr run the SQL Server Installation Center, and have been through about
every option combination I can think of, but cannot find an option to
install the SSMS. I've checked the news groups, but even the couple of
posts that I've seen have not provided specific instructions.

Would really appreciate some help here, as I was hoping to work on my
database this weekend.

Thanks.

I have yet to see a standalone installer for Management Studio Express 2008,
like the one we have for the 2005 version. So in the meantime, you'll need
to get a version of Express that includes the tools. I haven't tried this
out to see if you can install Management Studio Express without installing
another instance. You could try that or you could just remove the instance
you installed while waiting for the new edition to download.

Express with Advanced Services:

http://www.microsoft.com/downloads/details.aspx?FamilyId=B5D1B8C3-FDA5-4508-
B0D0-1311D670E336

Express with Tools:

http://www.microsoft.com/downloads/details.aspx?FamilyId=7522A683-4CB2-454E-
B908-E805E9BD4E28

On 9/6/08 12:52 PM, in article erwuTGEEJHA.680@TK2MSFTNGP03.phx.gbl, "Dale
Fye" nospam.com> wrote:

Aaron,

Express with Advanced Services is the one I used. I'm sure that somewhere
in the Installation Center, there is a way to activate/install the SSMS, but
I cannot find it.

I cannot afford to uninstall SQL Server 2008, since I did the upgraded from
2005, and my 2005 database is no longer available.

"Aaron Bertrand [SQL Server MVP]" wrote in message
news:C4E83662.11B70%%ten.xoc@dnartreb.noraa...

You can't backup your databases and then restore them? Which part can you
not "afford"? Anyway, the installation center should have an option called
"add features to an existing instance" or something along those lines. I am
on a Mac so can't verify right now, but it might be coupled with "create a
new instance"...

hi Dale,
Dale Fye wrote:

it is possible, via SQLExpressWT or SQLExpressWAS, to install just the
SSMSBasic tool..
If you installed the basic package of SQLExpress 2008 (but you did not, as
you used SQLExpressWAS), you have to...

Hello Dale,

SQL Server 2008 Express Edition with Tools and Advanced Services have SQL
Server Management Studio Basic (SSMSB) with them and this feature is called
"Management Tools - Basic" and you can check this feature to be installed
during SQL Server 2008 Express Edition installation. It's in the Feature
Selection window as the other features.

However, if you did not check it during an installation, you can simply
install it by running the SQL Server 2008 Express Edition (x) Setup. So this
means that you don't have to install another instance of SQL Server 2008
Express Edition to install SSMSB.

During this installation process, in the Installation Type window you should
simply select "Add features to an existing instance of SQL Server 2008" and
then select the existing SQL Server 2008 instance name -which you have
already installed- in the dropdown box. Then keep going. You'll come to the
Feature Selection window. Here, if SSMSB is not installed then you'll see
that the checkbox (Management Tools - Basic) with it is enabled and
unchecked. Then check this feature and keep installing.

P.S.
I've tested it for you, it simply works.

Thanks,

I found it late yesterday evening. I was bypassing it because I was
choosing one of the wrong options earlier in the process.

Thanks to everyone for the assistance.

Dale

"Ekrem