SAP Knowledge Base Article - Preview

2240893 - Error SQL9668 Login redirection to Primary server failed which causes SAP application cannot connect ASE with HADR - SAP ASE with HADR

Symptom

  • In an Business Suite environment running on SAP ASE with HADR configuration, SAP Application unable to connect to ASE database
  • R3trans -d returns:
    2EETW169 no connect possible: "DBMS = SYBASE --- "

  • The dev_w traces contain errors including:
    [ASE Error SQL9668][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Login redirection to Primary server failed.
  • There a possible variations in errors reported by ASE logs
  • The primary ASE can include messages like:

    Cannot locate Primary Server information from HADR config.

    remote HADR server servername is STANDBY
    local server is now Standby
    booting into HADR group server_group in Standby mode

  • The full error message text for 9668 is:
    Login failed. Adaptive Server is running in 'Standby Mode'. You do not have the necessary role or privilege to login while the server is running in this mode and login redirection cannot occur since there is no Active Primary


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) for Business Suite with HADR option
  • SAP Replication Server (SRS)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Replication Server 15.7

Keywords

HADR, Standby, "SQL 9668" , KBA , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.