June 21, 2014 at 8:40 pm
I've got SQL Server 2008 R2 Developer Edition on my desktop. I'm trying to upgrade it to SQL Server 2014 Developer Edition. I've run the Update Advisor and that went OK, no errors that I could see. Then I tried upgrading to SQL 2014, but that failed saying that I needed to install Service Pack 2 for SQL 2008. I downloaded SP2 and tried running it, but that failed saying that there isn't an instance of SQL 2008 R2 on my system. So now I've got a situation in which I cannot upgrade to SQL 2014, because it needs me to install the SQL 2008 SP2 installed, but it won't install that because it can't find SQL 2008 on my PC.
So what do I do?
Rod
June 22, 2014 at 2:04 am
Doctor Who 2 (6/21/2014)
I've got SQL Server 2008 R2 Developer Edition on my desktop. I'm trying to upgrade it to SQL Server 2014 Developer Edition. I've run the Update Advisor and that went OK, no errors that I could see. Then I tried upgrading to SQL 2014, but that failed saying that I needed to install Service Pack 2 for SQL 2008. I downloaded SP2 and tried running it, but that failed saying that there isn't an instance of SQL 2008 R2 on my system. So now I've got a situation in which I cannot upgrade to SQL 2014, because it needs me to install the SQL 2008 SP2 installed, but it won't install that because it can't find SQL 2008 on my PC.So what do I do?
Quick thougt, make certain your databases are in a safe place, remove all sql residuals from the system and do a clean install of 2014.
😎
June 22, 2014 at 3:30 pm
Do you mean something like just uninstall SQL 2008 and then put on SQL 2014? (Making sure that I've disconnected the databases or did a full backup first.)
Rod
June 23, 2014 at 4:15 am
Quick question: you're not getting confused between 2008 and 2008 R2, are you? They're separate products with separate service packs, so if you downloaded the one for 2008 when you actually meant to get 2008R2, it would explain why it says there isn't an instance of that version on your system.
June 23, 2014 at 5:54 am
Yeah, it sounds like you might be trying to put 2008R2 on 2008 or vice versa. Double check your installation version. You can validate it against information on this web page.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 23, 2014 at 7:54 pm
paul.knibbs (6/23/2014)
Quick question: you're not getting confused between 2008 and 2008 R2, are you? They're separate products with separate service packs, so if you downloaded the one for 2008 when you actually meant to get 2008R2, it would explain why it says there isn't an instance of that version on your system.
You're question is a good one, but when I was going through the process of trying to upgrade to 2014, and it failed, one of the two things it told me I had to do was install SP2 for SQL 2008; not 2008 R2. I too was surprised, but what the heck, I figured that the installer should know what it wants.
Rod
June 30, 2014 at 4:06 am
As Paul and Grant say, check what you actually downloaded. You are being asked to install Windows 2008 Sp2, not SQL 2008 SP2.
Service Pack 2 for Windows 2008 is not the same as Service Pack 2 for Windows 2008 R2, and is also not the same as SP2 for SQL 2008.
If I try to install SP2 for W2008 on my W2008 test environment, it works OK. If I try to install SP2 for W2008 R2 on my W2008 test environment, it moans that it can not find an instance of Windows 2008 R2.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
July 1, 2014 at 4:47 am
Doctor Who 2 (6/22/2014)
Do you mean something like just uninstall SQL 2008 and then put on SQL 2014? (Making sure that I've disconnected the databases or did a full backup first.)
Why not just install a named instance of 2014?
I'll just take a moment to appreciate the confusion this stupid stupid stupid "R2" thing from MS causes. None of us seem to know what you've got installed, what you're being asked to install, and what you've actually downloaded 😀 The madness has definitely consumed Ed because he's veered off on a tangent about the OS 😛
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply