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,386 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

 Watch the Recording: Learning MySQL 5.7

MySQL 5.7 has a lot of new features. If you've dabbled with an older version of MySQL, it is definitely worth learning.

Question has a verified solution.

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

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 ?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.

623 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