<< This week in Tampa - Silverlight 2 & Networking happy hour, and USF event | Home | How to get started with ASP.NET? Microsoft Web Platform Installer will help >>

SQL Server Management Studio Express 2008

SQL Server Express Management Studio Express 2008

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.

posted @ Wednesday, October 08, 2008 7:32 PM

Print

Comments on this entry:

# re: SQL Server Management Studio Express 2008

Left by Mike at 10/26/2008 1:00 PM
Gravatar
you saved me a bunch of time, but I already lost a few hours dealing with this issue.

Hey MS... why not do things in a straight forward way rather than have us poor geeks guessing all the time.

# re: SQL Server Management Studio Express 2008

Left by tc at 12/14/2008 7:54 PM
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.

# re: SQL Server Management Studio Express 2008

Left by ashish at 2/2/2009 7:28 AM
Gravatar
Nice information which i was searching about sql server..

# re: SQL Server Management Studio Express 2008

Left by rtpHarry at 2/3/2009 6:06 AM
Gravatar
I have installed the "with Advanced services" version but I cant find out how to load Server Management Studio Basic.

The search continues....

# re: SQL Server Management Studio Express 2008

Left by Manie Verster at 2/16/2009 2:04 PM
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

# re: SQL Server Management Studio Express 2008

Left by Manie Verster at 2/17/2009 2:40 AM
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!

# re: SQL Server Management Studio Express 2008

Left by Swanky at 5/22/2009 4:51 AM
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. :)

# re: SQL Server Management Studio Express 2008

Left by willstay at 6/30/2009 1:10 PM
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

# re: SQL Server Management Studio Express 2008

Left by ordueste at 7/1/2009 11:10 AM
Gravatar
the install order can be changed as needed

SQLManagementStudio2008_x
86_DEU.exe" /Q /ACTION=install /FEATURES=Tools

# re: SQL Server Management Studio Express 2008

Left by Pim at 8/13/2009 4:41 AM
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

# re: SQL Server Management Studio Express 2008

Left by glas at 10/24/2009 4:25 AM
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??

Your comment:



 (will not be displayed)


 
 
 
 
 

Live Comment Preview:

 
«November»
SunMonTueWedThuFriSat
25262728293031
1234567
891011121314
15161718192021
22232425262728
293012345









My groups:

www.TampaUX.org

www.MISSociety.org

www.FlaDotNet.Net





Locations of visitors to this page

About
Twitter











Archives
Syndication:

RSS ATOM