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,380 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
ID: 21820555
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
ID: 21820634
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
ID: 21820755
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
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.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

830 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