What are the challenges you face when working across database platforms? Take the survey

Access Denied error while upgrading MSCS cluster from 4.6 to

eilanddeilandd Posts: 44
edited July 18, 2007 11:22AM in SQL Backup Previous Versions
We are attempting to upgrade our SQLBackup installations from version 4.6 to version 5.1 on SQLServer 2000. I copied the SQBServerSetup.exe to the current active node of one of our cluster installations while logged in as a domain administrator. When prompted I supplied the cluster administrator login information and received 'Access is denied' on the inactive node. I then attempted the same process from the inactive node and received 'Access is denied' on the active node. Any help would be greatly appreciated.

Below is a cleansed portion of the log file from one of the attempts:

2007-07-11 14:27:41 IsCluster: entry
2007-07-11 14:27:41 GetClusterName.entry
2007-07-11 14:27:41 GetClusterName.InstanceName:
2007-07-11 14:27:41 GetInstanceKey.InstanceName:
2007-07-11 14:27:41 GetInstanceKey.retrieving SQL 2005 key
2007-07-11 14:27:41 GetClusterName.KeyName: SOFTWARE\Microsoft\MSSQLSERVER\CLUSTER
2007-07-11 14:27:41 GetClusterName.Result: xxxxxxxx
2007-07-11 14:27:41 IsCluster.Result: True
2007-07-11 14:27:41 IsCluster: exit
2007-07-11 14:27:41 NewPageID: 23
2007-07-11 14:27:41 GetClusterNodeNames: entry
2007-07-11 14:27:41 GetClusterNodeNames: #1
2007-07-11 14:27:41 GetClusterNodeNames: exit
2007-07-11 14:28:17 TestClusterAdminLogin.Entry
2007-07-11 14:28:17 GetMachineNameEx.Entry
2007-07-11 14:28:17 GetMachineNameEx.Exit
2007-07-11 14:28:17 TestClusterAdminLogin.LocalNodeName: Active Node
2007-07-11 14:28:17 Validating: Inactive Node
2007-07-11 14:28:17 TestClusterAdminLogin.Exit
2007-07-11 14:28:19 Failed to connect to the following cluster nodes:

Inactive Node (Access is denied)

Please enter the correct login information.


  • Options
    peteypetey Posts: 2,358 New member
    The installer uses Windows Management Instrumentation (WMI) to test the logins. Do any of the scenarios on troubleshooting mentioned in this document (http://www.microsoft.com/technet/scriptcenter/resources/wmifaq.mspx) apply to your situation?

    Are any of your cluster nodes using extended or unicode characters? Are they named correctly in the list of cluster nodes?

    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    After looking into this further we found that the error is related to DCOM. This is a PCI issue since it is required that DCOM be disabled. Can you supply manual upgrade proceedures that do not require DCOM?

  • Options
    peteypetey Posts: 2,358 New member
    You will need to perform the upgrade on all nodes manually. Run SQBServerSetup.exe on each node, but do not select the cluster option. This will upgrade the existing version 4 server components to version 5.

    Assuming you have already set up a cluster resource for the SQL Backup Agent service for version 4, there is then nothing else to do. If not, you can follow the steps here to set up the cluster resource, and also to link the appropriate registry keys (http://www.red-gate.com/MessageBoard/viewtopic.php?t=1880).

    You also need to run ProductActivation.exe on each of the nodes to activate your license.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    Thanks for the help. The update has been applied successfully.
Sign In or Register to comment.