SQL Server Management Studio Express 2008

42 views
Skip to first unread message

Dale Fye

unread,
Sep 6, 2008, 12:52:21 PM9/6/08
to
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.


Aaron Bertrand [SQL Server MVP]

unread,
Sep 6, 2008, 1:30:10 PM9/6/08
to
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 erwuTGE...@TK2MSFTNGP03.phx.gbl, "Dale

Dale Fye

unread,
Sep 6, 2008, 1:47:15 PM9/6/08
to
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]" <ten...@dnartreb.noraa> wrote in message
news:C4E83662.11B70%ten...@dnartreb.noraa...

Aaron Bertrand [SQL Server MVP]

unread,
Sep 6, 2008, 2:07:14 PM9/6/08
to
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"...

Andrea Montanari

unread,
Sep 7, 2008, 6:04:45 AM9/7/08
to
hi Dale,

Dale Fye 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.

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 upgrade the installed instance (basic)
to the one With Advanced Service before trying to install the SSMSBasic
tool... but, using the reported packages, you can install, if you like, just
the tool on a clean machine not hosting SQLExpress as well.. you are just
required to install Windows Installer 4.5 upgrade, Net FWK 3.5sp1 and
PowerShell thought...
please have a look at my own "experiences" installing SQLExpress 2008 at
http://www.asql.biz/Articoli/SQLX08/Art1_1.aspx
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply


Ekrem Önsoy

unread,
Sep 7, 2008, 2:02:34 PM9/7/08
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.

--
Ekrem Önsoy

"Dale Fye" <dale...@nospam.com> wrote in message
news:erwuTGE...@TK2MSFTNGP03.phx.gbl...

Dale Fye

unread,
Sep 7, 2008, 5:07:35 PM9/7/08
to
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 Önsoy" <ek...@compecta.com> wrote in message
news:A166CCD8-69CE-432F...@microsoft.com...

Marc

unread,
Oct 8, 2008, 12:41:01 AM10/8/08
to
I downloaded the Visual Studio Express 2008 Bundle and installed it. This
included SQL (which installed just fine), but I do not see the management
tools. I then downloaded the SQL express advanced in hopes of fixing the
issue, but it will not extract the files in Win32. Do these tools even run in
Win32? I am using Windows XP Media Center.

Ekrem Önsoy

unread,
Oct 8, 2008, 3:45:40 AM10/8/08
to
I don't know what "Visual Studio Express 2008 Bundle" is, but I assume you
installed the "Visual Studio Express 2008" and you expected to see a GUI to
manage your SQL Server databases and then you downloaded and installed SQL
Server Management Studio Express and it did not run. This is what I
understand from your post.

If so, ensure that the SSMSE Setup was downloaded correctly. It may be
corrupted or timed out while being downloaded. Its file size must be 38.4MB.


--
Ekrem Önsoy


"Marc" <Ma...@discussions.microsoft.com> wrote in message
news:42614E77-A24B-4268...@microsoft.com...

Marc

unread,
Oct 8, 2008, 9:31:01 AM10/8/08
to
Thank you for the response. Yes your assumption is correct, I do have the
Visual Studio Express 2008 correctly installed. The problem is that I cannot
find anywhere the specific download for SSMSE. All I have found are downloads
for SQL Express 2008 with Tools or SQL Express 2008 Advanced. From what I
have read in the forums, both of these should fix the issue, but with them I
encountered another error in running the executable for those downloads. The
extraction fails because it says application "is not a Win32 Application".
Where do I find the 38.4MB SSMSE download, and will it give me the same Win32
error?

Marc

unread,
Oct 8, 2008, 10:14:10 AM10/8/08
to
I found this article in a thred concerning these issues, but unfortunately I
had to dig for a total of about 4 hours to find this simple solution. As a
measure of goodwill to those encountering these same issues, here is the fix:

http://www.asql.biz/Articoli/SQLX08/Art1_2.aspx

Follow these procedures and SSMSE will be up and running. Best of luck to all!

Ekrem Önsoy

unread,
Oct 9, 2008, 4:34:45 AM10/9/08
to
You can download SSMSE 2005 from the following link:
http://www.microsoft.com/downloadS/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

--
Ekrem Önsoy

"Marc" <Ma...@discussions.microsoft.com> wrote in message

news:FEC5F1D0-071A-4924...@microsoft.com...

Aaron Bertrand [SQL Server MVP]

unread,
Oct 9, 2008, 11:44:31 AM10/9/08
to
I'm still surprised you can't download the 2008 version of SSMSE separately
(and have yet to get an answer about why).


On 10/9/08 4:34 AM, in article
5C12152A-0992-4D57...@microsoft.com, "Ekrem Önsoy"

Ekrem Önsoy

unread,
Oct 10, 2008, 4:03:48 AM10/10/08
to
You already very well know about the existing problems of SSMS 2008. I can't
use it against my SQL Server databases which are hosted on hosting
companies. And most of them are 2000 and 2005 instances. So, SSMS 2008 is
useless for me for now and I personally don't care if they release SSMSE
2008 or not...

--
Ekrem Önsoy


"Aaron Bertrand [SQL Server MVP]" <ten...@dnartreb.noraa> wrote in message

news:C5139F1F.14285%ten...@dnartreb.noraa...

Aaron Bertrand [SQL Server MVP]

unread,
Oct 10, 2008, 10:22:47 AM10/10/08
to
I can use it fine, you just need to strip Object Explorer Details to the
bare minimum (do this while highlighting the databases node for a server you
CAN connect to). And tell your host to shut off that stupid Auto-Close
feature, anyway.


On 10/10/08 4:03 AM, in article
0BB50CDD-A813-41AB...@microsoft.com, "Ekrem Önsoy"

Ekrem Önsoy

unread,
Oct 12, 2008, 6:22:10 AM10/12/08
to
Are you kidding me? I can't even pursuade them (a company from U.S.) to
enable Database Mail...

--
Ekrem Önsoy

"Aaron Bertrand [SQL Server MVP]" <ten...@dnartreb.noraa> wrote in message

news:C514DD77.14413%ten...@dnartreb.noraa...

Reply all
Reply to author
Forward
0 new messages