Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sqlmangr.exe looking for MSVCR71.dll cluster failover ! Expand / Collapse
Author
Message
Posted Wednesday, September 17, 2008 9:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 26, 2014 7:44 AM
Points: 6,731, Visits: 8,476
- SQL2000 sp4 (cluster ! ) on Windows 2003 32-bit.

Automatic updates enabled

With "reboot needed" message pending when logon to the console.


symptomes:
SQLAgent jobs tend to be hanging for hours (3-5) for jobs that normally complete in 20 minutes.

Action:
stop sqlagent OK

Start SQLAgent causes cluster to failover.

Failover does not succeed because of this

Message "sqlmangr.exe looking for MSVCR71.dll ... try to reinstall ..."


We copied MSVCR71.dll and msvcp71.dll from another server and now things seem to be working again.

Can MS08_040 cause this issue ??


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #571090
Posted Wednesday, September 24, 2008 12:25 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 3:16 PM
Points: 95, Visits: 237
We encountered the same issue today after installing a new version of TSM client software which required a reboot. We have been running SQL 2000 - 8.00.2039 for over a year without this issue so it may not be related to the SP itself.
We do NOT have automatic Win2k3 updates enabled but have applied updates within the past 4 weeks and have rebooted the machine more than twice since the updates were applied.
Post SP4 hotfixes (http://support.microsoft.com/?kbid=894905) does not mention the issue.
Sorry not much help.
Post #575489
Posted Thursday, September 25, 2008 12:31 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 26, 2014 7:44 AM
Points: 6,731, Visits: 8,476
Thank you for the feedback.

We still haven't found the cause of this incident.
We do have a number of servers with sql2000 on it, this is the only cluster that suffered it.

Up until now it runs just fine.


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #576313
Posted Friday, April 17, 2009 9:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 14, 2011 7:04 AM
Points: 20, Visits: 177
Thanks ALZDBA!

I encountered the same issue this morning. After loading the msvcr71 and msvcp71 libraries to the system32 directory, I was finally able to finish the reinstall (I tried following the advice of the error message and uninstalled SQL 2000 to turn around a do a fresh installation - which subsequently failed until copying these files into the system32 directory).

I am going to initiate a restore of the databases from last nights backup so I hope to be up and running again shortly.

Just wanted to thank you.
Post #699547
Posted Saturday, April 18, 2009 4:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 26, 2014 7:44 AM
Points: 6,731, Visits: 8,476
I'm glad it could be of use to you.

We haven't encountered the issue on any other servers (yet) and still don't know what caused the files to be missing.


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #699971
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse