• RSS
  • Twitter
  • FaceBook

Welcome to ISAserver.org

Forums | Register | Login | My Profile | Inbox | RSS RSS icon | My Subscription | My Forums | Address Book | Member List | Search | FAQ | Ticket List | Log Out

Logging to SQL sp_batch_insert error

Users viewing this topic: none

Logged in as: Guest
  Printable Version
All Forums >> [ISA 2006 Firewall] >> Logging and Reporting >> Logging to SQL sp_batch_insert error Page: [1]
Login
Message << Older Topic   Newer Topic >>
Logging to SQL sp_batch_insert error - 11.Jan.2008 12:36:22 PM   
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:

The ISA Server Web filter failed to log information to SQL Database ISA_Proxy_Log. The SQL Error description is:
EXECUTE permission denied on object 'sp_batch_insert',

I was able to resolve that one by giving 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

Post #: 1
RE: Logging to SQL sp_batch_insert error - 31.Jan.2008 2:26:46 PM   
william

 

Posts: 2
Joined: 31.May2007
Status: offline
I had exactly the same problem:

I updated isa from 2004 to 2006 and had successfull sql2005 logging in isa2004.
(sql2005 is in same machine as isa)
whatever I tried, always:
The Microsoft Firewall failed to log information to SQL Database ISA. The SQL Error description is: Procedure or function sp_batch_insert has too many arguments specified..

The trick seems to be:

-create a new database  (!)
- I gave database owner rights to sql account that is used in ISA's configure firewall logging tab (this is more than needed)
-also gave NTFS full permission to NETWORK SERVICE to folders where sql ldf & mdf are. (this MAY be more than needed)
- created tables w3proxy.sql & fwsrv.sql.


And voila !, logging isa 2006 to sql2005 works like charm.

But the trick was to CREATE A NEW DATABASE. 

(in reply to WillWeber)
Post #: 2

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [ISA 2006 Firewall] >> Logging and Reporting >> Logging to SQL sp_batch_insert error Page: [1]
Jump to:

New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts