Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

On my development machine, SQL server 2008 R2 was running fine previously. But after formatting OS and re-installing the OS and SQL server, it generates the following error when I want to start SQL Server Management Studio.

Error Message:

“A problem was encountered initializing commands and menus. The merged file was loaded, but it contained no valid commands. Please run setup and select Repair.”

Please note that I’ve executed setup and repaired successfully after getting the above error.

Please help me to solve the problem.

share|improve this question

migrated from stackoverflow.com Jan 16 '12 at 15:17

This question came from our site for professional and enthusiast programmers.

add comment

2 Answers 2

up vote 3 down vote accepted

Instead of running repair, completely uninstall the client tools using setup, and then reinstall them from scratch. Make sure you also uninstall any add-ins or plug-ins that you're currently using in SSMS. Once you've installed SSMS from the media, then apply SQL Server 2008 R2 Service Pack 1. If you have Visual Studio 2010 also installed on your machine, make sure you've installed service pack 1 there before re-installing client tools.

FWIW, I've found the new features and enhancements in SQL Server 2012's version of Management Studio to be very beneficial, and have been using it as my only SSMS version since the early betas to manage 2005, 2008, 2008 R2 and 2012 instances with no problems. RC0 is out so it may be worth trying that version too. It's a big download for just the client tools, but worth it IMHO. You can get it here:

http://www.microsoft.com/download/en/details.aspx?id=28145

share|improve this answer
    
Thank you for your reply. Yes, this is good idea instead. But, I can't find way to remove any tools using SQL Server setup. Meanwhile, from error log file, I found the probable error cause: "The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies." –  Agilox Jan 16 '12 at 17:27
    
Yes, I've removed the SQL tools, and then re-installed from the scratch. Thank you. –  Agilox Jan 16 '12 at 18:31
add comment

SSMS Depends on Visual Studio 2010 IDE, which if not installed the SQL Server Setup will do, but if any version is present, the setup will ignore it, even at repair

Re Install, I figured that the SSMS needs Visual Studio 10 IDE to run, which I've removed by mistake after uninstalling VS 2010.

So, I Opened the Setup Media and searched for Visual Studio Setup. The .msi file ran quietly and Filled the missing parts, and the Management Studio Run OK.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.