Using a Remote Log

By default, if event logging is enabled, SAP ASE logs messages to the Windows event log on the local computer system. You can change the destination computer to which to log messages.

  1. On a local computer, either:
    • Use sp_configure, as in the following command line, or:
      sp_configure "event log computer name", 0, user1
      or,
    • Enter the name of the target computer in the Event Log Computer Name box.
  2. Start the server from a Domain Administrators account.
    1. Choose Start > Settings > Control Panel > Services.
    2. Select the remote server to use.
    3. Click Startup.
    4. In the Log On As field, click This Account In.
    5. Click the drop-down list to display the Add Users dialog box.
    6. Double-click an account name in the Domain Administrators group, then click OK.
    7. Click OK at the Service dialog box.
    8. Click Start to exit the utility and enable the server.
Regardless of how you specify the destination computer, be sure that it is configured to record SAP ASE error messages.