By default, if event logging is enabled, Adaptive Server logs messages to the NT event log on the local computer system.
To change the destination computer for logging messages:
Set event log computer name with sp_configure on the local computer. Use either:
sp_configure, as in the following command line, or:
sp_configure "event log computer name", 0, user1
Enter the name of the target computer in the Event Log Computer Name box on the Event Logging dialog box.
To display the name box, see “Using Server Config”.
Start the server from a Domain Administrators account.
Choose Start/Settings/Control Panel/Services.
Select the remote server to use from the list.
Click Startup.
Click This Account in the Log On As box.
Open the drop-down list to display the Add Users dialog box.
Double-click an account name that is in the Domain Administrators group, and click OK.
Click OK at the Service dialog box.
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 Adaptive Server error messages. To configure the destination computer, see “Using a central logging site”.