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.