Link to home
Start Free TrialLog in
Avatar of skenny10
skenny10Flag for Canada

asked on

Error loading SQL server management studio - Server 2008 R2

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
Avatar of Phil Davidson
Phil Davidson
Flag of United States of America image

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.

1.

can you check if the services of SS are up?

2.

what is your recent change to the server?
Avatar of Vitor Montalvão
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.
ASKER CERTIFIED SOLUTION
Avatar of skenny10
skenny10
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of skenny10

ASKER

These steps solved the problem.