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.
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. .
From: Colorado, U.S.
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