The unified login required configuration parameter controls the type of login that is acceptable to Adaptive Server. The possible values are:
1 – to require all users who request a connection to Adaptive Server to be authenticated by LAN Manager.
0 – the default, to let Adaptive Server accept 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