SQL Server Management Studio Express 2008

To Download the SQL Server Express Management Studio Express 2008 for SQL Express 2008 R2:

(Begin June 2011 Update)

 
Database Only
Management Tools
Database with
Management Tools
Database with
Advanced Services
SQL Server Database Engine
Full Capability
 
Full Capability
Full Capability
SQL Server Management Studio Express  
Full Capability
Full Capability
Full Capability
Full-Text Search      
Full Capability
Reporting Services      
Full Capability
Download Size ( 32-bit | 64-bit )
58.1 MB | 74 MB
154 MB | 163 MB
235 MB | 247 MB
727 MB | 795 MB
Install

(End June 2011 Update)

I was recently doing a personal site and wanted to use VWD and SQL Express, this time all 2008.

All happy and fine went to the site and downloaded and selected to install SQL Exrpress 2008.

Went to look for SQL Server Express Management Studio Express 2008 annnnnd nothing!

Few search engine searches later and no clear direction found this on SQL Express home page:

 

You can manually download and install any edition of SQL Server 2008 directly from the Microsoft Download Center:

 

Which edition of SQL Server 2008 Express is right for you?

SQL Server 2008 Express is available in the following 3 editions (each is available from the Install Wizard):

  • SQL Server 2008 Express
    • SQL Server database engine - create, store, update and retrieve your data
  • SQL Server 2008 Express with Tools
    • SQL Server database engine - create, store, update and retrieve your data
    • SQL Server Management Studio Basic - visual database management tool for creating, editing and managing databases
  • SQL Server 2008 Express with Advanced Services
    • SQL Server database engine - create, store, update and retrieve your data
    • SQL Server Management Studio Basic - visual database management tool for creating, editing and managing databases
    • Full-text Search - powerful, high-speed engine for searching text-intensive data
    • Reporting Services - integrated report creation and design environment to create reports

So make sure you download the SQL Server 2008 Express with Tools

Though I save some people some time.

One last thing:

Step 1: Download and install Microsoft .Net Framework 3.5 SP1.

Step 2 Download and install
Windows Installer 4.5 [important of you have pre-Vista OS].
.
Step 3 Download and install
Windows PowerShell 1.0.

And one more thing: If you have non-SP1 version of Visual Studio 2008, you will be stopped at the very last step before the install begins!!! So if you have VS2008 or any 2008 Express products, upgrade them to SP1 to install the Tools version to get your Management Studio Express.

UPDATE:UPDATE:UPDATE:UPDATE:UPDATE:UPDATE:UPDATE:UPDATE:UPDATE:

A commenter by the name of "matt" has an update:

I FOUND A SOLUTION TO THE PROBLEM ABOVE ME

1. If you run "SQLManagementStudio_x64_ENU.exe", you'll come across a "SQL Server Installation Center" window.
2. You normally click at the "Installation" tab on the left pane, and click "New SQL Server stand-alone installation or add features to an existing installation".
3. A "SQL Server 2008 Setup" installation window appears, and have the following steps included:
- Setup Support Rules
- Installation Type
- Product Key (depending on the type of installation type you selected)
- and so on...
4. Once you get to the "Installation Type" step of the installation, instead of adding a new feature to the existing SQL Instance (that I initially setup as SQLExpress), try the install new instance, or something to that effect. There are only two options in this portion, so it won't be difficult to select.
5. Click next until you reach the "Feature Selection" step of the installation. There, select only the "Management Tools" checkbox (or something that relates to the Management Studio). And, in my case, the "Client SDK" checkbox was automatically checked. Uncheck the first two checkboxes that have something to do with a new SQL Instance. You won't need that anymore because you've installed that earlier.
6. Install on and be done! :)

I hope this helps... please post replies if this worked or not.



 

Print | posted on Wednesday, October 8, 2008 7:32 PM

Comments on this post

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
OMG, finally a written confirmation of what I started to suspect.
This really sucks, All I could find was SSMS 2005.
I wish there would be a separate download for machines that do not need server components but just client tools for development.

Thanks for putting info "out there", appreciate it.
Left by tc on Dec 14, 2008 7:54 PM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Nice information which i was searching about sql server..
Left by ashish on Feb 02, 2009 7:28 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
I have installed the "with Advanced services" version but I cant find out how to load Server Management Studio Basic.

The search continues....
Left by rtpHarry on Feb 03, 2009 6:06 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Hi guys, same problem here. I found a website that helps you to install the Management Studio but before attempting make sure all SQL Server 2005 components are uninstalled. I upgraded my SQL Server 2005 to 2008 and found that no SSMS was installed. This website explains how to do it. Not tried yet but maybe this can help you. I will try it tommorrow and let you know.
http://www.asql.biz/Articoli/SQLX08/Art1_2.aspx#SSMSB
Left by Manie Verster on Feb 16, 2009 2:04 PM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
I posted yesterday to tell you about the website I found that explains how to install the Management Studio and I can testify. It works! Just make sure you uninstall all the 2005 components. My management studio is up and running perfectly. Try this!
Left by Manie Verster on Feb 17, 2009 2:40 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Thanks a lot for the information. I was searching for it over an hour. You made my day which is actually my birthday. Thank you very much. :)
Left by Swanky on May 22, 2009 4:51 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
I was lost too. I installed 2008 Express, then downloaded Management Studio 2008 separately. Strangely due to some unknown reason, I was not able to install Management Studio. It was asking if I wanted to install new db instance. I thought oh okay Mgmt Studio comes with database core. I uninstalled db core and then installed Mgmt Studio and realized it is just Mgmt Studio as mentioned in MS website. Finally installed 2008 Express and now it is working. So correct order of installing if you did not download "with Tools" or "with Advance Services" but as separate installation files, then install in this order -

1) Management Studio 2008
2) 2008 Express
Left by willstay on Jun 30, 2009 1:10 PM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
the install order can be changed as needed

SQLManagementStudio2008_x
86_DEU.exe" /Q /ACTION=install /FEATURES=Tools
Left by ordueste on Jul 01, 2009 11:10 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
If all you want is to download the SQL Server 2008 Management Studio Express, here is the download link:

http://www.microsoft.com/downloads/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&DisplayLang=en
Left by Pim on Aug 13, 2009 4:41 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
OK,
1. download SQLManagementStudio_x64_ENU.exe...check
2. run it...check
3. get installation center...scratch head...say WTH? very loud. Repeat steps 2&3 a few more times in case u got it wrong.
4. ask for help on internets!

my question is rather basic: so wth do i click in order to install management studio express??
Left by glas on Oct 24, 2009 4:25 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
I got exactly the same problem.

Downloaded SQLManagementStudio_x86_ENU.exe but when I run it, it actually came up as 'SQL Server Installation Center'. It provided me with all the options to install SQL as a cluster, upgrade my SQL from previous version, advance cluster prepartion, system configuration, and a whole lot more...

BUT, it did NOT have option to install management studio express. I'm supposed to install management studio express and it gave me EVERYTHING EXCEPT management studio express. WTH?
Left by road_runner on Feb 11, 2010 6:21 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
same problem as the 2 above ..
Left by Jonas on Feb 22, 2010 9:38 PM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
make me a 3rd instance of the problem above me.
Left by matt on Mar 05, 2010 9:39 PM

# I FOUND A SOLUTION TO THE PROBLEM ABOVE ME

Requesting Gravatar...
1. If you run "SQLManagementStudio_x64_ENU.exe", you'll come across a "SQL Server Installation Center" window.
2. You normally click at the "Installation" tab on the left pane, and click "New SQL Server stand-alone installation or add features to an existing installation".
3. A "SQL Server 2008 Setup" installation window appears, and have the following steps included:
- Setup Support Rules
- Installation Type
- Product Key (depending on the type of installation type you selected)
- and so on...
4. Once you get to the "Installation Type" step of the installation, instead of adding a new feature to the existing SQL Instance (that I initially setup as SQLExpress), try the install new instance, or something to that effect. There are only two options in this portion, so it won't be difficult to select.
5. Click next until you reach the "Feature Selection" step of the installation. There, select only the "Management Tools" checkbox (or something that relates to the Management Studio). And, in my case, the "Client SDK" checkbox was automatically checked. Uncheck the first two checkboxes that have something to do with a new SQL Instance. You won't need that anymore because you've installed that earlier.
6. Install on and be done! :)

I hope this helps... please post replies if this worked or not.
Left by matt on Mar 05, 2010 11:02 PM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Thanks very much, Matt. You solved it. On a side note, what was Microsoft thinking??
Left by Chris Bordeman on Mar 10, 2010 5:46 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Thanks very much, it saved me lot of time.
Left by Umesh on Apr 07, 2010 8:57 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Hi all

This post refers to an installation with the following components:
- Microsoft Windows Server 2008 R2
- Microsoft SQL Server Express 2008 x64 (not R2)
- Any application (in this case VMware vCenter Server) which needs a 32bit DSN to an SQL Database


There are two more points on which you can fail:


Problem 1:

As written above, you have a full SQL Server 2008 Express installation but you are missing the "SQL Server Management Studio" to manage your SQL Server.
In some cases it will not work to install the "SQL Server 2008 Express with Tools" over an existing installation without tools. You won't see the option for adding the management tools in the installation progress.


Solution:

- Uninstall the "SQL Server 2008 Express" installation completely from your Windows Server.
- Reboot for sure.. but it's not necessary
- Install "Microsoft SQL Server 2008 Express with Tools" (SQLEXPRWT_x64_ENU.exe)
During the installation progress, now you can select the option "Management Tools"


For information: If you want to create a System DSN to a database, you have to create a database first. To connect to an existing database with an application that needs a 32bit System DSN, you have to configure your database with Compatibility level 90 (SQL Server 2005).


Problem 2:

You have to create a 32bit System DSN to a database instance for any application. You start the %systemdrive%\windows\system32\odbcad32.exe and create successfully a 32bit System DSN, but when you will connect to this DSN, the application will not find it.


Solution:

You startet the wrong odbcad32.exe! Thanks to Microsoft to keept IT small and simple...

This one creates a 64bit DSN:
%systemdrive%\windows\system32\odbcad32.exe

And this one a 32bit DSN:
%systemdrive%\windows\SysWOW64\odbcad32.exe

By hindsight, that sounds logical and easy, but have fun to find the bug when you don't know that ;) It was a very nice idee from the developers, to name this files identical...


I hope this helps :)
Left by Nadine on May 02, 2010 3:54 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
I try to Install "SQL Server Management Studio" but keep on getting
a error : "Setup.exe is not a valid win32 application"
Can someone please help.
Left by Archie on May 03, 2010 8:41 PM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Hi Archie

What OS have you installed?
Did you installed .NET Framework 3.5.1?
and have you installed at a minimum powershell 1.0 (if you have a Windows Server 2008 R2, PowerShell 2.0 is integrated)

Regards,
Nadine
Left by Nadine on May 05, 2010 4:23 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Thanks dude......that's been baffling me for hours. All up and running now.
Left by eds on May 15, 2010 5:08 PM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
excellent post - at last the mystery is solved! Couldn't figure out how to install Mgt Studio Express 2008 so was doing without and had to use sqlcmd :(

Why MS chose to take a nice simple-to-install product (SQL 2005) and create this complicated monster I'll never know...
Left by Richard on Jun 16, 2010 1:08 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Downloaded SQLManagementStudio_x86_ENU.exe but when I run it, it actually came up as 'SQL Server Installation Center'. It provided me with all the options to install SQL BUT, it did NOT have option to install management studio express. I want to install management studio express and it gave me EVERYTHING EXCEPT management studio express. Microsoft should include this in default installation.

YOU HAVE SIMPLIFIED THE INSTALLATION PROCESS.
THANKS A LOT..

Left by Rishi Piyush on Jun 29, 2010 10:19 PM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Thanks for posting this. What a freakin waste of time!
Left by John MacIntyre on Jul 14, 2010 1:31 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Thanks..I wasted my time checking freaking websites
Left by uma on Jul 29, 2010 7:57 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
I am not able to upgrade to SP1, I installed vwd over windows 7 and now i want SSMS but am not able to how to upgrade to SP1 as the process goes on when I reach selection the chekboxes as disabled and can not continue from that step
p.S please send the solution to my email address if you can
rashid35 at gmail
Left by rashid on Aug 01, 2010 6:11 PM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Having a horrible experience with SQL! Once I install it, everything passed EXCEPT the restart rule. After restarting it 3346845856 million times, I still have the same problem. Any help?
Left by Lenny on Aug 10, 2010 4:07 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Why should things so complex. Guys stand up and make things more simple.
Left by Marc on Sep 02, 2010 6:05 AM

# re: SQL Server Management Studio Express 2005

Requesting Gravatar...
preciso urgente vlw!
Left by solyxd on Oct 09, 2010 7:56 PM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
for learning purposes
Left by upendra on Dec 03, 2010 1:04 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
I downloaded SQLManagementStudio_x64_ENU, but when trying to install it I get the following message: ...it is not a valid wind32 application !!! Please any quick solution "help" for this problem.. Thank you
Left by WantToGraduate on Jan 30, 2011 6:27 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Thanks for the info. My ManagementStudio Express installation also failed. I am trying again as you described.

SQL server 2008 has the most annoying installation I have ever used in the last 15 years.

"WantToGraduate", SQLManagementStudio_x64_ENU is meant for 64-bit machines. SQLManagementStudio_x86_ENU is for 32-bit machines.

Left by hsn on Feb 02, 2011 11:32 PM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
hi
mine is 32 bit ,windows vista
i installed powershell1.0
.net framework 3.5sp1
windows installer3.1
then i installed SQLManagementStudio_x86_ENU.exe
In feature selection
i hav


Instance Features
Shared Features
Management tool
sql Client connectivity
Redistributable Features


i hav only these options
i am not able to create new instance
i hav no options in Instance Feature
do i need to install any other software other than above i specified
plz help me
Left by sp on Mar 10, 2011 12:56 PM

# SQL Server Management Studio Express 2008

Requesting Gravatar...
Thanx a lot for ur help
its working perfectely fine
Left by Neel on Apr 04, 2011 1:35 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
using SQL Server management studio express 2005 you can not able to connect to SQL Server 2008 DataBase..so if you are using 2008 SQL Server you have user Server management studio express 2008.
Left by Pankaj on May 26, 2011 6:12 PM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
thanks you
Left by toan on Jun 16, 2011 9:11 PM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Worked perfectly - huge time saver

Thank you
Left by Neil Dockar on Jun 21, 2011 3:29 PM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Thanks for posting that, this install is really anoying ... I saved the time, THANKS !
Left by Steve on Jun 21, 2011 5:34 PM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
It worked perfectly, thanks
Left by Ben on Aug 14, 2011 1:00 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
I have Visual Studio 2005, meaning I have some SQL Server 2005 components. Should I uninstall those components?
Left by quinn on Sep 19, 2011 5:51 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Thanks for this explanation. I was very much confused by the prompts. This is another good blog post resource (I did not write it, just found it in troubleshooting/googling this problem)....it's long, but further validates our troubles.
http://goneale.com/2009/05/24/cant-install-microsoft-sql-server-2008-management-studio-express/
Thanks again.
Left by residentoddball on Sep 28, 2011 11:44 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Thankyou. Your update worked for me.
Left by Fayr on Oct 03, 2011 1:54 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Now on, since december 2011, you can download from the plattform installer the standalone management studio in several languages and even for Windows 7-64bits without uninstalling or reinstalling
Left by Fermat on Jan 19, 2012 7:50 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
hi there. im using visual studio basic 2010 express.
n web platform installer 3.0.
I want to install sql server management studio for my laptop which is using 64-bit window 7 ultimate.
THe web platform installer showed that i've install .NET Framework 3.5 a and powershell 2.0..
somehow, i got an error when i try to run "SQL Server Management Studio" but keep on getting
a error : "Setup.exe is not a valid win32 application"
Can someone please help.
Left by JaniceW Shum on Apr 01, 2012 12:47 AM

# Install SQL Server Management Studio Express on top of an existing SQLExpress instance

Requesting Gravatar...
http://www.asql.biz/Articoli/SQLX08/Art3_1.aspx#SSMSonSQLX

•Install SQL Server Management Studio Express on top of an existing SQLExpress instance.

Tested SQLExpress 2008 64 bit instance on Windows 7
Left by AMEMON on May 26, 2012 4:01 PM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
hi ana name mohamed plz dwn load
Left by mohamed on Nov 10, 2012 3:36 AM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
Images are missing from your article. Could you please upload the images so that we can understand your article better.

Regards
Left by Nikhil on Jan 27, 2013 7:15 PM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
while installing SSMSE, in the setup support file dialog m nt getting the option of 'installation type', i want to install it in a mixed mode.
Please help. Its urgent
Left by Jamuna on Jun 03, 2013 2:40 PM

# re: SQL Server Management Studio Express 2008

Requesting Gravatar...
how to sql running process
Left by sharif on Mar 03, 2014 1:15 AM

Your comment:

 (will show your gravatar)