none
SQL Server 2008 Management Studio?

    Question

  • I see that Microsoft SQL Server 2008 Express with Tools has SSME 2008 already included. I have SQL Server 2008, but need SS Management Studio 2008, is that download available yet? Because I can't seem to find it.

     

    Or should I just download Microsoft SQL Server 2008 Express with Tools, and if I do, will it just overwrite the existing one or do I need to remove it?

     

    Thanks for your help!

    Sunday, September 07, 2008 1:04 PM

All replies

  • Hello,

     

    I am sorry, but i am not sure to have understood your question.

     

    I suppose that you have installed the "basic" Sql Server 2008 Express Edition , without Sql Server Mananagement Studio Express Edition ( SSMSEE ) which is available since only a few days

    For the moment, you can get SSMSEE from 2 ways :

    - you download Microsoft Sql Server 2008 Express Edition with tools and during the setup, you precise SSMSEE only

    http://www.microsoft.com/downloads/details.aspx?FamilyID=7522a683-4cb2-454e-b908-e805e9bd4e28&DisplayLang=en

    - you download Microsoft Sql Server 2008 Express Edition with advanced services and during the setup, you precise SSMSEE only

    http://www.microsoft.com/downloads/details.aspx?FamilyID=b5d1b8c3-fda5-4508-b0d0-1311d670e336&DisplayLang=en

     

    The both dowloads are on the level SP1

    Be careful, if you have downloaded Sql Server 2008 Express Edition at the beginning of August, you will have to do an update towards SP1 on your Sql Server Express

    Please, could you have a look on this post of Mike Wachal ?

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3782208&SiteID=1

    it is placed at the top of the forum

    he gives the link to a blog . Keep it in your favorites as this blog is the best for the news about Sql Server EE and all the articles are clear, and complete ( a real pleasure to read )

     

    Be careful with the pre-requisites the SP1 needs some others downloads of update

     

    Do not hesitate to post again for more help or explanations

     

    Have a nice day

    Sunday, September 07, 2008 5:11 PM
    Moderator
  • Papy,

     

    Thank you very much for your reply. I didn't know you can just specify the SSMSEE from that download. And yes I already have the SP1 upgrade.

     

    Thanks again,

     

    Russ

    Sunday, September 07, 2008 8:41 PM
  • How do you specify SSMSEE only install???

    Yesterday I installed SQL Server 2008 Express with no issues.

    Today I found the download with tools...

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

    I downloaded it, it's a bigger package (218MB) vs. the package for just express (61MB), so it seems there is more in there.

    When I install it sees that I have all the features of server and pretty much stops there.

    I must be missing how to install SSMSEE only...
    Sunday, September 07, 2008 9:35 PM
  •  cwmizner wrote:
    How do you specify SSMSEE only install???

    Yesterday I installed SQL Server 2008 Express with no issues.

    Today I found the download with tools...

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

    I downloaded it, it's a bigger package (218MB) vs. the package for just express (61MB), so it seems there is more in there.

    When I install it sees that I have all the features of server and pretty much stops there.

    I must be missing how to install SSMSEE only...



    I figured it out, you have to pretend you are installing a new instance (i was trying to add features to my existing instance)
    Sunday, September 07, 2008 9:56 PM
  • You don't have to pretend you're installing a new instance, you've probably now installed two instance of SQL onto your computer. You need to do an Edition upgrade to move from Express basic to Express with Tools. There is more information available in the blog at http://blogs.msdn.com/sqlexpress detailing how to do this.

    Regards,
    Mike
    Monday, September 08, 2008 12:50 AM
    Moderator
  • pretending is an option.

    you get the option to install just the ssmsee by making sure it's the only thing checked.

    sounds like edition upgrade is another way to do it.

    thanks.
    Monday, September 08, 2008 1:02 AM
  • Thanks guys for all your help. I actually didn't get a chance to try it yet, but will in the morning.

     

    Russ S.

    Monday, September 08, 2008 2:03 AM
  • I've upgraded my existing SQL Server 2005 Express installation with SQL Sever 2008 Express (with Tools)
    I wanted also to install Mangement Studio, but I can't find that option in setup program. How can I do that?
    Friday, September 19, 2008 12:08 AM
  • Hi Yevgeniy,

     

    First thing is to check you actually installed the Express with Tools edition, it's easy to get the wrong one. If that's what you've installed, I would have expected Management Studio to be listed in the feature tree, but the Setup team has surprised me before...

     

    Check what edition your installed copy of SQL Express thinks it is by running the following at a command prompt (if you're on Vista you should elevate the command prompt by right clicking and choosing run as administrator.)

    Code Snippet
    SQLCmd -S.\sqlexpress -Q"select @@version"

     

     

     

    This should print out some information including the edition. If the edition just says SQL Express (and not SQL Express with Advanced Services) then it looks like moving from 2005 to 2008 preserves the edition. If this is the case, you can use the Edition Upgrade process described in the blog to make Management Tools available.

     

    Note: This is not the behavior I would have expected, but like I said, sometimes the setup team surprises me.

     

    Regards,

    Mike

    Friday, September 19, 2008 3:44 AM
    Moderator
  • Hello,

     

    Please, could you have a look on this link ?

    http://blogs.msdn.com/sqlexpress/archive/2008/08/24/faq-switching-between-sql-server-2008-edtions.aspx

     

    Mike Wachal has written this article ( excellent and clear, as usual )

     

    You should keep this site ( http://blogs.msdn.com/sqlexpress/default.aspx ) which is one of the best about Sql Server Express, among your favorites

     

    You have also the answer in this short but complete post of Mike Wachal ( i am wandering what we could do without Mike )

    http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=769188&SiteID=1

     

    Have a nice day

     

    Friday, September 19, 2008 6:10 AM
    Moderator
  • Yes, I'm also wandering what would we do without Mike and I have found the answer:

    Without Mike and his team we would never suffer from this absolutely non-understandable idea of removing simple SSMSEE.msi and include it into huge package, where you cannot do the simplest thing without googling the whole day.

    Pardon my English, I'm not really even beginner :)

    Thats absolutely frustrating solution and I hate it. I could ROUGHLY understand complexity of IIS7 without FTP, but this "innovative" solution just killed me: I have downloaded SSMSEE 64 bit setup, ran it and instead of the setup, I've got again MSSQL setup with bunch of options containg everything apart from what I asked for. It makes me think that in next 2-3 years of these innovations,the day Microsoft makes a product that doesn't suck, is the day they will make a vacuum cleaner

    Absolutely irrational, and I'm with Microsoft technologies since NT4, kinda tired of learning millions of UNNECESSARY changes.

     

    BTW my solution that worked: uninstall SQL Express, download full package including Management Studio and install again. Separate SSMSEE installer doesnt work for 64-bit, or I just couldn't get it to work.

     

    Wednesday, September 29, 2010 7:49 PM