SQL Server Home
Package 'Microsoft SQL Management Studio Package' failed to load
as Not Reproducible
10/5/2006 2:20:52 AM
User(s) can reproduce this bug
When starting SQL Server 2005 Management Studio, I regularly (at least once a week) get a warning message box (yellow triangle) containing the above error message. If I click on it, I get another message box, this time an error(red circle, white cross) with the same message. If I click that, the program exits. It is not possible to recover from this error without rebooting - subsequent restarts of the software result in the same behaviour. No hint is given as to where to look for error messages or possible resolutions, nor is the option given to report the problem to yourselves.
On examining the System Event Log, I see a series of DCOM errors relating to SQL Servers I have set up that I normally access over a VPN link. These errors occur only once, corresponding to the first time I tried to start SQL Management Studio this morning. The errors are all as follows:
"DCOM was unable to communicate with the computer XXXXXX using any of the configured protocols".
(Where XXXXXX is the name of a server normally accessed over VPN).
Simply starting the management studio should not try to connect to these machines - the connection should be initiated at my request unless I instruct it otherwise; either way it should not cause the software to exit.
SQL Server 2005 SP1 - Developer Edition
Windows XP SP2 Professional
Operating System Language
Steps to Reproduce
Start SQL Server Management Studio with server definitions that do not always exist on a LAN. This is an intermittent problem, so not reproducible as such.
SQL Server Management Studio gives above error message and closes.
SQL Server Management Studio should start.
to post a comment.
Please enter a comment.
Sudarshan Narasimhan [MSFT]
on 8/3/2012 at 1:54 PM
Also check to see if the following locations are present and it contains the files mentioned below.
VSDebugUI.dll --> C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\Packages\Debugger\1033\
vsdebug.dll --> C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\Packages\Debugger\
If for some reason this directory is missing or there is lack of permissions for the account running SSMS, you will get this error. You can use Process Monitor to find this out when opening up SSMS. HTH.
on 1/19/2012 at 4:45 AM
I have just started seeing this problem with SSMS 2008 R2
Ravi Gottumukkala _
on 11/10/2011 at 2:29 PM
after 2 days of google searches and attempts to fix this, finally found a solution.
repairing windows 7 didn't work.
repairing sql installation didn't work.
uninstalling and re-installing .net framework 3.5 didn't work. (by the way this is provided natively in windows 7).
navigate to the ssms.exe executable located at C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\
right click on the file, goto properties, goto 'compatibility' tab and change compatibility mode to 'windows 7'
on 4/19/2011 at 11:43 AM
Getting this problem now with a fresh install of Vista x65 SP2, VS2010 SP1, and SQL 2008 R2. Tried reinstalling, tried repairing, etc. Nothing works.
on 12/21/2009 at 1:58 AM
Agreed, repairing or installing .NET 3.5 SP1 solves the problem.
on 8/27/2009 at 12:15 PM
I had this issue today. I went into Add/Remove Programs and performed a "Repair" on .NET 3.5 SP1 and it seems to have resolved the problem.
on 1/21/2008 at 11:37 AM
Hello - I'm not going to be able to get this in for SQL Srever 2008. This does not mean that the information is not relevant or valid; but we are not able at this time to work on this item. Note that this issue may also be fixed as a result of some framework issues we are dealing with.
Buck Woody, SQL Server Program Manager
on 10/5/2006 at 10:35 AM
I've put this issue in the queue to be looked at for the next general release of SQL Server. I'll request that test look at this, however it would be great if you could provide us a solid repro.
We appreciate that you took the time to log this with us and make the community aware of this issue.
SQL Server Program Manager
to post a workaround.
Please enter a workaround.
on 1/4/2012 at 2:43 PM
I found that renaming the "HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server" registry key solved the issue for me. More info: http://blog.dotsmart.net/2012/01/04/solution-for-package-microsoft-sql-management-studio-package-failed-to-load/
on 10/26/2009 at 4:20 AM
"Reinstalling .Net Framework X.X solved the problem" found at:
© 2014 Microsoft