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 for Me (Login required).

Search for additional results

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