John's profileJohn BarshingerPhotosBlogLists Tools Help

Blog


    November 06

    Installing SQL Server Management Studio when you already have Management Studio Express installed!

    Why would you need to have the full-blown version of Management Studio when you can just download and install the Express version of Managment Studio you ask? Because I want to be able to use SQL Refactor from Red-Gate. I don't really need a full-blown install of SQL Server for my development purposes, all I really want is SQL Express and the full blown Management Studio in my Developer VM.

    I got this info from here (kudos to him) but I wanted to put a copy in my blog so the next time I need to do this I won't have to search for it...

    After you uninstall SSMS Express:

    1. Click Start, and then click Control Panel.
    2. Double-click Add or Remove Programs.
    3. In the list of installed programs, click Microsoft SQL Server 2005, and then click Change.
    4. On the Component Selection page, select Workstation components, and then click Next.
    5. Click Next.
    6. On the Change or Remove Instance page, click Change Installed Components.
    7. Click Client Components, and then select Entire Feature will be Unavailable.
    8. Click Next.
    9. Click Install.

    Now you should be able to install from the full-blown edition of SQL Server Management Studio (and subsequently SQL Refactor!)