• 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

FireWall service stoped - loggin in Sql DB

Users viewing this topic: none

Logged in as: Guest
  Printable Version
All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> FireWall service stoped - loggin in Sql DB Page: [1]
Login
Message << Older Topic   Newer Topic >>
FireWall service stoped - loggin in Sql DB - 1.Jun.2005 3:51:00 AM   
Rainmib

 

Posts: 2
Joined: 1.Jun.2005
Status: offline
The standard instalation of Isa server 2004(sp1)(win2003) - perfomed to login in the Sql2000 datebase witch is playing on enother server(win2000).

Yesterday Firewall service was stoped with Error event:
Event id: 6
siorce: Microsoft Farewal
Details:

The ISA Server Web filter failed to log information to ODBC Data Source ISAD,
Table: WebProxyLog, under User Name [Domain\isaview]. The ODBC Error description is:
[State=01004][Error=0][Microsoft][ODBC SQL Server Driver]Fractional truncation
[State=22003][Error=8115][Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic
overflow error converting expression to data type int. [State=01000][Error=3621][Microsoft]
[ODBC SQL Server Driver][SQL Server]The statement has been terminated. .

After restart the service is goin to work, but only for 10-30 secnds - and faild again with same Error event.

I'ld have to redirect logging to files....

I'm amused - and in panic "[Frown]"

My system based on Sql DB is't work

Sombody help me....
Post #: 1
RE: FireWall service stoped - loggin in Sql DB - 2.Jun.2005 9:53:00 AM   
Rainmib

 

Posts: 2
Joined: 1.Jun.2005
Status: offline
Clear datebase - now it's werk - but no so match

(in reply to Rainmib)
Post #: 2
RE: FireWall service stoped - loggin in Sql DB - 20.Jun.2005 7:52:00 AM   
sandhu15

 

Posts: 17
Joined: 7.Feb.2002
From: india
Status: offline
hi
I am getting the same problem, Whenever i try to send the logging to sql server , the firewall service gets stop. And i am getting the following error.

The ISA Server Web filter was unable to open ODBC Data Source Isa, Table: WebProxyLog, under User Name [SERWIZSOL\Isauser]. The ODBC Error description is: [State=28000][Error=18456][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'SERWIZSOL\IPMARMPS01$'. [State=01000][Error=0][Microsoft][ODBC SQL Server Driver]An error has occurred during an attempt to access the log file, logging disabled. .

Please help me solve this probelm.

(in reply to Rainmib)
Post #: 3
RE: FireWall service stoped - loggin in Sql DB - 4.Oct.2005 10:23:00 AM   
Pheylan

 

Posts: 12
Joined: 5.May2004
From: Colorado, U.S.
Status: offline
Just in case anyone else hits this same question in their searches, or if any of you posters come back to check to see if a solution has been posted; here is a link to the MS KB article that has a complete walk through to get SQL logging up and running: KB 838710

(in reply to Rainmib)
Post #: 4

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> FireWall service stoped - loggin in Sql DB 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