Requiring Unified Login

The unified login required configuration parameter controls the type of login that is acceptable to SAP ASE.

The possible values are:
  • 1 – require all users who request a connection to SAP ASE to be authenticated by LAN Manager.

  • 0 –(default) allow both traditional login names and passwords and authenticated credentials.

The syntax is:
sp_configure "unified login required", [0|1]
For example, to require all logins to be authenticated by a security mechanism, execute:
sp_configure "unified login required", 1