Solved

Cannot install SP2, upgrade fails

Posted on 2008-06-26
3
250 Views
Last Modified: 2012-08-14
After installing SQL Server 2005 Enterprise x64 on a Cluster, I find I'm unable to patch to SP2. Some services patch, but Database Services and Integration Services always fail.

The curious thing is, when I select @@version from within SSMS, it reports the version as SP2:

Microsoft SQL Server 2005 - 9.00.3042.00 (X64)   Feb 10 2007 00:59:02   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

I'm hesitant to proceed knowing there was a failure on install. Can anyone advise? I've attached the contents of the SQL9_Hotfix_KB921896_sqlrun_sql.msp.log and DTS9_Hotfix_KB921896_sqlrun_dts.msp.log files for reference.



DTS9-Hotfix-KB921896-sqlrun-dts..zip
NS9-Hotfix-KB921896-sqlrun-ns.ms.zip
0
Comment
Question by:PapaStevens
  • 2
3 Comments
 

Author Comment

by:PapaStevens
ID: 21876734
Apologies, I've edited the question to remove the staggeringly long code snippet and have attached the relevant log files individually.
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 21886099
Check your DCOM -- Go into DCOMCnfg --> Component Services --> Computers --> My Computer --> Right click Properties --> Default Properties tab.

The Default Authentication Level should be Connect and the Impersonation Level be Identify.
0
 

Accepted Solution

by:
PapaStevens earned 0 total points
ID: 21898732
Turns out the issue involved the service account not having appropriate domain permissions. Looks like it has to have some minimum domain permissions to successfully add accounts to groups.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question