Welcome to ISAserver.org

ISA 2006 webproxy logging to SQL error

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [ISA 2006 Web Proxy] >> General >> ISA 2006 webproxy logging to SQL error

Page: [1]

Message

<< Older Topic Newer Topic >>

ISA 2006 webproxy logging to SQL error - 8.Jan.2008 10:37:19 AM

WillWeber

Posts: 4
Joined: 9.Nov.2007
Status: offline

I've run into an error that I can't find any information about. I'm hoping that someone here can help shed some light on the problem.

I've got logging for the webproxy setup to point to a SQL database on another server in the same domain. When I first set things up I came with an error like this one:

EXECUTE permission denied on object 'sp_batch_insert',

I was able to resolve that one by giving the database owner privledges to the user that is making the connection to the Proxy Log Database.

However, after a day ISA stopped being able to log to the database and the Microsoft Firewall Service shut down (causing ISA to stop working) and I now see the following error message in the event logs:

The ISA Server Web filter failed to log information to SQL Database ISA_Proxy_Log. The SQL Error description is:

Procedure or function sp_batch_insert has too many arguments specified.

I'm completely stumped as to where to go from here. I have no controll over how many arguments are being sent by ISA. I'm not even that familiar with the sp_batch_insert procedure. I'm assuming it's a stored procedure that was setup when I created the Log Database.

Any help or suggestions are greatly appreciated. Thank you,

Will