When trying to open SQL Server Management Studio i receive the error "Package 'Microsoft SQL Management Studio Package' failed to load"

When I try to open Microsoft SQL Management Studio I receive the above error.  This has just happened recently but i'm not sure what caused it.

I'm not sure if this is causing it but when I look at the services I notice that the SQL Server Integration Services is stopped.  When I try to start this I see it fails and generates the following error in the application log:

Source: .NET Runtime 2.0 Error
Event:    5000

Can anyone advise me how to resolve this problem please ?

Many thanks in advance
PurityITAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Richard LeeConnect With a Mentor Software EnthusiastCommented:
I don't think installing .NET 3.0/3.5 will help. If SQL Management studio & the Sql Management Object require .NET 2.0 then those assemblies will be the ones used.

Check this post: http://forums.msdn.microsoft.com/en-US/clr/thread/a925c6c5-6b16-4f19-a2cc-f232b89d4a74/ which has identified that the application may need administrative priviledges when running.

Right Click on the SQL Management Studio Icon and Run as Administrator to see if this solves the problem.

Also you may want to try installing the update again for .NET 2.0 and diagnose the problem if it does not install again.

Thanks
0
 
Richard LeeSoftware EnthusiastCommented:
There is not much information here to go on however you can try to repair the .NET 2.0 runtime; before trying check the event log (Control Panel / Administrative Tools / Event Viewer) and see if there is a more detailed error as to why the application failed to load.

Microsoft .NET Framework 2.0.

To obtain the Microsoft .NET Framework Version 2.0 Redistributable Package (x86), visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?familyid=0856EACB-4362-4B0D-8EDD-AAB15C5E04F5 (http://www.microsoft.com/downloads/details.aspx?familyid=0856EACB-4362-4B0D-8EDD-AAB15C5E04F5)

To obtain the Microsoft .NET Framework Version 2.0 Redistributable Package (IA64), visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?familyid=0856EACB-4362-4B0D-8EDD-AAB15C5E04F5
0
 
PurityITAuthor Commented:
Hi DaTribe and thanks for your help.

When I try and open up SQL Management studio the only error that is generated is the error above and this is the description that is in it:

EventType clr20r3, P1 msdtssrvr.exe, P2 9.0.242.0, P3 443f5b12, P4 mscorlib, P5 2.0.0.0, P6 471ebc5b, P7 1b08, P8 10, P9 system.security.security, P10 NIL.

I noticed that on Monday an update for .NET Framework SP1 failed to install and wonder if that may be related.

If I installed .NET Framework v3.0 would this help ?

Many thanks in advance
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.