Problem: SQL Server 2005 Setup requires administrator permissions on every cluster node

Discussion in 'microsoft.public.sqlserver.clustering' started by Bill Golem, Mar 28, 2009.

  1. Bill Golem

    Bill Golem Guest

    TITLE: Microsoft SQL Server Setup
    ------------------------------

    SQL Server 2005 Setup requires administrator permissions on every
    cluster node. To continue, update permissions for the account
    currently running Setup, or log in with an account that has
    administrator permissions on every cluster node, and then run SQL
    Server Setup again.

    For help, click:
    http://go.microsoft.com/fwlink?Link...tSrc=setup.rll&EvtID=SQLSetup90&EvtType=28076

    Hello

    Setting up a new W2K8 x64 Two Node Cluster A/P. I have the cluster
    built and the cluster fails over from node to node with no problems.
    Cluster validation passed 100% on all items. I have create a sql
    installation account, and added that domain account to the local Admin
    group on each node. I have the two installation CD copied to the C
    drive on the primary node. When logged in as the installation
    account on the second node I can access the installation files.
    \\<servername\c$\ I have also changed the local policy on both
    nodes and added the sql installation account granting log on as
    service and act as part of the operating system rights. Windows
    firewall is disabled on both nodes for the installation. I have
    looked at the SQL logs but nothing is jumping out at me as to the
    cause of the problem.
     
    Bill Golem, Mar 28, 2009
    #1
    1. Advertisements

  2. Bill Golem

    Bill Golem Guest

    infor from SQLSetup0001_xxxxxx_Core(Local).log


    Error: Action "LaunchLocalBootstrapAction" threw an exception during
    execution. Error information reported during run:
    "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe"
    finished and returned: 1602
    Aborting queue processing as nested installer has completed
    Message pump returning: 1602


    rror: Action "InvokeSqlSetupDllAction" failed during execution.
    Action "AnalyzeInstallStage" will be skipped due to the following
    restrictions:
    Condition "Action: InvokeSqlSetupDllAction has finished and passed."
    returned false.
    Action "PrepareForChainingStage" will be skipped due to the following
    restrictions:
    Condition "Action: InvokeSqlSetupDllAction has finished and passed."
    returned false.
    Action "SequenceChainingActionsStage" will be skipped due to the
    following restrictions:
    Condition "Action: InvokeSqlSetupDllAction has finished and passed."
    returned false.
    Action "InstallChainedPackagesStage" will be skipped due to the
    following restrictions:
    Condition "Action: InvokeSqlSetupDllAction has finished and passed."
    returned false.
    Running: ReportChainingResults at: 2009/2/28 20:2:47
    Error: Action "ReportChainingResults" threw an exception during
    execution.
    DwLaunchMsiExec() returned : 1602
    Error Code: 0x80070642 (1602)
    Windows Error Text: User cancelled installation.

    Source File Name: sqlchaining\sqlchainingactions.cpp
    Compiler Timestamp: Thu Sep 1 22:23:05 2005
    Function Name: sqls::ReportChainingResults::perform
    Source Line Number: 2992

    Source File Name: datastore\cachedpropertycollection.cpp
    Compiler Timestamp: Fri Jul 29 01:13:49 2005
    Function Name: CachedPropertyCollection::findProperty
    Source Line Number: 130
    ----------------------------------------------------------
    Failed to find property "watsonFailedActionErrorCode"
    {"SetupStateScope", "", ""} in cache
    Source File Name: datastore\propertycollection.cpp
    Compiler Timestamp: Fri Jul 29 01:13:50 2005
    Function Name:
    SetupStateScope.watsonFailedActionErrorCode
    Source Line Number: 44
    ----------------------------------------------------------
    No collector registered for scope: "SetupStateScope"
    Failed to create CAB file due to datastore exception
    Source File Name: datastore\cachedpropertycollection.cpp
    Compiler Timestamp: Fri Jul 29 01:13:49 2005
    Function Name: CachedPropertyCollection::findProperty
    Source Line Number: 130
    ----------------------------------------------------------
    Failed to find property "watsonFailedActionErrorCode"
    {"SetupStateScope", "", ""} in cache
    Source File Name: datastore\propertycollection.cpp
    Compiler Timestamp: Fri Jul 29 01:13:50 2005
    Function Name:
    SetupStateScope.watsonFailedActionErrorCode
    Source Line Number: 44
     
    Bill Golem, Mar 29, 2009
    #2
    1. Advertisements

  3. Bill Golem

    Bill Golem Guest

    SQLSetup0001_xxxxxx_Core(Local).log

    Error: Action "LaunchLocalBootstrapAction" threw an exception during
    execution. Error information reported during run:
    "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe"
    finished and returned: 1602
    Aborting queue processing as nested installer has completed
    Message pump returning: 1602


    Error: Action "InvokeSqlSetupDllAction" failed during execution.
    Action "AnalyzeInstallStage" will be skipped due to the following
    restrictions:
    Condition "Action: InvokeSqlSetupDllAction has finished and passed."
    returned false.
    Action "PrepareForChainingStage" will be skipped due to the following
    restrictions:
    Condition "Action: InvokeSqlSetupDllAction has finished and passed."
    returned false.
    Action "SequenceChainingActionsStage" will be skipped due to the
    following restrictions:
    Condition "Action: InvokeSqlSetupDllAction has finished and passed."
    returned false.
    Action "InstallChainedPackagesStage" will be skipped due to the
    following restrictions:
    Condition "Action: InvokeSqlSetupDllAction has finished and passed."
    returned false.
    Running: ReportChainingResults at: 2009/2/28 20:2:47
    Error: Action "ReportChainingResults" threw an exception during
    execution.
    DwLaunchMsiExec() returned : 1602
    Error Code: 0x80070642 (1602)
    Windows Error Text: User cancelled installation.

    Source File Name: sqlchaining\sqlchainingactions.cpp
    Compiler Timestamp: Thu Sep 1 22:23:05 2005
    Function Name: sqls::ReportChainingResults::perform
    Source Line Number: 2992

    Source File Name: datastore\cachedpropertycollection.cpp
    Compiler Timestamp: Fri Jul 29 01:13:49 2005
    Function Name: CachedPropertyCollection::findProperty
    Source Line Number: 130
    ----------------------------------------------------------
    Failed to find property "watsonFailedActionErrorCode"
    {"SetupStateScope", "", ""} in cache
    Source File Name: datastore\propertycollection.cpp
    Compiler Timestamp: Fri Jul 29 01:13:50 2005
    Function Name:
    SetupStateScope.watsonFailedActionErrorCode
    Source Line Number: 44
    ----------------------------------------------------------
    No collector registered for scope: "SetupStateScope"
    Failed to create CAB file due to datastore exception
    Source File Name: datastore\cachedpropertycollection.cpp
    Compiler Timestamp: Fri Jul 29 01:13:49 2005
    Function Name: CachedPropertyCollection::findProperty
    Source Line Number: 130
    ----------------------------------------------------------
    Failed to find property "watsonFailedActionErrorCode"
    {"SetupStateScope", "", ""} in cache
    Source File Name: datastore\propertycollection.cpp
    Compiler Timestamp: Fri Jul 29 01:13:50 2005
    Function Name:
    SetupStateScope.watsonFailedActionErrorCode
    Source Line Number: 44
     
    Bill Golem, Mar 29, 2009
    #3
  4. Bill Golem

    Bill Guest

    FYI

    I was able to resolve my problem by stopping the Terminal Services
    service on each node and using the <domain>\Administrator account. An
    domain user account with local admin rights wasn't enough nor was an
    account with domain rights.

    I also noticed that during the SQL 2005 installation I didn't get the
    warning about requiring SQL SP2 for support on Windows 2008. I did
    get later during the install the warning about needing to apply SP1
    for VS 2005.

    Hope this helps someone else that was in the same boat as me.

    Bill
     
    Bill, Apr 1, 2009
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.