To require all users, other than the user with System Security Officer (sso) role, to be authenticated by a security mechanism, set the unified login required configuration parameter to 1. Only the user with the sso role can log in to the server with a username and password when this configuration parameter is set:
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
