Setup

Adaptive Server support for LDAP requires an ASE_DIRS license.

StepsSetting up LDAP user accounts for Adaptive Server

  1. Add user login accounts to the LDAP server using a third-party LDAP tool such as the SunONE Directory Server, the Microsoft Active Directory, the Novell Directory Server, or the IBM SecureWay Directory Server.

  2. Construct an LDAP URL search string for user authentication to Adaptive Server using sp_ldapadmin. For example:

    sp_ldapadmin set_primary_url,
    		‘ldap://voyager:389/ou=People,
    		dc=MyCompany,dc=com??sub?uid=*’
    

    Your LDAP server determines the syntax and attribute support of the search string. For syntax and usage information for sp_ldapadmin, see Reference Manual: Procedures.

  3. Enable LDAP user support using the Adaptive Server configuration parameter enable ldap user auth. For example:

    sp_configure ‘enable ldap user auth’, 2
    

    See “enable ldap user auth” for syntax and usage information.