1. Create a database that contains a table with the appropriate fields for the logging data. Microsoft Internet Information Service (IIS) includes a Structured Query Language (SQL) template file, which can be run in a SQL database to create a table that accepts log entries from IIS. The file is called Logtemp.sql and is available in the Winnt\System32\Inetsrv folder. The following fields are required:
   • ClientHost: varchar(255)
   • Username: varchar(255)
   • LogTime: datetime
   • Service: varchar(255)
   • Machine: varchar(255)
   • ServerIP: varchar(50)
   • ProcessingTime: int
   • BytesRecvd: int
   • BytesSent: int
   • ServiceStatus: int
   • Win32Status: int
   • Operation: varchar(255)
   • Target: varchar(255)
   • Parameters: varchar(255)
2. In Exchange System Manager, click the virtual server that you want to configure.
3. On the Action menu, click Properties.
4. On the General tab, click to select the Enable Logging check box.
5. In the Active log format list, click ODBC Logging.
6. Click Properties to gain access to the ODBC Logging properties.
7. Type the ODBC Data Source Name (DSN).
8. Type the name of the table.
9. Type the user name and password that you need to use to gain access to the database.
10. Click OK or Apply to save the settings.

The information in this article applies to:

• Microsoft Exchange 2000 Server