CODEWITHSUNDEEP
sql-serversql-server-2008ssms
Yaz
Yaz

Reputation: 367

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

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

Upvotes: 14

Views: 48695

Answers (10)

RotatingWheel
RotatingWheel

Reputation: 1051

I tried the following, I had same problem for sql server 2008 r2 release

  • Renamed HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server
  • Reinstall SQL server
  • Repairer SQL server
  • Reinstall management studio for 2008 r2

All above did not help but new fresh and latest management studio installation helped and works fine now.

Upvotes: 0

Krishna Choudhari
Krishna Choudhari

Reputation: 476

This error due to managment studio did not detect dot net framework hence uninstall dot net 4 and reinstall it. I tried that , it's working.

Upvotes: 0

Salina Putmon
Salina Putmon

Reputation: 1

I used the 'Repair' feature of the 'SQL Server Installation Center' to repair the instance. It worked like a charm for me.

Upvotes: 0

Sathish
Sathish

Reputation: 1

It's worked for me after delete Local user profile. (Logoff and login as Admin delete user profile and re-login).

Upvotes: -1

Adriaan Koster
Adriaan Koster

Reputation: 16209

I had this problem on a Windows 2008 r2 server. The solution was to right-click on the icon and select 'Run as Administrator'.

Upvotes: 0

Karthick Selvam
Karthick Selvam

Reputation: 31

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

Upvotes: 3

Dan
Dan

Reputation: 519

I used the 'Repair' feature of the 'SQL Server Installation Center' to repair <Shared Tools>, rather than an instance. Worked a treat.

Upvotes: 0

sinnerinc
sinnerinc

Reputation: 342

Had the same issues, started to happen to me out of the blue. Tried probably everything I could find on the network without success.

I am running Windows 7, and what finally helped was installing Service Pack 1 (I hadn't had it before).

Upvotes: 0

Shaikh Farooque
Shaikh Farooque

Reputation: 2630

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/

Upvotes: 13

Abdallah Ghrb
Abdallah Ghrb

Reputation: 193

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.

Upvotes: 1

Related Questions