Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 262
  • Last Modified:

Cannot install SP2, upgrade fails

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
PapaStevens
Asked:
PapaStevens
  • 2
1 Solution
 
PapaStevensAuthor Commented:
Apologies, I've edited the question to remove the staggeringly long code snippet and have attached the relevant log files individually.
0
 
Jim P.Commented:
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
 
PapaStevensAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now