Adding Network Login Names to syslogins

To add a login name for each Windows user accessing SAP ASE over a trusted connection, use sp_addlogin. Include any nondefault domain names and the correct mapping characters in the login name.

If you are not sure what to enter as the login name, experiment with a sample user to clarify your options:
  1. Use sp_grantlogin to assign a role to a sample user on the network.

  2. Enter sp_logininfo to determine the format of entries in syslogins.

  3. Use the entries listed in the mapped login name column as templates for the login names you create with sp_addlogin.