Solved

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

Posted on 2008-06-19
3
1,374 Views
Last Modified: 2008-06-19
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
0
Comment
Question by:PurityIT
  • 2
3 Comments
 
LVL 18

Expert Comment

by:Richard Lee
Comment Utility
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
 

Author Comment

by:PurityIT
Comment Utility
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
 
LVL 18

Accepted Solution

by:
Richard Lee earned 500 total points
Comment Utility
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

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now