SQL SERVER – Fix Error – Package ‘Microsoft SQL Management Studio Package’ failed to load in SQL Server Management Studio

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

SQL SERVER - Fix Error - Package 'Microsoft SQL Management Studio Package' failed to load in SQL Server Management Studio packagefail

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.

Reference: Pinal Dave (https://blog.sqlauthority.com)

,
Previous Post
MySQL – Dynamic SQL with EXECUTE and PREPARE Statements
Next Post
Developer’s Life – Every Developer is a Sherlock Holmes

Related Posts

13 Comments. Leave new

  • Hi, this fix error but when restart computer I get error again… What I can do?

    Reply
  • 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.

    Reply
    • 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…

      Reply
  • didn’t worked for me but
    Used .NET Framework Setup Cleanup Utility and delete version above required

    Reply
  • Repairing the .NET Framework on Control Panel worked for me.

    Thanks Pinal :)

    Reply
  • 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.

    Reply
  • I used the method 1, It worked me.
    Thanks !!!!!

    Reply
  • Devshree zeple
    April 16, 2017 6:31 pm

    Not working .

    Reply
  • Devshree zeple
    April 18, 2017 7:36 pm

    No . not work any solution .

    Reply

Leave a Reply

Menu