Error: Package 'Microsoft SQL Management Studio Package' failed to load. In SQL Server Management Studio

46,349

Solution 1

You need to rename or delete the Registry Key for,

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server

Read in detail on :

http://blog.dotsmart.net/2012/01/04/solution-for-package-microsoft-sql-management-studio-package-failed-to-load/

Solution 2

Before re-installing software etc, you might just perform the following simple check.

Right click on the short-cut you use to launch SQL Server Management Studio, then ensure that Start in is set to the same PATH as Target

e.g. if Target is set to

C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe

then Start in should be set to the same path (minus the filename) i.e.

C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\

(On a PC which I was given at work, 'Start in' was blank and this gave the same error as reported in the above posts.)

Solution 3

From a first look at the log, your installation appears to be corrupt as Microsoft.VisualStudio.Shell.Interop.dll is failing to load.

Can you please check to see if Microsoft.VisualStudio.Shell.Interop.dll is in the GAC?

If it is, please run the fusion log (you should find this under C:\Program Files\Microsoft SDKs\Windows\<sdk version>\bin). Go to settings and turn on "log bind errors to disk" and then try running VS. The log file should tell you where the assembly binding failure.

Share:
46,349

Related videos on Youtube

Yaz
Author by

Yaz

Updated on June 28, 2020

Comments

  • Yaz
    Yaz over 3 years

    I had installed SQL Server 2008 R2, the installation was succesful. But I can't open the Management Studio because this error is shown:

    Package 'Microsoft SQL Management Studio Package' failed to load.
    

    Any idea? Thanks.

    enter image description here

Related