Solved

Error loading SQL server management studio - Server 2008 R2

Posted on 2014-12-05
5
610 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 45

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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…

744 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now