[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1187
  • Last Modified:

Can't install Sql Management console 2008 r2

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?


1 Solution
James MurrellProduct SpecialistCommented:
Could you attach a screen shootbplease
Eugene ZCommented:
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
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
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.
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
@ w_marquardt: Any luck?  Do you have the Management Tools installed?  Or is there any additional information available?
w_marquardtAuthor Commented:
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.
w_marquardtAuthor Commented:
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.

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now