Re: 2005 Enterprise sp 2 install fails - 11009

Thank you for your help and your quick response.

1) Q...Was your SQL Server service account a domain administrator account?
A...Having a SQL Server service account as a domain admin? I know that the
service account is not a domain admin.
Are you sure on that. This one big no-no in my world. Huge security issue.

2) Q...How did you install your SQL Server 2005 SP2, locally from your
active node or remotely from a network share folder?
A...Locally with the SP files and running the install on the node that owns
the SQL Server resource group.


Q...If the SP2 patch installation media was on your active node, please
check what the result is if you specify a domain administrator account for
"Remote User Account" during the SP2 installation.
A...My question is: why would I need to specify a domain admin to do a
allegedly simple service pack?
What priveleges are necessary if I can't get a domain admin?




""Charles Wang [MSFT]"" <changliw@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:RH5jko86IHA.5352@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi Frankm,
Thank you for your response.

The error 11009 means "No passive nodes were successfully patched". From
the hotfix setup logs
you sent to me, I found the following error messages:
1. Using PrevRegRootPath: Software\Microsoft\Microsoft SQL Server\MSSQL.1
GetServiceUserGroup failed for MSSQLSERVER, 5
Error Code: 0x80070534 (1332)

Windows Error Text: No mapping between account names and security IDs was
done.

2. Failed to find installation media path due to datastore exception in
FindSetupFolder()

From the two error messages, it seems that this issue is most likely
related to permission and your
SP2 installation path. Based on the two error messages, I would like to
ask you two questions:
1. Was your SQL Server service account a domain administrator account?
You can check this from Services list. Double click your SQL Server
services, switch to the Log On
tab and you can find the service account. If it is not a domain
administrator, try changing it to a
domain administrator on each node to see if it helps.

2. How did you install your SQL Server 2005 SP2, locally from your active
node or remotely from a
network share folder?
If you installed your SQL Server 2005 SP2 from a network share, I
recommend that you try
removing the Hotfix folder and installing the patch only from your active
node.
If the SP2 patch installation media was on your active node, please
check what the result is if
you specify a domain administrator account for "Remote User Account"
during the SP2 installation.

Hope this helps. If you have any other questions or concerns. Have a nice
day!

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.
=========================================================







.

Relevant Pages

  • Re: SQL windows account
    ... > Can the account to run SQL server belong to USER group or ... >>SQL Service account absoloutely does NOT have ... >>Jasper Smith (SQL Server MVP) ... >>> I happened to be a box and DB admin and i have a local ...
    (microsoft.public.sqlserver.security)
  • Re: Backup Issue! Interesting or weird - you decide!
    ... The service account is the account that the SQL Server service runs under. ... Dump is only available on version after SQL 6.5 for compatibility, ...
    (microsoft.public.sqlserver.programming)
  • Re: Backup Issue! Interesting or weird - you decide!
    ... The service account is the account that the SQL Server service runs under. ... Dump is only available on version after SQL 6.5 for compatibility, ...
    (microsoft.public.sqlserver.programming)
  • Re: Error 0x80070534 when changing service account
    ... When you removed the prefix, ... The account has granted Logon as Service right in the domain and in Domain ... The only difference I see is that the SQL Server where the account is ... service account using the Configuration Manager. ...
    (microsoft.public.sqlserver.security)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)