Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Logging to an SQL database in ISA Server 2004 or in Forefront Threat Management Gateway does not work


View products that this article applies to.

Symptoms

If you configure Microsoft Internet Security and Acceleration (ISA) Server 2004 logging or Microsoft Forefront Threat Management Gateway, Medium Business Editiong logging to log to a Microsoft SQL database, you may receive the following error message:
"Unknown" (error code 0x80040e09, DB_SEC_E_PERMISSIONDENIED)
However, if you use the Test button in the New Connectivity Verifier Wizard, the test is successful.

↑ Back to the top


Cause

This issue may occur when the user account that is configured for SQL logging in ISA Server 2004 or in Forefront Threat Management Gateway 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.

↑ Back to the top


Resolution

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

↑ Back to the top


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

↑ Back to the top


Keywords: KB890307, kbprb, kbtshoot

↑ Back to the top

Article Info
Article ID : 890307
Revision : 5
Created on : 8/15/2006
Published on : 8/15/2006
Exists online : False
Views : 406