I am trying to upgrade from sql 2012 (11.0.6020) to sql 2014 sp1.

  • I get an error that it cannot upgrade. These are the features that it is trying to update.

    Database engine services

    sql server replication

    full-text and semantic extractions for search

    data quality services

    Shared features

    client tools connectivity

    integration services

    client tools sdk

    Management tools - complete

    Its a development server, so I don't actually need full-text extractions or data quality services. I've included an attachment that is a screenshot of the error. Anybody else had this problem?

  • fantom (4/11/2016)


    I get an error that it cannot upgrade. These are the features that it is trying to update.

    Database engine services

    sql server replication

    full-text and semantic extractions for search

    data quality services

    Shared features

    client tools connectivity

    integration services

    client tools sdk

    Management tools - complete

    Its a development server, so I don't actually need full-text extractions or data quality services. I've included an attachment that is a screenshot of the error. Anybody else had this problem?

    What are the source and target editions? (Express, Development, Standard etc.)

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • Source and target editions are both enterprise.

  • fantom (4/11/2016)


    Source and target editions are both enterprise.

    Enterprise on a dev server?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • Enterprise in dev aside, there are a few things to check -- 1) you cannot add features during an upgrade, you can only upgrade what's already there. Make sure you aren't trying to add features. 2) Check the versions in terms of 32/64 bit. You have to go 32-32 and 64-64. If you upgrade a 32 bit install with 64 bit binaries you will have issues. Check those out.

  • fantom (4/11/2016)


    Source and target editions are both enterprise.

    Are you certain about that? Check @@version, check the installer for what edition it is.

    The error message you posted indicates an edition change.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Microsoft SQL Server 2012 (SP3) (KB3072779) - 11.0.6020.0 (X64)

    Oct 20 2015 15:36:27

    Copyright (c) Microsoft Corporation

    Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)

  • Can you browse to the <root>\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log area of the server and look for a Detail.txt? There should be a clearer error message in there somewhere.

  • And I saw these:

    (01) 2016-04-11 13:01:22 Slp: Sco: File '\\ae-it-fileprod1\AE-InfoTech\Software\Servers\SQL Server 2014 SP1\SQL Standard 2014 x64 SP1\x64\setup\x64\sql_fulltext.msi' does not exist

    (01) 2016-04-11 13:01:22 Slp: Sco: File '\\ae-it-fileprod1\AE-InfoTech\Software\Servers\SQL Server 2014 SP1\SQL Standard 2014 x64 SP1\x64\setup\x86\sql_fulltext.msi' does not exist

    (01) 2016-04-11 13:01:22 Slp: Sco: File '\\ae-it-fileprod1\AE-InfoTech\Software\Servers\SQL Server 2014 SP1\SQL Standard 2014 x64 SP1\x64\setup\x64\sql_dq.msi' does not exist

    (01) 2016-04-11 13:01:22 Slp: Sco: File '\\ae-it-fileprod1\AE-InfoTech\Software\Servers\SQL Server 2014 SP1\SQL Standard 2014 x64 SP1\x64\setup\x86\sql_dq.msi' does not exist

    I saw some other errors and realized that my 2014 SP1 install media was standard. My SQL 2014 media was enterprise, so I installed that one.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply