To enable or disable network-based security, use sp_configure to set the use security services configuration parameter. Set this parameter to 1 to enable network-based security. If this parameter is 0 (the default), network-based security services are not available. The syntax is:
sp_configure "use security services", [0|1]
For example, to enable security services, execute:
sp_configure "use security services", 1
This configuration parameter is static; you must restart
Adaptive Server for it to take effect. See “Restarting the server to activate security services”.
