SQL Server 2005 in the cluster environment – install error

  • Getting an error, when start the installation:

    Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run:

    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 "ComputerList" {"SqlComputers", "", ""} in cache

    Source File Name: datastore\clusterinfocollector.cpp

    Compiler Timestamp: Fri Sep 16 13:20:12 2005

    Function Name: ClusterInfoCollector::collectClusterVSInfo

    Source Line Number: 883

    ----------------------------------------------------------

    Failed to detect VS info due to datastore exception.

    Source File Name: datastore\clustergroupsproperties.cpp

    Compiler Timestamp: Fri Jul 29 01:13:49 2005

    Function Name: ClusterGroupScope.SharedDisks

    Source Line Number: 56

    ----------------------------------------------------------

    Failed to find a cluster group that owned shared disk: C:

    WinException : 2

    Error Code: 0x80070002 (2)

    Windows Error Text: The system cannot find the file specified.

    Source File Name: datastore\clustergroupsproperties.cpp

    Compiler Timestamp: Fri Jul 29 01:13:49 2005

    Function Name: ClusterGroupScope.SharedDisks

    Source Line Number: 56

    Any ideas? Maybe somebody already had this problem and resolved? Any information is much much appreciated!

  • It looks like you are trying to install shared files to a non-shared drive (C: drive, looking at the last error).

    Have you setup & configured a shared disk for SQL data files to go on to? You will also need a dedicated DNS name & IP address for the SQL instance (you cannot use the Windows cluster name & IP).



    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare


  • Didnt help. Drive is a shared resource and we get this message right from the beginning of the installation. It is not asking yet for IP or any name. 🙁

    Any other ideas?

  • Hi,

    What service pack does your Windows OS have installed? What kind of hardware are you using?

    What type of shared storage are you using (e..g direct attached or SAN)? Where does the SQL Server 2005 install CD come from (e.g. MSDN, OEM or retail)? Also, please provide a brief overview of cluster setup (e.g. #nodes, nic's, resource groups etc..).

    Thanks,

    Phillip Cox

    MCITP - DBAdmin

  • Phillip Cox (3/7/2008)


    Hi,

    What service pack does your Windows OS have installed?

    What kind of hardware are you using?

    What type of shared storage are you using (e..g direct attached or SAN)? Where does the SQL Server 2005 install CD come from (e.g. MSDN, OEM or retail)? Also, please provide a brief overview of cluster setup (e.g. #nodes, nic's, resource groups etc..).

    Thanks,

    Phillip Cox

    MCITP - DBAdmin

    Windows 2003 sp1 Ent Edition IBM Hardware with 8 GB of RAM The server is a single node cluster with no actual SAN unit, The intsall files are downloaded from Microsoft, there is a single cluster group with file share and SQL resources , the quorum and sql are on the same virtaul disk.

  • Hi,

    Ok, this setup is not a good setup, as you should have a minimum shared storage and seperate disk resources for data, logs and quroum.

    Why are you using a single node cluster?

    Thanks,

    Phillip Cox

    MCITP - DBAdmin

  • Hello Iryna,

    We have the same error. I don't have a solution for this yet, but I think it may be related to the fact that we have put some resource groups offline. Do you have resource groups offline on your server?

    Greetings,

    Robert

    Robert van den Berg

    Freelance DBA
    Author of:

  • Hello Robert,

    Our problem that the single cluster is not really a cluster. It was supported somehow in 2000 but not supported by 2005 and we need to uninstall our single cluster and just install everything as a regular server in order to update.

    Our normal cluster we didn't touch yet. We received the response from Microsoft that it is possible to upgrade but they recommend to buld new system separatelly and then just replace the old one. Kind of expensive solution. Yes, we do have resources offline on the passive node. Can't tell you if we have any problems upgrading, didn't try yet. Too risky.

    Regards,

    Iryna

  • I get the following error on my 4 node cluster when I try and go back and install integration services on an individual node. I startup setup from the command prompt using setup.exe SKUUPGRADE=1. I know that integration services is not a cluster resource but I do need it installed on each individual node of my cluster.

    1

    Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.3042.0

    Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run:

    Source File Name: datastore\cachedpropertycollection.cpp

    Compiler Timestamp: Sat Oct 7 09:43:48 2006

    Function Name: CachedPropertyCollection::findProperty

    Source Line Number: 130

    ----------------------------------------------------------

    Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache

    Source File Name: datastore\clusterinfocollector.cpp

    Compiler Timestamp: Sat Oct 7 09:43:48 2006

    Function Name: ClusterInfoCollector::collectClusterVSInfo

    Source Line Number: 888

    ----------------------------------------------------------

    Failed to detect VS info due to datastore exception.

    Source File Name: datastore\clustergroupsproperties.cpp

    Compiler Timestamp: Sat Oct 7 09:43:48 2006

    Function Name: ClusterGroupScope.SharedDisks

    Source Line Number: 56

    ----------------------------------------------------------

    Failed to find a cluster group that owned shared disk: C:

    WinException : 2

    Error Code: 0x80070002 (2)

    Windows Error Text: The system cannot find the file specified.

    Source File Name: datastore\clustergroupsproperties.cpp

    Compiler Timestamp: Sat Oct 7 09:43:48 2006

    Function Name: ClusterGroupScope.SharedDisks

    Source Line Number: 56

  • CHeck if any disk resource is offline for any cluster group .Irresepective if it is a sql group or not

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply