MSSQL 2005 - issue with installation of MSSQL Management Studio

Posted on 2007-09-27
Last Modified: 2010-03-19
Issue installing MSSQL 2005 - I installed MSSQL Express Management studio on computer initally.

Later I did a full installation of MSSQL 2005 - the Management Studio did not load - presumably because express version on.

I have uninstalled express version and tryed to reinstall MSSQL 2005 from add/remove components - change and from the installation disc.

Does not seem to provide an option to reinstall the Management studio functionality.

MSSQL Express does not have scheduled backup which I need.

This is on clients server and have an instance of MSSQL installed for Backup exec. so reluctant to uninstall and reinstall.
Question by:donhannam
    LVL 27

    Accepted Solution


    Author Comment

    Eventually tryed a derivation of one of comments on blog and worked - uninstalling components and running sql_tools. did not need to rename tools directory.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now