Re: SQL 2005 Cluster install Error
- From: wmadmin <wmadmin.2d02u0@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 23 Aug 2006 10:21:57 -0500
after complete newinstallation of 2003 cluster
we took a closer look on the heartbeat network card configuration
and configured them as described in MS documentation.
(disable netbios over tcp/ip ...)
then we encountered other errors:
on node 1 (where we installed from:) the setup just stops and cleans
up after the first initialization dialog showing a hint to the
logfile:
SQLSetup0020_HOTLINESRV1_Core(Local).log
and the request to send it to microsoft:
=====================================================
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\sqlsval.dll Version:2005.90.1399.0
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\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallIds" {"MachineConfiguration", "",
"HOTLINESRV5"} in cache
Source File Name: datastore\sqldiscoverycollector.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SqlDiscoveryCollector::collectProperty
Source Line Number: 132
----------------------------------------------------------
Failed to open discovery on machine: HOTLINESRV5
WinException : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastore\sqldiscoverycollector.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SqlDiscoveryCollector::collectProperty
Source Line Number: 132
=====================================================
first we tried some days to find the error in the internet but
did not get any usefull hint.
we first set the hearbeat connection to half duplex, 10 mBit as
microsoft recommends.
--> no effect.
then we enabled netbios over TCP/IP for the heartbeat connection
(via cross over cable).
---> RESULT was: the error did not occur anymore. (we were happy, for
some minutes)
then we had to rename the second node and evicted it from cluster
manager. after renaming and adding again, the error occurred again
ALTHOUGH netbios over tcp/ip was activated.
then we installed the NWLink SPX/IPX/netbios compatible protocol for
the heartbeat connection
--> RESULT: the setup continued with node1 + node2 checks.
then the components installed successfully until "SQL server
database".
this setup failed on node 2 with log:
SQLSetup0022_HOTLINESRV5_Core(Local).log
=====================================================Error: Action
"UninstallForRS2000Action" failed during execution. Error information
reported during run:
Action: "UninstallForRS2000Action" will be marked as failed due to the
following condition:
Condition "rs was successfully upgraded." returned false.
Installation of package: "patchRS2000" failed due to a precondition.
Running: ReportChainingResults at: 2006/7/23 12:23:9
Error: Action "ReportChainingResults" threw an exception during
execution.
One or more packages failed to install. Refer to logs for error
details. : 1706
Error Code: 0x800706aa (1706)
Windows Error Text: The endpoint format is invalid.
Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Sep 1 22:23:05 2005
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3097
---- Context -----------------------------------------------
sqls::RemotePackageInstallerSynch::preInstall
Aborting install of package: "patchRS2000" due to error code received
from host setup: 29539
sqls
Error: Failed to add file :"\\HOTLINESRV1\C$\Program Files\Microsoft
SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0022_HOTLINESRV5_.NET
Framework 2.0.log" to cab file : "\\HOTLINESRV1\C$\Program
Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0022_HOTLINESRV5_Logs.cab" Error Code : 2
Error: Failed to add file :"\\HOTLINESRV1\C$\Program Files\Microsoft
SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0022_HOTLINESRV5_.NET
Framework 2.0 LangPack.log" to cab file : "\\HOTLINESRV1\C$\Program
Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0022_HOTLINESRV5_Logs.cab" Error Code : 2
Error: Failed to add file :"\\HOTLINESRV1\C$\Program Files\Microsoft
SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0022_HOTLINESRV5_.NET
Framework Upgrade Advisor.log" to cab file : "\\HOTLINESRV1\C$\Program
Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0022_HOTLINESRV5_Logs.cab" Error Code : 2
Error: Failed to add file :"\\HOTLINESRV1\C$\Program Files\Microsoft
SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0022_HOTLINESRV5_.NET
Framework Upgrade Advisor LangPack.log" to cab file :
"\\HOTLINESRV1\C$\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0022_HOTLINESRV5_Logs.cab" Error Code : 2
Error: Failed to add file :"\\HOTLINESRV1\C$\Program Files\Microsoft
SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0022_HOTLINESRV5_.NET
Framework Windows Installer.log" to cab file :
"\\HOTLINESRV1\C$\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0022_HOTLINESRV5_Logs.cab" Error Code : 2
Error: Failed to add file :"\\HOTLINESRV1\C$\Program Files\Microsoft
SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0022_HOTLINESRV5_.NET
Framework Windows Installer LangPack.log" to cab file :
"\\HOTLINESRV1\C$\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0022_HOTLINESRV5_Logs.cab" Error Code : 2
Delay load of action "UploadDrWatsonLogAction" returned nothing. No
action will occur as a result.
Message pump returning: 1706
=====================================================
then also the setup showed an error that sql-native client could not be
installed and that it should be installed manually.
(error message that sqlncli.msi was not installed)
after that we took following actions:
1. uninstalled via add/remove programms
EVERYTHING that was installed by sql-server setup
on BOTH nodes:
(sql setup supportfiles, MSXML6, native client, office 2003 web
compontens, sql compatibility, sql vss writer)
2. installed in dcomcnfg - component services - computers - my
computer
- properties - default protocols
following protocols:
connection orientated tcp/ip (was already installed)
connection orientated SPX
datagram UDP/IP
tunneling TCP/IP
AFTER THAT the installation worked fine and sqlserver was installed
on both nodes and a failover switch worked fine.
--
wmadmin
------------------------------------------------------------------------
wmadmin's Profile: http://www.dbtalk.net/m673
View this thread: http://www.dbtalk.net/t298888
.
- References:
- Re: SQL 2005 Cluster install Error
- From: wmadmin
- Re: SQL 2005 Cluster install Error
- Prev by Date: Re: Move SQL 2000 data to new SAN, same drive letter
- Next by Date: Re: Move SQL 2000 data to new SAN, same drive letter
- Previous by thread: Re: SQL 2005 Cluster install Error
- Next by thread: Are multiple-instances on a single cluster supported with SQL Server 2005 Standard Edition?
- Index(es):
Relevant Pages
|
