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

• 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

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

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