April 7, 2017 at 12:01 pm
My test server is running SQL Server 2012 SP3 on Windows Server 2008R2 SP1. I’m practicing an upgrade to SQL Server 2014 SP2. We downloaded the ISO from Microsoft.
I ran SETUP from the ISO (mounted as a dvd) to do the install, and it failed to update SQL Server Database Engine Services and other components. It did update SSMS and other tools. The error message demanded that I run SETUP to uninstall SS12. After doing this SQL Server 2014 installed ok.
Why must I run:
setup /q /action=uninstall /instanceid=MSSQLSERVER /features=RS,SQLENGINE
before using SETUP interactively to install SQL Server 2014?
I don’t recall this issue on prior major SQL Server version upgrades.
Thanks for any useful ideas.
April 7, 2017 at 12:21 pm
Was there a change in Edition ?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
April 7, 2017 at 12:34 pm
I am upgrading SQL Server 2012 SP3 to SQL Server 2014 SP2. I want to keep using the default instance.
April 7, 2017 at 1:05 pm
That doesn't answer the question. Was there a change in Edition. That's a PART of your SQL Server version. For example, you can get SQL Server Standard Edition, or SQL Server Enterprise Edition, or SQL Server Developer Edition, or SQL Server DataCenter Edition. Those are all possible Editions of any given version of SQL Server, such as SQL 2012, SQL 2014, or SQL 2016.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
April 7, 2017 at 1:07 pm
Both sides are Standard edition.
Sorry for misunderstanding the question.
April 7, 2017 at 1:30 pm
The only thing I can think of is maybe something OS - related ??? I'm just thinking that Windows Server 2012 might not have had that same issue... Of course, what do I know... I've always got a 50/50 chance at being right though... not that such should be relied on, mind you...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
April 10, 2017 at 4:06 pm
There will be no issue. I have done multiple.
April 10, 2017 at 7:33 pm
Thank you for your thoughts. I've done SQL Server updates since updating SQL Server 7 to 2000, and have not seem this. But, after doing the uninstall from a command line the install seems fine.
May 27, 2017 at 1:09 am
I came across the samre issue. return man 3 unblocked
May 27, 2017 at 1:09 am
I came across the samre issue. return man 3 unblocked
May 28, 2017 at 7:05 am
I detached my databases, recording the file locations, uninstalled SQL Server 2012 and installed SQL Server 2014, and then attached the databases. You need to do this carefully so you save any information about your current configuration you might need. Be careful with MSDB and SSISDB..
I am planning to install SS14 on a new server and moving production over to it. I will be upgrading our DEV server this way.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply