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:
-
Use sp_grantlogin to assign a role to a sample user on the
network.
-
Enter sp_logininfo to determine the format of entries in
syslogins.
-
Use the entries listed in the mapped login name column as
templates for the login names you create with
sp_addlogin.