[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Error loading SQL server management studio - Server 2008 R2

Posted on 2014-12-05
5
Medium Priority
?
1,137 Views
Last Modified: 2014-12-14
I am running SQL Server 2008 R2. When I attempt to open up SQL server management studio today I am presented with the following error message:

C:\Program Files (x86)\Microsft SQL Server\100\Tools\Binn\Vsshell\Common7\IDE\Ssms.exe
The application has failed to start because its side-by-side configuration is incorrect.

I have run the sxstrace tool and I am presented with the following information:

ERROR: Cannot resolve reference Microsoft.VC80.CRT,processorArchitecture="x86",publicKeyToken="1fc8b3b9a1e18e3b",type="win32",version="8.0.50727.4027".
ERROR: Activation Context generation failed.

What do I need to do at this point to resolve this error message/

I appreciate your assistance.

Sean
0
Comment
Question by:skenny10
[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
5 Comments
 
LVL 7

Expert Comment

by:Phil Davidson
ID: 40484316
It looks like something got corrupt in the SQL Server application.  I would do a backup of the server (especially the data).  Then I would uninstall SQL Server 2008 R2 SSMS completely.  Then I would reinstall it.
0
 
LVL 11

Expert Comment

by:HuaMinChen
ID: 40484539

1.

can you check if the services of SS are up?

2.

what is your recent change to the server?
0
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 40486301
SSMS it's only a GUI not the engine at all so try to reinstall only the Management Studio from the setup binaries.
You didn't mention but check if you have the SP3 installed. Can fix some bug that you have.
0
 

Accepted Solution

by:
skenny10 earned 0 total points
ID: 40489991
Thanks to all for responding. I managed to solve the issue:

https://technet.microsoft.com/security/bulletin/
 
Selected the product as "Microsoft Visual C++ 2005 Service Pack 1 Redistributable Package Microsoft Visual C++ 2008 Service Pack 1" It then showed the following required updates.


Date / Bulletin Number / KB Number / Title / Bulletin Rating

4/12/2011 MS11-025 2500212 Vulnerability in Microsoft Foundation Class (MFC) Library Could Allow Remote Code Execution Important

7/28/2009 MS09-035 969706 Vulnerabilities in Visual Studio Active Template Library Could Allow Remote Code Execution Moderate

I downloaded and installed the updates.
0
 

Author Closing Comment

by:skenny10
ID: 40498738
These steps solved the problem.
1

Featured Post

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

649 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