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

Question

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.

Answer 1

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

Answer 2

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/