none
Trouble installing KB3194714 over SQL Server 2014 SP2

    Question

  • Hello,

    I am having trouble installing a required patch my Cyber Security team wants installed.  It is KB3194714.  When I attempt to install it manually (downloaded here... https://www.microsoft.com/en-us/download/details.aspx?id=54190) the option to patch the engine is greyed out and cannot be checked.  I attempted the installation using windows update.  The KB shows up as an important update.  I install the update and windows update lets me know a reboot is required.  I reboot the server, but SQL Server version number is still 12.0.5000.  The patch shows up as installed in programs and features and it still shows up as an important update .  I've checked the forums, and there seems to be incompatibility issues with some other patches, but I don't have those patches installed.  I'm not sure where to go from here.  Any help would be appreciated.

    Thanks.

    Monday, February 6, 2017 5:23 PM

All replies

  • Hello,

    I am having trouble installing a required patch my Cyber Security team wants installed.  It is KB3194714.  When I attempt to install it manually (downloaded here... https://www.microsoft.com/en-us/download/details.aspx?id=54190) the option to patch the engine is greyed out and cannot be checked.  I attempted the installation using windows update.  The KB shows up as an important update.  I install the update and windows update lets me know a reboot is required.  I reboot the server, but SQL Server version number is still 12.0.5000. 

    I believe the patch is installed, I have a hunch that the GDR update version is not shown by productversion. What is output of select @@version.

    Add below in your select query and post output

    select serverproperty('ProductBuildType')


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP


    Monday, February 6, 2017 5:54 PM
    Moderator
  • Hello,

    I am having trouble installing a required patch my Cyber Security team wants installed.  It is KB3194714.  When I attempt to install it manually (downloaded here... https://www.microsoft.com/en-us/download/details.aspx?id=54190) the option to patch the engine is greyed out and cannot be checked.  I attempted the installation using windows update.  The KB shows up as an important update.  I install the update and windows update lets me know a reboot is required.  I reboot the server, but SQL Server version number is still 12.0.5000.  The patch shows up as installed in programs and features and it still shows up as an important update .  I've checked the forums, and there seems to be incompatibility issues with some other patches, but I don't have those patches installed.  I'm not sure where to go from here.  Any help would be appreciated.

    Thanks.

    Monday, February 6, 2017 5:56 PM
  • Alex please dont start multiple threads for same question. Please see my response above. On forum you have to just initiate one thread for the question multiple thread is not allowed

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Monday, February 6, 2017 6:05 PM
    Moderator
  • here is the output for @@version..

    Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (X64)
     Jun 17 2016 19:14:09
     Copyright (c) Microsoft Corporation
     Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

    ProductBuildType returns 'null'. 

    I'm sure the patch is installed, it just isn't installed on the database instance.  I am only able to select the shared features while installing manually.  See attached image.  MSSQLSERVER cannot be selected.

     

    Monday, February 6, 2017 6:20 PM
  • I hope you applied 64 bit GDR update and I believe it should reflect. Not sure why it is not reflecting. Can you post output from this script.

    Use the first one.


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Monday, February 6, 2017 6:29 PM
    Moderator
  • I'm pretty certain I applied the 64bit version.  Thank you for your attention so far.  Here is the output from the script...

    ---------------------------------------------------------------------------------------------------------

    --//Your current Microsoft SQL Server information:

    ---------------------------------------------------------------------------------------------------------

    Product Version:          12.0.5000.0

    Product Name:             SQL Server 2014

    Product Level:            SP2

    Product Edition:          Enterprise Edition: Core-based Licensing (64-bit)

    Product Update Level:    

    Product Update Reference:

    ---------------------------------------------------------------------------------------------------------

    Support Lifecycle stage: Mainstream Support Phase. For additional information refer to

    https://support.microsoft.com/en-us/lifecycle/search?sort=PN&alpha=SQL%20Server&Filter=FilterNO, and Q6, Q18

    in the FAQ section of Support Lifecycle page at: https://support.microsoft.com/en-us/lifecycle#gp/lifePolicy

    ---------------------------------------------------------------------------------------------------------

    Full information:

    Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (X64)

    Jun 17 2016 19:14:09

    Copyright (c) Microsoft Corporation

    Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

    ---------------------------------------------------------------------------------------------------------

    --//Recommended updates:

    --### RTM -> QFE or GDR

    --### SP  -> QFE or GDR

    --### QFE -> QFE

    --### GDR -> GDR or QFE

    ---------------------------------------------------------------------------------------------------------

    You have already installed the latest service pack.

    Install the latest Cumulative Update (CU) of SP2:  CU3, <https://support.microsoft.com/en-us/kb/3204388>

    ---------------------------------------------------------------------------------------------------------

    ###### QFE branch updates

    ---------------------------------------------------------------------------------------------------------

    12.0.2548 (SQL Server 2014 RTM QFE) http://support.microsoft.com/en-us/kb/3045323

    ---------------------------------------------------------------------------------------------------------

    Note, if you don't want to upgrade to latest service pack right now, we recommend you install the latest

    Cumulative Update CU3 of SQL Server 2014 SP2.

    Install the latest Cumulative Update (CU) of SP2: CU3, <https://support.microsoft.com/en-us/kb/2936603>

     

    ---------------------------------------------------------------------------------------------------------

    --//You can upgrade to any of the following product(s):

    ---------------------------------------------------------------------------------------------------------

    SQL Server 2016 Enterprise

    SQL Server 2016 Business Intelligence

     

    For additional information about supported version and edition upgrades refer to:

    https://technet.microsoft.com/en-us/library/ms143393(v=sql.120).aspx


    Monday, February 6, 2017 6:42 PM