on 07-15-2008 6:25 PM
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 to publish some table to a middle database..
the SQL2005 cluster parameter
VS=SQLTEST
Node1=SQLTEST1
Node2=SQLTEST2
I see from SQL online help, I only can use command prompt to add or remove SQL component in cluster.
so I run the command:
start /wait <file paths>\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.
the setup log
*******************************************
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 know SQL replication function is not support by SAP official.
but I want to try it.
has somebody success add replication component in SQL Cluster?
PLS give me some suggestion about it.
THK.
Can you tell me what the replication component has to do w/ MSCS? I think that it can be configured even without MSCS right? Basically, you want to replicate a specific group of tables to a 3rd DB?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.