Can't install Sql Management console 2008 r2

Posted on 2012-09-14
Last Modified: 2013-04-10
I have a computer with Sql 2008 R2 installed. The management console was not installed by the previous caretaker so I am trying to install it. I have downloaded the file (64 bit). The installation is on a Microsoft server 2008 std. edition. The installed sql version is 2008 R2 std.

When I run the management console installation I get through the processes of the installation without errors but when it comes up to the Feature Selection screen, the shared feature (Management tools - basic and sql client connectivity sdk) are checked but the checkboxes are greyed out. When I click <next> I get a dialog box error message that states: There are validation errors on this page. The validation error is ' to continue one or more features must be selected.' I have no way to change the selection.

Can someone point me in the right direction to get this installed so I can backup the database?


Question by:w_marquardt
    LVL 31

    Expert Comment

    by:James Murrell
    Could you attach a screen shootbplease
    LVL 42

    Expert Comment

    can you please check and post your  server (comp) OS version\edition\Sp and the same for installed sql server ..?
    you may need to run repair sql server
    LVL 29

    Expert Comment

    by:Rich Weissler
    Instead of trying to Add a feature to an existing installation -- run the Install/setup program, and tell it you want to install a new instance.  When it asks you what components you want to install, you should then have the option of JUST installing the management tools.
    LVL 29

    Accepted Solution

    @ w_marquardt: Any luck?  Do you have the Management Tools installed?  Or is there any additional information available?

    Author Comment

    I found that the management console was actually there. It wasn't appearing in the program list but if I searched the drive for the file name, I was able to locate it and create a menu item for it.

    Author Closing Comment

    Console was actually installed. It just wasn't listed in the Program files listing. I had to find it from searching on the program name in explorer.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    759 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

    8 Experts available now in Live!

    Get 1:1 Help Now