skenny10
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\Vssh ell\Common 7\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,process orArchitec ture="x86" ,publicKey Token="1fc 8b3b9a1e18 e3b",type= "win32",ve rsion="8.0 .50727.402 7".
ERROR: Activation Context generation failed.
What do I need to do at this point to resolve this error message/
I appreciate your assistance.
Sean
C:\Program Files (x86)\Microsft SQL Server\100\Tools\Binn\Vssh
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,process
ERROR: Activation Context generation failed.
What do I need to do at this point to resolve this error message/
I appreciate your assistance.
Sean
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?
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.
You didn't mention but check if you have the SP3 installed. Can fix some bug that you have.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
These steps solved the problem.