Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » LDAP user authentication » Creating an LDAP user authentication environment (Sybase Central)


Creating an LDAP server configuration object

Use Sybase Central to create two LDAP server configuration objects.


You must have the MANAGE ANY LDAP SERVER and SET ANY SECURITY OPTION system privileges.

Context and remarks

Each LDAP server is accessed using TCP/IP. An LDAP server definition is required for each LDAP server that you want to use for user authentication. The responses shown below are for demonstration purposes only. Supply your own appropriate equivalent responses.

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. In the left pane, right-click LDAP Servers, and then click New » LDAP Server.

  3. For the name of the LDAP server, type the server name (prim_ldap for example), and then click Next.

  4. Select the type of network encryption (No encryption (ldap:) for example).

  5. For the host name and port number of the LDAP server, type the server name and port (iq10web and 389 for example).

  6. For Authentication URL, you should see a URL (ldap://iq10web:389/ for example). Click Next.

  7. For the search URL, you can enter this directly into the Search URL field (ldap://iq10web:389/dc=sybase,dc=com?dn?sub?uid=* for example).

  8. For Distinguished Name, type the distinguished name (cn=Manager,dc=sybase,dc=com for example).

  9. If there is a password required to authenticate to the LDAP server, enter it in the Password field (Not4YourEyes for example).

  10. Click Next.

  11. For the connection timeout, select the connection timeout interval (1 second for example).

  12. For the number of connection retries, select the number of times (4 for example), and then click Next.

  13. To activate the LDAP server, select Activate this LDAP server now.

  14. Select the Login modes (at least Standard and LDAPUA should be selected).

  15. Click Test Connection to verify your LDAP connection parameters. For example, click Test Connection when the dialog opens. If you have entered your connection parameters correctly, the connection succeeds. Click Close, then click Next.

  16. (Optional) Add a comment. Click Next.

  17. The SQL that is executed to create the LDAP server configuration object appears. Click Finish.


An LDAP server configuration object is created, and references to it are added to the ISYSLDAPSERVER system table.


(Optional) Create a second LDAP server configuration object that is used for failover. Follow the same steps above but use sec_ldap as the server name and use port 390.

After you have completed this task, create a login policy that uses the LDAP server.

 See also