SAP Knowledge Base Article - Preview

3593708 - rpc security models is obsoleted since ASE 15.7 - SAP ASE

Symptom

  • You observed that the security_mechanism of sp_helpserver is 'NULL'. 
    sp_helpserver
    go
     name        network_name   security_mechanism   server_principal   class        status                                                                       id cost
     ----------- -------------- -------------------- ------------------ ------------ ---------------------------------------------------------------------------- -- ----
     SYB_BACKUP  TEST_BS        NULL                 NULL               RPCServer    timeouts, no net password encryption, writable , enable login redirection     1 NULL
     SYB_JSAGENT TEST_JSAGENT   NULL                 NULL               ASEnterprise no timeouts, no net password encryption, writable , enable login redirection  3 1000
     SYB_JSTASK  TEST           NULL                 NULL               ASEnterprise timeouts, no net password encryption, writable                                5 1000
     TEST        TEST           NULL                 NULL               local                                                                                      0    0
     TEST_XP     TEST_XP        NULL                 NULL               RPCServer    no timeouts, no net password encryption, writable , enable login redirection  2 1000
     loopback    TEST           NULL                 NULL               ASEnterprise no timeouts, no net password encryption, writable , enable login redirection  4 1000
    (return status = 0)

  • And there is no external security mechanisms listed in syssecmechs, the table is empty.

    select * from syssecmechs
    go
     sec_mech_name                  available_service
     ------------------------------ ------------------------------

    (0 rows affected)

  • In older ASE version, which is pre ASE 15.7, the security_mechanism could be 'rpc security model A'.
    sp_helpserver
    go
    name                network_name   security_mechanism   server_principal   class          status                                                                       id cost
    ------------------- -------------- -------------------- ------------------ -------------- ---------------------------------------------------------------------------- -- ----
    TEST               TEST          rpc security model A NULL               ASEnterprise   timeouts, no net password encryption, writable, enable login redirection       0 0


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

security_mechanism, sp_helpserver, rpc security model A, rpc security model B, syssecmechs , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.