Home > Default > SQL 2012 enterprise service pack 2 fails to install

SQL 2012 enterprise service pack 2 fails to install

November 30Hits:0
Advertisement
Hi,
I have installed SQL 2012 sp2 x64 onto the main service manager 2012 database, but it fails on the datawarehouse SQL server. Both are going from SP1 to SP2. Servers are running windows server 2012 sp1 x64.
On the datawarehouse server it gets so far and then just displays a message of completed, with all the other fields blank.
The text file for the Summary of the installation has been copied below:
Overall summary:
  Final result:                  The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files.
  Exit code (Decimal):           -2068709375
  Start time:                    2015-01-09 13:55:32
  End time:                      2015-01-09 14:04:09
  Requested action:              Patch
Instance MSSQLSERVER overall summary:
  Final result:                  The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
  Exit code (Decimal):           -2068709375
  Exit facility code:            1202
  Exit error code:               1
  Exit message:                  The NT service 'MSSQLServerOLAPService' could not be stopped.
  Start time:                    2015-01-09 14:00:18
  End time:                      2015-01-09 14:04:01
  Requested action:              Patch
  Exception help link:          
http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.5058.0&EvtType=0xAC454CB1%400xF762992B%401202%401&EvtType=0xAC454CB1%400xF762992B%401202%401
Machine Properties:
  Machine name:                  SCSDWM01
  Machine processor count:       4
  OS version:                    Future Windows Version
  OS service pack:              
  OS region:                     United Kingdom
  OS language:                   English (United States)
  OS architecture:               x64
  Process architecture:          64 Bit
  OS clustered:                  No
Product features discovered:
  Product              Instance             Instance ID                   
Feature                                  Language            
Edition              Version         Clustered  Configured
  SQL Server 2012      MSSQLSERVER          MSSQL11.MSSQLSERVER            Database Engine Services                
1033                 Enterprise Edition   11.1.3153.0     No         Yes      
  SQL Server 2012      MSSQLSERVER          MSSQL11.MSSQLSERVER            Full-Text and Semantic Extractions for Search 1033                
Enterprise Edition   11.1.3000.0     No         Yes      
  SQL Server 2012      MSSQLSERVER          MSAS11.MSSQLSERVER             Analysis Services                       
1033                 Enterprise Edition   11.1.3130.0     No         Yes      
  SQL Server 2012      MSSQLSERVER          MSRS11.MSSQLSERVER             Reporting Services - Native             
1033                 Enterprise Edition   11.1.3153.0     No         Yes      
  SQL Server 2012                                                         
Management Tools - Basic                 1033                 Enterprise Edition   11.1.3153.0    
No         Yes      
  SQL Server 2012                                                         
Management Tools - Complete              1033                 Enterprise Edition   11.1.3130.0    
No         Yes      
  SQL Server 2012                                                         
SQL Server Data Tools - Business Intelligence for Visual Studio 2012 1033                                     
11.1.3402.0     No         Yes      
  SQL Server 2012                                                         
Integration Services                     1033                 Enterprise Edition  
11.1.3153.0     No         Yes      
Package properties:
  Description:                   Microsoft SQL Server 2012
  ProductName:                   SQL Server 2012
  Type:                          RTM
  Version:                       11
  SPLevel:                       2
  KBArticle:                     KB2958429
  KBArticleHyperlink:           
http://support.microsoft.com/?kbid=2958429
  PatchType:                     SP
  AssociatedHotfixBuild:         0
  Platform:                      x64
  PatchLevel:                    11.2.5058.0
  ProductVersion:                11.0.2100.60
  GDRReservedRange:              11.0.5300.0:11.0.5499.0
  PackageName:                   SQLServer2012-KB2958429-x64.exe
  Installation location:         c:\ce370c3d01e3ec4095540d8578cc7e\x64\setup\
Updated product edition:
  Instance             Edition            
  MSSQLSERVER          Enterprise         
User Input Settings:
  ACTION:                        Patch
  ALLINSTANCES:                  false
  CLUSTERPASSIVE:                false
  CONFIGURATIONFILE:            
  ENU:                           false
  HELP:                          false
  IACCEPTSQLSERVERLICENSETERMS:  true
  INDICATEPROGRESS:              false
  INSTANCEID:                    <empty>
  INSTANCENAME:                  <empty>
  QUIET:                         false
  QUIETSIMPLE:                   false
  SQMREPORTING:                  false
  UIMODE:                        Normal
  X86:                           false
Rules with failures:
Global rules:
There are no scenario-specific rules.
Rules report file:               C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20150109_135509\SystemConfigurationCheck_Report.htm
Any ideas on why this has happened and how to fix the error?
Thanks.
Jaz

Answers

Hello,
Open the errorlog file on the following path C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log. There
you will find a more descriptive error.
I received that error before. The workaround I used is contained on the following article:
http://www.sqlcoffee.com/Troubleshooting112.htm
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com

Read other 6 answers

Tags:

Related Articles

  • SQL 2012 enterprise service pack 2 fails to installNovember 30

    Hi, I have installed SQL 2012 sp2 x64 onto the main service manager 2012 database, but it fails on the datawarehouse SQL server. Both are going from SP1 to SP2. Servers are running windows server 2012 sp1 x64. On the datawarehouse server it gets so f

  • Windows 2008 Server R2 - Service Pack 1 Failed to installOctober 11

    A few nights ago I deployed Service Pack 1 for Windows 2008 Server R2 x64.  The update failed to install after 3 attempts using the Windows Update manager.  After the third time I checked the system properties which states that SP1 is installed, yet

  • Vista 32bit, Service Pack 1 fails to install.November 30

    I'm consistantly getting an error attempting to install Vista Service Pack 1 from Windows Update. Here's the error code: Install status: Failed Code 80070057 All other patches installed fine. This is on a Mac Pro 1,1, 4GB RAM, Boot Camp 3.1. Let me k

  • SQL 2012 Reporting ServicesNovember 30

    Doesn't SQL 2012 Reporting Services require IIs to be installed? It appears to be working on a Windows 2012 server without IIs installed.Hi, IIS is no longer needed for reporting services the web service and site are native to the ssrs service. This

  • Unable to install SQL 2012 Enterprise on Windows 8.1 OSOctober 11

    I had installed SQL 2012 Enterprise on my Windows 8.1 and was running successfully. I faced some SSRS & SSIS Authentication issue. So i decided to uninstall SQL and re-install it. On doing so, i am unable to install it. Wizard disappears from this sc

  • SQL 2012 Reporting Services hangOctober 11

    Hello, we are using SQL 2012 Reporting Services with Dynamics CRM Reports. Since a few wekkes every other day it looks like my Reproitng services do fail. CRM Reports do not work and  If I try to browse https://sql2012.mobilex.intra/Reports/Pages/Fol

  • Has mssql2008r2 got "Cumulative Update Package 6 for SQL Server 2008 Service Pack 1"November 30

    hi, I have Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86)   Apr  2 2010 15:53:02   Copyright (c) Microsoft Corporation  Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)  , i wanted to know ha

  • SQL Server 2008 Service Pack 1 installation problemNovember 30

    I am using Windows 7. Today I saw "Microsoft SQL Server 2008 Service Pack 1 (KB968369)" as an optional update in the updates list. I've tried to intstall it but it failed with Code CF2E222F. I found nothing about this code on the internet. I've

  • High CMEMTHREAD after SQL 2008 R2 Service pack 2 (release version 10.50.4297.0)November 30

    Right after applying SQL 2008 R2 Service pack 2, we notice jump in wait time in CMEMTHREAD with high CPU usage ( ~90%). Someone mention that Trace flag 8048 for newer machine with more than 8 CPU might be the cause of this issue. Can someone verify o

  • Virtual Lab: Exploring SQL Server 2012 Integration Services - Setup script failsNovember 30

    I am trying to work through a Lab, but cannot get past the Setup script stage. The lab is "Exploring SQL Server 2012 Integration Services". I have tried this several times (with new lab instances) and the result is always the same. I double clic

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.643 s.