Skip to Content
avatar image
Former Member

help! about SQL Replication component

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 15, 2008 at 05:32 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded