• 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

Microsoft Firewall failed to log information to MSDE Database

Users viewing this topic: none

Logged in as: Guest
  Printable Version
All Forums >> [ISA 2006 General] >> General >> Microsoft Firewall failed to log information to MSDE Database Page: [1]
Login
Message << Older Topic   Newer Topic >>
Microsoft Firewall failed to log information to MSDE Da... - 12.Dec.2007 3:43:27 PM   
ogsi

 

Posts: 61
Joined: 14.Feb.2007
From: New York, NY
Status: offline
Firewall service & Remote Access service crashed with this error:
Description: The Microsoft Firewall failed to log information to MSDE Database ISALOG_20071212_FWS_000 in path C:\Program Files\Microsoft ISA Server\ISALogs. The MSDE Error description is: Unspecified error
. The problem may be resolved by restarting the MSSQL$MSFW service.
The failure is due to error: Unspecified error

once I've started the Firewall service it everything is working

there are no other errors

any ideas?
Post #: 1
RE: Microsoft Firewall failed to log information to MSD... - 12.Dec.2007 3:56:58 PM   
ogsi

 

Posts: 61
Joined: 14.Feb.2007
From: New York, NY
Status: offline
ok. I found this on a MS page (http://www.microsoft.com/technet/isa/2004/plan/tb_logging.mspx):

Error Accessing sp_batch_insert Procedure
Problem: The Firewall service may report an error accessing the sp_batch_insert procedure, causing the Firewall service to fail, thereby causing ISA Server to lock down. In this case, you will see the following event:
The Microsoft Firewall failed to log information to MSDE
Database ISALOG_20041217_FWS_001 in path D:\Program Files\Microsoft
ISA Server\ISALogs. The MSDE Error description is: Could not find
stored procedure 'sp_batch_insert'.. The problem may be resolved by
restarting the MSSQL$MSFW service.
Cause: This is caused because there are too many active logs.
Solution: Reduce the number of active logs being maintained by MSDE.

now, how do I reduce the number of active logs?

(in reply to ogsi)
Post #: 2
RE: Microsoft Firewall failed to log information to MSD... - 13.Dec.2007 10:08:16 AM   
tshinder

 

Posts: 50013
Joined: 10.Jan.2001
From: Texas
Status: offline
Now that's a good question!

Try changing to text logging and then change right back to MSDE logging and see if that helps.

Tom


_____________________________

Thomas W Shinder, M.D.

(in reply to ogsi)
Post #: 3
RE: Microsoft Firewall failed to log information to MSD... - 13.Dec.2007 10:24:19 AM   
ogsi

 

Posts: 61
Joined: 14.Feb.2007
From: New York, NY
Status: offline
how do you make this change?

(in reply to tshinder)
Post #: 4
RE: Microsoft Firewall failed to log information to MSD... - 14.Dec.2007 10:47:47 AM   
tshinder

 

Posts: 50013
Joined: 10.Jan.2001
From: Texas
Status: offline
Go to the logging tab in the Monitoring node and configure it there.

Tom

_____________________________

Thomas W Shinder, M.D.

(in reply to ogsi)
Post #: 5
RE: Microsoft Firewall failed to log information to MSD... - 14.Dec.2007 11:54:28 AM   
ogsi

 

Posts: 61
Joined: 14.Feb.2007
From: New York, NY
Status: offline
thanks!
now I'll have to wait and see if it happen again

(in reply to tshinder)
Post #: 6

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [ISA 2006 General] >> General >> Microsoft Firewall failed to log information to MSDE Database 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