SAP Knowledge Base Article - Preview

2245596 - ERROR: Failed to connect to <jdbc:sybase:Tds:Ip_addr:port> as <SAMPLE_RS_ra> because: JZ00L: Login failed - SAP RS 15.7

Symptom

  • RA connecting to RS:ra_admin.bat: ERROR: Failed to connect to <jdbc:sybase:Tds:Ip_addr:port> as <SAMPLE_RS_ra> because: JZ00L: Login failed.
  • Configuring Agent instance, using the Sample Server, SAMPLE_RS as part of the installation.
  • The server seems to be running well and is accessible with the users created (e.g. SAMPLE_RS_ra & sa) using isql.
  • The ports for both ERSSD and server are open in FW and netstat -an shows them listening.
  • The problem shows when validating this configuration using ra_admin.bat tool (parameter: -vr):

##############
com.sybase.ra.RepAgentAdmin initLogging
TRACE: SAP Replication Agent for Unix & Windows/15.7.1 SP209/P/generic/JDK 7.0/rax1571sp209/62090.209/VM: SAP AG 1.7.0_25/OPT
com.sybase.ra.RepAgentAdmin initLogging
TRACE: ra_admin -vr ora1.rs
com.sybase.ra.admin.oracle.RAOResponseFileProperties verifyProperties
INFORMATION: Completed first pass of verification for resource file <ora1.rs>.
com.sybase.ra.admin.RsRssdVerification verifyRS
TRACE: Testing connection to RepServer...
com.sybase.ra.admin.JDBCConnectionFactory testConnection
ERROR: Failed to connect to <jdbc:sybase:Tds:10.151.20.54:11751> as <SAMPLE_RS_ra> because: JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s).
##############

  • Server 1 (source): Windows Server running an 32 bit Oracle Database 11g R2. Here is installed Rep. Agent (win32) version 15.7.1 SP209.
    Server 2: Windows Server running Replication Server version 15.7.1 SP301 (64bit).
    Server 3 (target): HANA version 97. Connection has been made and looks fine.

Read more...

Environment

  • SAP Replication Server (RS) 15.7.1 SP209 (win32)
  • SAP Replication Server version 15.7.1 SP301 (64bit).
  • SAP HANA version 97.
  • Oracle Database 11g R2.

Product

SAP Sybase Replication Server 15.7, option for Oracle

Keywords

KBA , BC-SYB-REP-RSO , Rep Server Options (RSO) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.