If you are using the IIS Service Properties Logging dialog box, and you select the Log to SQL/ODBC Database option, you have entered a correct DSN and Table. However, when you enter the username and password, they are replaced with blanks when the dialog box is opened again.
The SQL Server log will record the following:
Failure condition - logon failed because there is no valid user account.
The server will report the following error:
ODBC reported an error. The Datasource name "dsn" may be incorrect.
Check the server's event log for details.
The Server's event log indicates that SQL Server rejects the transaction because it is not defined as a valid user.
|
