Welcome to ISAserver.org

SQL Server Logging

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> SQL Server Logging

Page: [1]

Message

<< Older Topic Newer Topic >>

SQL Server Logging - 12.Mar.2008 1:45:33 AM

johndejesus_gabriel

Posts: 11
Joined: 28.Nov.2007
Status: offline

I am done configuring my SQL server for logging the firewall and web proxy logs. But everytime I click apply, the firewall service suddenly stops so my users can't able to access the internet. I tried to restart the service but no avail. The firewall service starts when I revert back the logging settings to its default. What seems to be the problem here? I am not sure where to look at. Thanks,John de Jesus

Post #: 1

Featured Links*

RE: SQL Server Logging - 12.Mar.2008 12:05:47 PM

elmajdal

Posts: 6022
Joined: 16.Sep.2004
From: Lebanese in Kuwait
Status: offline

Hi,

check this article to see if you have done anything wrong : http://isaserver.org/tutorials/Firewall-Logging-Microsoft-SQL-database.html

_____________________________

Tarek Majdalani

Windows Expert - IT Pro MVP
Facebook : https://www.facebook.com/ElMajdal.Net

(in reply to johndejesus_gabriel)

Post #: 2

RE: SQL Server Logging - 12.Mar.2008 12:53:50 PM

johndejesus_gabriel

Posts: 11
Joined: 28.Nov.2007
Status: offline

FYI. My MS SQL Server were installed on the same server as the ISA Server 2004.

(in reply to johndejesus_gabriel)

Post #: 3

RE: SQL Server Logging - 13.Mar.2008 4:33:48 AM

johndejesus_gabriel

Posts: 11
Joined: 28.Nov.2007
Status: offline

Hi, Still not working, I have this error (see details below):
The Microsoft Firewall failed to log information to ODBC Data Source ISALOG, Table: FirewallLog, under User Name [TELWISE-ISA\Administrator]. The ODBC Error description is: [State=01004][Error=0][Microsoft][SQL Native Client]Fractional truncation [State=S0002][Error=208][Microsoft][SQL Native Client][SQL Server]Invalid object name 'FirewallLog'. [State=37000][Error=8180][Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared.

Do I need to make a statement on the "fwsrv.sql" file?

Thanks,
John

(in reply to elmajdal)

Post #: 4

RE: SQL Server Logging - 31.Mar.2008 8:10:24 AM

kriss3d

Posts: 5
Joined: 24.Mar.2008
Status: offline

I got same problem though not same details. It seems that the windows firewall stops working if it cant connect to a database..

(in reply to johndejesus_gabriel)

Post #: 5

RE: SQL Server Logging - 31.Mar.2008 8:19:18 AM

johndejesus_gabriel

Posts: 11
Joined: 28.Nov.2007
Status: offline

I got this working now. check the DB and login security on the SQL Server.

(in reply to kriss3d)

Post #: 6

RE: SQL Server Logging - 31.Mar.2008 8:46:08 AM

kriss3d

Posts: 5
Joined: 24.Mar.2008
Status: offline

Hm you might got somthing there.. it just seems like i cant add the local users to the security on it.. but ill try fiddling with it.. eventually ill get it.. i hope.

(in reply to johndejesus_gabriel)

Post #: 7