Although a valid SQL Server user name and password are entered on the Logging property sheet in Internet Service Manager, they might seem to disappear when you start Internet Service Manager.
This is a problem with SQL Server Login Security Mode set to Integrated. In Integrated mode, the user name and password specified in Internet Service Manager are ignored because SQL Server attempts to use the logon account specified when the computer running the IIS server was started. Because this account probably does not have permission to use SQL Server, Internet Information Server logging to SQL Server fails and the SQL Server log records this message:
And the IIS server reports the following:
To resolve this issue, set the SQL Server Login Security Mode to Mixed. This setting enables the IIS server to access SQL Server for logging. Access to SQL Server by using other access methods is unaffected.
For more information about SQL Server Login Security Mode, see Part 4, "Security," of the Administrator's Companion in the Microsoft SQL Server Books Online.
The Microsoft Internet Information Server log file contains a Time field. This field displays the elapsed time from the start of a request (connect) until the request is finished and the item is about to be logged. The value represents only a checkpoint in terms of millisecond difference.