July 13, 2008 at 10:24 am
We have a SQL2005(x64) Cluster, it is SAP's DB.
the replication component not be installed at first.
but now, we want to use SQL replication function.
the SQL2005 cluster parameter
VS=SQLTEST
Node1=SQLTEST1
Node2=SQLTEST2
So I try to used the command prompt to add the component.
I run the command:
start /wait \setup.exe /qb VS=SQLTEST INSTALLVS=SQL_Engine
INSTANCENAME=MSSQLSERVER ADDLOCAL=SQL_Replication ADDNODE=n
End,the installation process failure!
Message Display:
SQL Server Setup is unable to run. Either the owning node or all nodes that
are currently part of the virtual server are not available. Review any SCC
failures and validate that all nodes are online.
*******************************************
Setup Consistency Check Report for Machine: SQLTEST2
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: Warning
Description: IIS is not installed, therefore Report Server feature will be disabled Action: Install IIS in order for Report Server feature to be enabled
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: Warning
Description: Required version of ASP.NET not Registered Action: Microsoft Reporting Services 2005(32-bit) requires 32-bit ASP.Net registered. Microsoft Reporting Services 2005(64-bit) requires 64-bit ASP.Net registered. Install the required version of ASP.Net.
Article: Minimum MDAC Version Requirement, Result: CheckPassed
*******************************************
Setup Consistency Check Report for Machine: SQLTEST1
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: Warning
Description: IIS is not installed, therefore Report Server feature will be disabled Action: Install IIS in order for Report Server feature to be enabled
Article: Administrative Shares Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
The CheckSCCResult returned for cluster install is 0
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.
Return Code: 1119d
Message displayed to user
SQL Server Setup is unable to run. Either the owning node or all nodes that are currently part of the virtual server are not available. Review any SCC failures and validate that all nodes are online.
in the log, we can see all nodes is be check SCC, find some SCC warning(such
as IIS and ASP.NET). installation be terminated in this step.
I don't know whether has some step that I ignored.
And has somebody can provide any suggestion!
THK.
July 13, 2008 at 9:06 pm
I am not sure will be able to install the replication component once the Database services is installed and over all it is clustered. I think since REPLICATION is a Part/Soul of Database Services component, you have to install it initially. OR you can TRY, to do a Failover and ShutDown node 1. then try to RUN the install on NODE 2. Then do the same failover for NODE 1 and install. then apply the SP2 and other updaes again..
OR Usually a reinstall will be the way to go... Since I have not been in such a situation... I usually install all the components and Just enable them as needed... Maybe there is a way and others might have an answer to it...
Maninder
www.dbanation.com
July 13, 2008 at 11:24 pm
THK. Mani Singh reply.
when the installation failure, I try this process in the other test system.for example, add replicaition component in a stand-alone instance of SQL Server 2005. replication component can be installed success.
I think one node down and install in the other node is no availiable.
I try do that, the setup program tell me :"some feature is unavailiable to this system".
I think that command prompt is the only method, when add component in SQL CLUSTER!
If has other way please give me suggestion
March 30, 2009 at 1:13 pm
Hello Experts,
I am facing the same problem in my production environment.
Please advice the solution.
Thanks,
Senthilkumar
India
September 11, 2009 at 6:57 am
Here is the command line parameter fix for adding replication/other components on cluster environment.
*******************************************************************
C:\Software\SQL 2005 STD\Standard_x86\Servers>start /wait setup.exe /qb VS=SQL1 INSTANCENAME=SQL1 ADDNODE="xxxx1,xxxx2" GROUP="GROUP 0" IP="xxx.xx.xxx.xxx,Public" ADDLOCAL=SQL_Replication ADMINPASSWORD=xxxxx INSTALLSQLDIR="C:\ Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn"
*******************************************************************
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply