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

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 (http://blog.sqlauthority.com)

About these ads

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

  1. 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.

    Like

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

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s