When a user logs in to Adaptive Server with an authenticated credential, Adaptive Server follows these steps, as needed:
Checks that user is a valid user in master..syslogins.
If the user name appears, Adaptive Server accepts the login without requiring a password.
If the user name does not appear, Adaptive Server performs step 2.
Checks that a default secure login is defined in master..syslogins.
A default login definition allows the user to log in successfully.
The absence of a default login definition causes Adaptive Server to reject the login.
Therefore, consider whether to allow only users who are defined as valid logins to use Adaptive Server or to allow any user with the default login to use Adaptive Server.
You must add the default login in master..syslogins and use sp_configure to define the default. For more information, see “Establishing a secure default login”.