Microsoft KB Archive/890307

= Logging to an SQL database in ISA Server 2004 does not work =

Article ID: 890307

Article Last Modified on 8/15/2006

-

APPLIES TO


 * Microsoft Internet Security and Acceleration Server 2004 Standard Edition

-





SYMPTOMS
If you configure Microsoft Internet Security and Acceleration (ISA) Server 2004 logging to log to a Microsoft SQL database, you may receive the following error message:

&quot;Unknown&quot; (error code 0x80040e09, DB_SEC_E_PERMISSIONDENIED)

However, if you use the Test button in the New Connectivity Verifier Wizard, the test is successful.



CAUSE
This issue may occur when the user account that is configured for SQL logging in ISA Server 2004 does not have sufficient permissions configured on the SQL Server to insert records to the log database, or to run a bulk-insertion stored procedure.

Note The Test configuration button tests connectivity to the SQL database. It does not test the ability to read or write to it.



RESOLUTION
To resolve this issue, make sure that the account that you use for SQL logging in ISA Server 2004 has the appropriate read and write permissions configured on the computer that is running SQL Server.



MORE INFORMATION
For additional information about how to configure connectivity verifiers, click the following article number to view the article in the Microsoft Knowledge Base:

839509 How to configure connectivity verifiers to monitor selected computers and networks in ISA Server 2004

Keywords: kbtshoot kbprb KB890307

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.