Migrating from the sql.ini file to LDAP

There is no direct method to upgrade an existing server using the sql.ini file to one that uses lightweight directory services. To upgrade a pre-12.5 server to 12.5, see the Installation Guide for Windows NT.

If you have LDAP or other directory services defined in the libtcl.cfg file before configuring the server, the -i argument is not added to the sql.ini file.

If you do not have LDAP or other directory services defined in the libtcl.cfg, the -i argument is added to the sql.ini file and the Windows NT registry.

Once you have upgraded the server, you can configure your server to use LDAP service.

  1. Shut down the server. See Chapter 2, “Starting and Stopping Servers.”

  2. Edit the %SYBASE%\%SYBASE_OCS%\config\libtcl.cfg file to add the directory service. See “Enabling LDAP directory services”.

  3. Use dsedit and add the server entry to directory service. See “Adding a server to the directory services”.

  4. Start the configuration utility. Select Start | Programs | Sybase | Server Config.

  5. Select Configure Adaptive Server.

  6. Select the server for which you want to enable directory service, and click Continue.

  7. Enter your log in name and password, and click Continue.

  8. When prompted to start the server, select Yes.

  9. On the Configure Adaptive Server screen, click “Cancel” or “Save”.

  10. Exit Server Config.

NoteIf you intend to use Monitor Server with LDAP enabled, you must re-run the Server Config utility after editing the libtcl.cfg. Otherwise, Monitor Server continues to use the -i argument.

Alternatively, you can add or remove the -i argument which specifies the interfaces (sql.ini on Windows) file directly from the Windows NT registry.

  1. Select Start | Run and enter, regedt32.

  2. Select the HKEY_LOCAL_MACHINE view.

  3. Select SOFTWARE\Sybase\Server\server_ name\Parameters

  4. Remove the -i argument from the line that ends with ...\Sybase\ini\sql.ini