May 24, 2007 at 5:12 pm
I am unable to open SQL Server Management Studio.
The following error message is encountered...
"Package 'Microsoft SQL Management Studio Package' failed to load."
There is no documented errors of this kind in Technet but there were some notes on this problem in obscure internet web sites.
This was a new install of just the Management Studio...client utilities. No betas or anything like that. SQL Server 2000 client utilities are also on this machine. It worked for awhile before this error began. I am unable to do any work in SQL Server 2005 until this problem is solved.
May 24, 2007 at 7:43 pm
Have to reinstall .Net 2.0; if stil doesn't work then have to repair sql client tools installation:
start /wait (your sql path)\SQL2005\Tools\setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS
from cmd prompt;
Good luck.
May 24, 2007 at 10:49 pm
Yes as told by michael you have to reinstall .Net framework 2.0. Also go ahead with a clean installation of client tools from the machine you try to connect.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
May 25, 2007 at 6:35 am
I reinstalled .NET 2.0 last night. Did not fix the problem.
Moving to SQL Client Tools...By "clean install" you mean both uninstall and reinstall client tools, correct?
If so, does it matter if I miss removing some of the registry stuff that uninstall does not automatically remove?
May 15, 2008 at 5:37 pm
Following steps fixed my problem:
1. Reinstalled .Net 2.0;
2. Repaired "sql client tools installation" from cmd prompt:
...SQL2005\Tools\setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS
-vm
May 27, 2008 at 9:17 am
Could this also fix an install issue with SQL Server 2005 Standard Edition? The same error is occurring and the SSIS services will not start.
May 27, 2008 at 9:25 am
SSC Rookie,
Steps i listed are for client tool related issues (Standard Edition included), not sure they will help with SSIS service issue.
-vm
October 13, 2008 at 10:22 am
I suddenly encountered this problem today on my Windows Vista laptop. SQL Server 2005 SP2 had been installed for 5 months and was working fine.
In my case the solution was insufficient disk space, which Vista had warned me about on startup today. I freed up enough disk space so that I had at least 10% of disk space free, and the problem went away. I did not reinstall .NET 2.0, or SQL Server, or run any application repairs.
April 21, 2009 at 1:09 am
Working well Thanks .
June 3, 2009 at 1:32 pm
Thx a lot, its working
June 24, 2009 at 1:28 pm
Hello, I am getting the same message and I have done all steps above and I still get the failed to load message. But I can lauch it fine if opening a sql file. I did find that by switching XP apperance to Wndows Classic look, the regular menu short cut works. I am running XP SP2 with 4GB ram on Latitdue D630 laptop
June 25, 2009 at 12:24 am
Install xp sp3 & try again. !
June 25, 2009 at 8:02 am
Thanks for the info. SPs pushes are controlled by my company. In fact I thought I was on SP2 but looing this morning I am on SP3. So that not the issue.
August 27, 2009 at 1:18 pm
I had this problem today. I went into 'Add/Remove Programs' and did a 'Repair' on .NET 3.5 SP1 and it seems to have resolved the problem.
October 20, 2009 at 9:44 am
Got my SQL Management Studio 2005 to work again by doing a Repair on .NET 3.5 SP1 through Add or Remove Programs. When I started Management Studio afterwards, it configured "for first time use" and then opened successfully. I had to dock the Object Explorer window to its usual location at the left.
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply