Adding logins to support unified login

When a user logs in to Adaptive Server with an authenticated credential, Adaptive Server follows these steps, as needed:

  1. Checks that user is a valid user in master..syslogins.

  2. Checks that a default secure login is defined in master..syslogins.

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.

NoteYou 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”.