I'm trying to upgrade SQL Server 2005 sp4 to SQL Server 2008 R2. However on the upgrade wizard doesn't show me any instances to upgrade. Any ideas?
The instance is there just fine. I can connect via sql mgmt studio.
-
Possible permissions issue? Can you launch the upgrade advisor with an account you know has access to the instance?– SQLRockstarCommented Aug 15, 2013 at 18:39
-
What edition is already present, and what edition are you trying to install?– Aaron BertrandCommented Aug 15, 2013 at 18:50
-
Standard to Standard.– Chris-AZCommented Aug 15, 2013 at 18:52
-
1And they're both 64-bit?– Aaron BertrandCommented Aug 15, 2013 at 18:55
-
3Hmmm....missing a file? social.msdn.microsoft.com/Forums/sqlserver/en-US/…– SQLRockstarCommented Aug 15, 2013 at 18:58
|
Show 1 more comment
1 Answer
I had the same issue when trying to upgrade SQL Express 2014 to 2016, as mentioned by @SQLRockstar for me the problem was missing SQL msi files in C:\Windows\Installer directory, so I restored msi cache by using FixMissingMSI tool. It is mentioned in Microsoft documentation together with other ways to fix that problem. After that installer was able to see my instances and upgrade them.
