28 Comments

I had an odd issue where SQL Server Management Studio (SSMS) 2008 R2 would start up, display the following error message, then exit:

Package 'Microsoft SQL Management Studio Package' failed to load

Using SysInternals Process Monitor tool to monitor SSMS.exe it seemed that it was looking for the following registry key but not finding it:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools

By renaming a parent key (rather than delete it - just in case it didn't fix the issue) solved the issue for me. The key I renamed was:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server

Running SSMS again recreated the \100\Tools sub keys and all was well again. I hope it works for you too.

Comments

Comment by W.Vitek

Wow!
Thanks!)

W.Vitek
Comment by mohd

thank you...3x...

mohd
Comment by Brett

THANK YOU!!!!

Brett
Comment by Tony

Hi

Thanks but no cigar. The key was recreated and launching SSMS stated it was setting up for first time use but then displayed the same error again. I guess it is reinstalling .net as the next possible cause.
Windows Server x64 with SQL Express.

Tony

Comment by Edmundo

Tanks Duncan

Edmundo
Comment by Cris

Worked, thanks!

Cris
Comment by Chris

This is exactly what it did for me as well. :(

Chris
Comment by Paul

It works! Thanks!

Paul
Comment by dbrownell

Excellent - it worked for me!

Comment by DragonBehemont

Thank you very much! Nice job!

DragonBehemont
Comment by MN

simply great!!! Worked.

MN
Comment by sgrauslund

Thanks a lot for an easy solution!

sgrauslund
Comment by anu

nop still i m getng same error.plz help me 4dis

anu
Comment by Hank

Me to :(
I just now tried to run the 'repair' on .NET but this did not work. I am going to try running the 'repair' on SQLExpress next.

Hank
Comment by Hank

SQLExpress SSMS had been running great for two days after installation and then I started to get the 'package' error. I almost tried the SQL re-install repair when I noticed that SQL Service Pack 1 was waiting in the Windows update queue. I thought that all the updates had been applied already...
After finishing the service pack update SSMS opens up just fine.

Hank
Comment by issam

waooooooooooooooooow !

excellent !

god bless you

@anu : rename the Microsoft SQL Server key

issam
Comment by Peter

Legend!!! I have had issues on 2 machines now with VS 2010 and SSMS. I wish I had have found this before I started the laborious task of rebuilding the first machine...

Peter
Comment by Mel

Thanks, this worked for me.

Mel
Comment by Pankaj Singh

Can you please provide steps how you did it exactly.

Pankaj Singh
Comment by Ulrich

Thanks a lot!!!

Ulrich
Comment by Andreas

It was not working on my site. I suppose, I got a problem with .NET via Windows Update.
blogs.msdn.com/.../8904493.aspx worked for me.

Andreas
Comment by d

worked like a charm!
Thanks!

d
Comment by Duncan Smart

* Start > Run > regedit
* navigate to HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server
* right-click, Rename 'Microsoft SQL Server' folder/key

Comment by devdick

worked thx

devdick
Comment by باسل

Great! But don't forget to restart your machine before running SQL again.

باسل
Comment by Κώστας

Thank you!
The only solution that worked for me!!!

Κώστας