Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We attempted to upgrade SQL 2008 to 2008 R2. It passed the checks with flying colors. But midway through the installation we got the dreaded "No mapping between account names and Security IDs was done" error.

After much Googling, we believe we have fixed the SID issue (we found an invalid SID in the registry for the installation SQL Group and changed it to the correct SID). The first installation attempt finished but did not fully upgrade the 2008 instance, only some of the shared components.

Now we cannot finish running the upgrade. Partway into the installation wizard it shows a screen where it lets you check/uncheck components to be upgraded. These are all pre-checked and cannot be unchecked. When we click "next" it says there is nothing to be upgraded and stops on a validation error. We're pretty much stuck right there. The instance is still SQL 2008 (10.0.2531) not R2 (10.50.1600). For giggles, we tried the "Repair" wizard, it ran to completion but did essentially nothing.

I think what is happening is the installer thinks the instance has already been upgraded, when in reality it has not been fully upgraded to R2.

Short of uninstall/reinstall or installing a named instance (the boss hates named instances with a passion and only allows default instances) is there anything we can do to complete the upgrade to R2?

share|improve this question

migrated from stackoverflow.com Sep 25 '10 at 2:11

This question came from our site for professional and enthusiast programmers.

add comment

2 Answers

You might need to mess around with registry keys in order to get it to work. My recommendation is to migrate to a different box that has a fresh install of R2

share|improve this answer
add comment

Adding to ozamora, I honestly wouldn't trust that instance working with further updates. You could spend quite a while hacking stuff together to get all the pieces thinking straight again, but who's to say you won't have a problem with an update in a couple of months?

Build a new 2008 R2 instance and move your data.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.