A few simple methods can fix the Microsoft SQL Management Studio Package failed to load error. I recently formatted my computer and reinstalled my machine and I end up on following error:
Package ‘Microsoft SQL Management Studio Package’ failed to load
I was able to fix the error quickly, but while I was searching online, I noticed quite a few of the people have similar error and they struggle to fix it. I have decided to list a few of the ways to fix the error here.
Method 1: Reinstall .NET Framework
Method 2: Start SSMS with Admin privileges
Method 3: Reinstall SQL client with either command prompt or with wizard
Method 4: Delete the registry HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools and try to load the server again.
Let me know if there is any method which works to fix this error and I have missed it.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
Discover more from SQL Authority with Pinal Dave
Subscribe to get the latest posts sent to your email.
13 Comments. Leave new
Hi, this fix error but when restart computer I get error again… What I can do?
This happened to me a couple days after doing a disk cleanup on my windows 7 machine. Before attempting any of the 4 suggestions, I tried rebooting it (Lenovo T420)…as it was coming back up it automatically went into chkdisk. I let it finish — took about 10 minutes — and after the reboot completed I was able to get into SSMS just fine, although I lost all my app settings.
I tried that 4 solutions and I still can not solve the problem. It’s fixed temporaly only when I repair the installation from SQL Server Installation Center, but when restart the PC the problem appear again. At this point I dont understand, why repair works temporaly until next restart? I guess repair process no write something in the registry but until i dont restart i can open and close SSMS normaly…
didn’t worked for me but
Used .NET Framework Setup Cleanup Utility and delete version above required
Thanks for sharing it Ali.
Repairing the .NET Framework on Control Panel worked for me.
Thanks Pinal :)
In my case, my Windows User Profile was corrupt, and I’ve fixed it by removing the corrupt profile from another administrative user, after that, in the next login a new profile was created and SSMS started correctly.
Please explain how u solved and how did u remove corrupt profile step by step
I used the method 1, It worked me.
Thanks !!!!!
Not working .
Sorry. Did you find a solution?
No . not work any solution .
Please share if you find any solution. It would help others.