?
Solved

Error loading SQL server management studio - Server 2008 R2

Posted on 2014-12-05
5
Medium Priority
?
987 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 51

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

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.
This article explains how to install and use the NTBackup utility that comes with Windows Server.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
Suggested Courses

752 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