SQl Server Management Studio do not open because of msvcr80.dll

Hi

I have an instance of SQL Server 2005 installed on my Data server, and now I can not open the SQL Server Management Studio because I am getting an error in the EventsLog that the dll msvcr80.dll is not found.

I tried to get the right version od this DLL .6195 but still having this issue.

I tried also to reinstall only the SSMS component within the DVD and it doesn't work, sounds like it requires the all version installation.

I updates my Windows many times .... without any results.

I found some tools to fix the DLL but most of them need to pay for this, any free tool?

Any help for this

Thank you
venmarcesAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
venmarcesConnect With a Mentor Author Commented:
Here is the solution , is about repairing the SQL Mgmt Studio

1.Insert the SQL Server 2005 installation media into the disk drive.

2.Run the following command from the command prompt:

 start /wait <CD or DVD Drive>\setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=S

Thanks all for your help
0
 
Norman MainaCommented:
Can you try re-installing .Net Framework 2.0 ?
0
 
Norman MainaCommented:
and then install the VC++ 2005 components
http://www.microsoft.com/download/en/details.aspx?id=3387
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
venmarcesAuthor Commented:
Thanks for your help, but both suggestions were not working for me.
0
 
venmarcesAuthor Commented:
Can I reinstall the full instance of SQL Server, will this make me losing my actual databases

I want to know how much risky it is ?
0
 
smuniCommented:
not really, perform a full backup on existing database a nd uninstall all the components then give a server restart. Later you can try to install the SQL server from scratch.

For me, give a try to uninstall the client tools alone then give a server restart. It may help u. Good luck..
0
 
Norman MainaCommented:
You may want to do a clean install of windows and sql server -from scratch.
(back up your data and sql server databases)

msvcr80.dll is a system file and from what i have seen in forums -it can be a problem to resolve if its missing or corrupted.
I would have thought instaling VC++ 2005 components and restarting the server would solve the problem -but you say it does not.

If re-installing windows is not an option,you will have to do with installing sql server management studio in another pc and then connect to your instance with databases in the server.
0
 
venmarcesAuthor Commented:
This repaired the issue instead of installing the full version of SQL Server with risk of data lose
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.