Go Premium for a chance to win a PS4. Enter to Win

x
?
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
Medium Priority
?
1,392 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 1500 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

916 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