Solved

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

Posted on 2012-03-22
8
1,614 Views
Last Modified: 2012-03-28
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
0
Comment
Question by:venmarces
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 12

Expert Comment

by:NormanMaina
ID: 37754094
Can you try re-installing .Net Framework 2.0 ?
0
 
LVL 12

Expert Comment

by:NormanMaina
ID: 37754153
and then install the VC++ 2005 components
http://www.microsoft.com/download/en/details.aspx?id=3387
0
 

Author Comment

by:venmarces
ID: 37754661
Thanks for your help, but both suggestions were not working for me.
0
How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

 

Author Comment

by:venmarces
ID: 37754736
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
 
LVL 2

Expert Comment

by:smuni
ID: 37758044
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
 
LVL 12

Expert Comment

by:NormanMaina
ID: 37758563
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
 

Accepted Solution

by:
venmarces earned 0 total points
ID: 37759330
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
 

Author Closing Comment

by:venmarces
ID: 37775765
This repaired the issue instead of installing the full version of SQL Server with risk of data lose
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

626 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