Skip to content

Can't Install Microsoft SQL Server 2008 Management Studio Express

Ok, I’m angry, and two hours of my time has gone that I will never get back.

I’ve just spent the morning trying to get Microsoft SQL Server 2008 Express + Management Studio installed after a PC format. I’m running Windows 7 64-bit Ultimate (x64) and all files in question below were downloaded via the Microsoft download portal site.

Let me give you the low down of the problem I encountered, my experience and what I had to do to overcome it. If you’ve came from a Google link, yes hopefully this post will save you if you are having problems installing Microsoft SQL Server 2008 Management Studio Express.


PROBLEM

Simply put, SQL Server 2008 Management Studio Express WILL NOT INSTALL with my SQL Server 2008 Express edition install.
Let me show my download process and files involved in this fun adventure:

Microsoft® SQL Server® 2008 Express
SQLEXPR_x64_ENU.exe 84,498 MB

I selected this package to download as I wanted to download the lightest-weight package available which installs the database services of SQL Server 2008 64-Bit Express.

Microsoft® SQL Server® 2008 Management Studio Express
SQLManagementStudio_x64_ENU.exe 180,712 MB

I chose to download the SQL Server 2008 Management Studio Express tool as a separate download just in case I ever needed the database services standalone without the management studio etc. I realise there is a SQL Server 2008 Express with Tools available to download but it wasn’t the most appropriate for me.

So after having both packages downloaded, in my matching 64-bit edition I proceeded to install SQL Server 2008 Express (SQLEXPR_x64_ENU.exe). When I did I received a message prompted from Windows 7 which stated I needed to download the Microsoft SQL Server 2008 (SP1) before using SQL Server 2008:

Based on that feedback, I stopped at that point to download SP1 to ensure compatibility, after a few minutes of digging around Microsoft’s download portal, I found this link:

Microsoft® SQL Server® 2008 Express Edition Service Pack 1
SQLEXPR_x64_ENU.exe 106,796 MB

Notice something familar?? That’s right the filename matches the original SQL Server 2008 Express install filename, SQLEXPR_x64_ENU.exe! WHAT THE!

So I paused, thought, (actually there was a lot more swearing involved) and all that I could deduce was going on was that by Microsoft stating this is the Microsoft® SQL Server® 2008 Express Edition Service Pack 1, what they meant was this is Microsoft® SQL Server® 2008 Express Edition WITH Service Pack 1. I still do not know if this is true. But I installed this version and renamed it as SP1_SQLEXPR_x64_ENU.exe.


TRIED INSTALLING

Now for the installs! I ran the SP1_SQLEXPR_x64_ENU.exe install package, I installed all options I required, including database services and client connectivity components. So that was confusion #1, who knows if it installed with the Service Pack 1 or not, there was no mention, so I have no idea, but could probably run a verison check as a SQL query if I was concerned.

Now on to the Management Studio. This is easy, straight forward, it’s just the one download SQLManagementStudio_x64_ENU.exe and could present no problems, SURELY, even thought it comes in at ~180MB; ~74MB larger than the Database Services itself, I won’t let that bother me. Once the installer launched, I clicked “Installation” proceeded through the standard SQL installer ready to select “Management Studio” when “Feature Select” prompts me too.

Then we arrived at the step, and nothing, no option for “Management Studio – Basic“, nothing.
In fact, the whole installer described in text like I was adding features to the database services, geared up completely like a “add/remove components” option on the SQL Server 2008 Express install!

So after trying many things, reboots, installing my non “SP1_” .exe file, then trying SQLManagementStudio_x64_ENU.exe again, no luck. I had downloaded the Management Studio tool, and I simply, could not install the management studio. 180MB, with a gazillion wizards of dependency and rule checking and NOT ONE prompt guiding me regarding what I should do, if my system was configured incorrectly to install, or what.

So yes, as I build to the conclusion and figure out a way around it, in a long shot of hope, I uninstalled everything, all instances and components relating to SQL Server 2008 Express and thought perhaps SQLManagementStudio_x64_ENU.exe somehow crazily, despite all text on the download links stating it is the standalone management studio, that infact it isn’t.

Perhaps it’s SQL Server 2008 Express WITH Management Studio and for some reason it simply does not install separately. So I tried that, I progressed, and what it did prompt me with was actually different to what I had thought, quite a shock.  At “Feature Selection” was FINALLY the option to select “Management Studio – Basic“, but not with database services, just management studio!


FIX – INSTALL BACKWARDS!

So that’s the logic, install everything backwards:

First the SQLManagementStudio_x64_ENU.exe to install your tools, and then SQLEXPR_x64_ENU.exe to install your database services. Or perhaps if you are happy with an all in one package, go for this guy – Microsoft® SQL Server® 2008 Express with Tools it’ll probably save you a lifetime of headaches. Don’t try to be tricky like me and get separate installs.


WHAT WE I HAVE LEARNT

Some times things can be made a little too intuitive for their own good to the point systems trip over themselves.
But hopefully although I’ve wasted another half an hour on this blog post, I have saved many people around the globe their valuable time.

Peace.

VN:F [1.8.3_1051]
Rating: 4.9/5 (48 votes cast)
VN:F [1.8.3_1051]
Rating: +41 (from 43 votes)
Can't Install Microsoft SQL Server 2008 Management Studio Express4.9548
Bookmark and Share
kick it on DotNetKicks.com
Shout it

NOW, FOR A WORD FROM OUR SPONSORS

27 Comments

  1. hi there..

    i’ve just run into the same issue, but hopefully found this article: http://www.asql.biz/Articoli/SQLX08/Art3_1.aspx

    in the last part it covers the issue of installing SSMSE over the existing SQL Server Express installation. the key is to go installing a ‘new’ instance, not to add features to existing installation. then there is an option to select SSMSE.

    bad thing is that i’ve installed SQL Express 2008 SP1, and this installs the SQL Express again, so i’ll have to rerun the SP1 installation, but at least it’s better than uninstalling everything.. hope this will help someone sometime :cool:

    UN:F [1.8.3_1051]
    Rating: 5.0/5 (3 votes cast)
    UN:F [1.8.3_1051]
    Rating: +6 (from 8 votes)
    Posted on 03-Jun-09 at 10:41 am | Permalink
  2. Roger

    As for your program compatibility issue, I like to disable that beotch right away. Go to group policy editor, on the computer folder, expand the windows components, and select the program compatibility or whatever it is called, then enable the option to “Disable Program Compatibility” or some such nonsense. Do that for the current user too and then save and reboot.

    Lets you do all kinds of stuff, like install MOSS and WSS etc…

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: +2 (from 2 votes)
    Posted on 03-Jun-09 at 8:56 pm | Permalink
  3. Roger

    by the way, my installation of SQL Express stopped working after I applied sp2. Everything appears to be running, but I cannot connect. That is what brought me across your post. It is in fact irritating. It was running fine. Oh well, thati s what I get for running a pre-release OS.

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: 0 (from 0 votes)
    Posted on 03-Jun-09 at 8:58 pm | Permalink
  4. cybafelo

    so there you go – m$ produces management studio bloatware – way larger than the database engine – then gets the installation steps completely wrong – probably so you can accept their silly license terms – costs thousands of developers hours of frustration trying to do something extremely mundane and they still get away with it. nice one microsoft – you really have your heads up your asses. too bad i have some time/technology constraints but rest assured – after going live i WILL be porting everything to opensource. may you die a slow and painful death.

    UN:F [1.8.3_1051]
    Rating: 5.0/5 (1 vote cast)
    UN:F [1.8.3_1051]
    Rating: -3 (from 9 votes)
    Posted on 18-Jun-09 at 12:38 am | Permalink
  5. dx

    Dude, you are a life saver.
    I thought I’d written a blog without realizing at first.
    I went through exactly the same process you did.
    Thanks for your help.

    UN:F [1.8.3_1051]
    Rating: 5.0/5 (1 vote cast)
    UN:F [1.8.3_1051]
    Rating: 0 (from 0 votes)
    Posted on 28-Jun-09 at 7:17 pm | Permalink
  6. Graham O'Neale

    Glad I could help!

    UA:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UA:F [1.8.3_1051]
    Rating: +1 (from 1 vote)
    Posted on 29-Jun-09 at 4:31 pm | Permalink
  7. cgyrob

    If you really want to make it easy go to this site.

    http://www.asp.net/downloads/

    Download the microsoft “Web Platform Installer”

    It will allow you to not only install Visual Web Developer Express but SQL server 2008 express SQL Server 2008 Management studio express as well as other Microsoft web development express versions including silverlight.

    The installer will handle the complete installation of the products just like windows update so you don’t have to think about the order Microsoft needs for the tools to work.

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: 0 (from 2 votes)
    Posted on 29-Jul-09 at 11:02 am | Permalink
  8. Graham O'Neale

    @cgyrob Great tip.

    UA:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UA:F [1.8.3_1051]
    Rating: 0 (from 0 votes)
    Posted on 29-Jul-09 at 5:46 pm | Permalink
  9. Tirnaog

    The website tool “Web Platform Installer”, did not help me to pass the error. Got the same compatibility msg. Then it just hung there.

    Anyone get this to work on Win7 RTM 64bit?

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: 0 (from 0 votes)
    Posted on 16-Sep-09 at 11:07 am | Permalink
  10. Ezequiel SAntamaria

    Platform: Windows 7 x64
    SQL: Server 2008 x64 (installed SP1)
    Problem: Management Studio won’t connect giving error “Can’t Connect to SQL Server”
    provider: Named Pipes provider, SQL Server, Error: 3″

    Actions:
    Disabled Firewall (to eliminate it out of the equation)
    All TCP/IP, Named Pipes, Enabled

    Headache:
    Toad for SQL works like a charm and connects perfectly.

    I did get the known compatibility issue but I thought it was solved on SP 1 which I installed immediately.

    Any thoughts of how to make Management Console works?

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: 0 (from 0 votes)
    Posted on 29-Sep-09 at 10:41 pm | Permalink
  11. Travis

    Just wanted to thank you for this posting after spending hours trying to install different versions of sql i finally got it right using your advice

    thanks for taking the time to post this issue

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: +1 (from 1 vote)
    Posted on 31-Oct-09 at 1:33 am | Permalink
  12. Nicolay

    I installed SQL Server 2008 Express SP1 on Windows 7 (32), but first I forgot to stop the firewall, so first four attempts were failed. Then I disabled firewall and installed SQL Server 2008 Express SP1 and connected to it from Visual Studio 2008 SP1.

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: 0 (from 0 votes)
    Posted on 04-Dec-09 at 12:45 am | Permalink
  13. Thank you very much for all of your input there are several great points in this string.
    I would like to describe another way that I found the same solution. This worked on my windows 7 RC build 7600 Version
    Instead of stopping to load the SP1 run the program first.
    Then install the service pack.
    In my case because I also had Visual Studio 2008 loaded on my system. I was required to get SP1 for that too.
    I spent several hours cursing at my machine and microsoft programmers before I found this solution.

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: 0 (from 0 votes)
    Posted on 05-Dec-09 at 3:29 am | Permalink
  14. Ron

    I had installed SQL Server 2008 via the Web Platform Installer, but during the installation the SQL Server 2008 Management Studio Express failed.

    I had to uninstalled SQL Server 2008, ASP.NET 3.5 SP1, then reinstall ASP.NET 3.5 SP1. Then I downloaded the standalone management studio as you suggested (SQLManagementStudio_x86_ENU.exe). This installed just the studio.

    Then I used the Web Platform Installer to reinstall SQL Server 2008, and it installed correctly.

    Note:
    I connected to it with the host: .\SQLEXPRESS rather than . or localhost.

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: 0 (from 0 votes)
    Posted on 17-Dec-09 at 4:49 am | Permalink
  15. Jano

    Thanks for everyone who put in effort to create this post, saved me a ton of time!

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: 0 (from 0 votes)
    Posted on 30-Dec-09 at 6:16 pm | Permalink
  16. scon

    Hi Graham,

    Does installing SQL Express 2008 SP1 need Visual Studio 2008 SP1 to be installed?

    Thanks.

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: 0 (from 0 votes)
    Posted on 12-Jan-10 at 12:23 pm | Permalink
  17. Thanks Graham. Very helpful. Thought I was going mad until I found this post.

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: 0 (from 0 votes)
    Posted on 16-Jan-10 at 3:14 am | Permalink
  18. kevin

    There is some issue/inconsistency for SKU across Express packages, as a result, this causes a counter intuitive situation as posted here. A simpler workaround is to select the default “perform a new installation of SQL Server 2008″ in the Installation Type page. Since SSMS is a shared component, it would not instance a new SQL instance, and will only install SSMS incrementally. SQL production team is working to resolve this for the next major release of SQL.

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: -1 (from 1 vote)
    Posted on 18-Jan-10 at 6:24 am | Permalink
  19. davidf

    the poster stated the following:”Ok, I’m angry, and two hours of my time has gone that I will never get back.”
    please clarify for me:
    how is this different than the rest of your time spent? are you able to get that time back somehow? if you have discovered some way to do that, you may want to worry less about installing software, and start marketing your invention.

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: +1 (from 1 vote)
    Posted on 01-Feb-10 at 2:44 am | Permalink
  20. Enrique Araiza

    Thanks! I had spent more than 5 hours. Best way to go is your last advice to install everything together (“with tools”).

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: 0 (from 0 votes)
    Posted on 05-Feb-10 at 8:27 am | Permalink
  21. Valeriano

    Been a long time since you wrote this entry but I have to say: this describes almost precisely what I’ve been through just now, trying to get this thing to work – the difference is that I’m installing the 32 version.

    Talk about effed-up installation design.

    Cheers!

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: 0 (from 0 votes)
    Posted on 07-Feb-10 at 10:14 pm | Permalink
  22. Graham O'Neale

    @davidf Yes, I classify time as ‘wasted’ if it’s counter-productive. I don’t consider being productive wasting time. :)

    UA:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UA:F [1.8.3_1051]
    Rating: 0 (from 0 votes)
    Posted on 08-Feb-10 at 9:04 am | Permalink
  23. I fully agree with you and thanks for the good tip. I was going crazy with this nightmare.
    Actually I tried to install SQL Server 2005 Standard (which is what I paid for 3 years ago) but somehow it is not compatible with W7.
    So, now I know what to do. Thanks again!
    PS. I don’t understand why the hell Microsoft cannot learn from other database companies like Oracle. It is such a breeze to upgrade, especially if it is just a development scenario.

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: 0 (from 0 votes)
    Posted on 08-Feb-10 at 1:29 pm | Permalink
  24. Travis

    Use the Microsoft Web Platform installer. Works like a champ!

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: 0 (from 0 votes)
    Posted on 11-Feb-10 at 8:54 am | Permalink
  25. Thanks Graham. After 4 hours wasting my time I finally got it using your advise.

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: 0 (from 0 votes)
    Posted on 15-Feb-10 at 11:48 am | Permalink
  26. Same here dude. i’m just going around and around in circles. Useless!

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: 0 (from 0 votes)
    Posted on 20-Feb-10 at 8:34 pm | Permalink
  27. Christian

    I feel your anger, man. I’m in the f*cking middle of this too. It’s the same mess every time I install that crap. If only the installer was quick, but it isn’t. What a nightmare!

    UN:F [1.8.3_1051]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.3_1051]
    Rating: 0 (from 0 votes)
    Posted on 26-Feb-10 at 10:40 am | Permalink

Post a Comment

Your email is never published nor shared. Required fields are marked *
*
*
My name is Graham O'Neale and I'm a software architect from Gold Coast, Australia. I am an overtime thinker, full time coder and awake part time in the real world. I have a keen interest in software development, particularly in the realm of programming (C#, ASP.NET, ASP.NET MVC, LINQ (2 SQL), Entity Framework, Silverlight, Blend, WCF, WPF) and a keen interest in the cutting edge and innovation. I have a new found love for design patterns, ALT.NET practices and well crafted software architecture. The purpose of this blog is to express any thoughts, findings, tips and gripes along my travels in the wonderful world of coding and technology...