Solved

Error loading SQL server management studio - Server 2008 R2

Posted on 2014-12-05
5
832 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 50

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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

705 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