Home Forums SQL Server 2008 SQL Server 2008 Administration 2008 R2 Windows Updates RE: 2008 R2 Windows Updates

  • September 22, 2017 at 10:22 am

    #1960550

    Michelle-138172 - Friday, September 22, 2017 8:28 AM

    Thanks, Sue! Don't know why MS has to make simple things like this so confusing. 

    It's a  very frustrating business to try to fix windows updates failures. After a lot of digging, it seems I need to run the repair. But after I ran the repair, i was told I'm missing sqlncli.msi. I downloaded the only version I can find, but it still says it's the wrong file. My server has a lot of different versions of VS and SQL. Maybe that's why it's all messed up.

    It's not the first time they hosed out version numbers - it was worse with one they did for 2005.  I guess they do it because they are good at it due to a lot of experience 🙂

    It could be the different versions messing things up - the whole caching process for updates, finding previous installs is just problematic.
    That link you first have in the error has a vbscript to run that tries to fix the paths to installers - it's worth trying that. 
    There is also a link about trying to uninstall when you have issues - not exactly the same but similiar to what you are dealing with and might give you some more things to check: 
     Cleanly Uninstalling Stubborn SQL Server Components

    Sue