Solved

Error loading SQL server management studio - Server 2008 R2

Posted on 2014-12-05
5
680 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
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 10

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 47

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.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
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…

786 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