[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1719
  • Last Modified:

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
0
venmarces
Asked:
venmarces
  • 4
  • 3
1 Solution
 
NormanMainaCommented:
Can you try re-installing .Net Framework 2.0 ?
0
 
NormanMainaCommented:
and then install the VC++ 2005 components
http://www.microsoft.com/download/en/details.aspx?id=3387
0
 
venmarcesAuthor Commented:
Thanks for your help, but both suggestions were not working for me.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
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
 
NormanMainaCommented:
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:
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
 
venmarcesAuthor Commented:
This repaired the issue instead of installing the full version of SQL Server with risk of data lose
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now