• 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

Problems logging to SQL

Users viewing this topic: none

Logged in as: Guest
  Printable Version
All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> Problems logging to SQL Page: [1]
Login
Message << Older Topic   Newer Topic >>
Problems logging to SQL - 24.Aug.2004 2:15:00 PM   
jmckell

 

Posts: 6
Joined: 1.Aug.2004
From: Tulsa, OK
Status: offline
I am ready to pull the rest of my hair out (what little I have left) on trying to get ISA 2004 to log to SQL.

I have enabled logging in the system policy, I have configured logging for both firewall and proxy. I have created a table and setup permisssions in SQL for the logging. Everytime I turn on the logging to SQL the Firewall service stops and I get this error in the event log.

Description: The Microsoft Firewall was unable to open ODBC Data Source oscndb10, Table: OKCISAEXFirewallLog, under User Name [isaserver]. The ODBC Error description is: [State=08001][Error=17][Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. [State=01000][Error=1326][Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). .

I have created and put the SQL server on its own VLAN and a third nic in the server to point to that SQL server/VLAN.

WHat am I doing wrong here? "[Mad]" "[Mad]" "[Mad]"
Post #: 1
RE: Problems logging to SQL - 25.Aug.2004 1:21:00 PM   
tshinder

 

Posts: 50013
Joined: 10.Jan.2001
From: Texas
Status: offline
Hi J,

Could it be a name resolution issue?

Thanks!
Tom

(in reply to jmckell)
Post #: 2
RE: Problems logging to SQL - 14.Sep.2004 6:40:00 AM   
HiMem

 

Posts: 1
Joined: 14.Sep.2004
From: Russia
Status: offline
tshinder
and what can i do to avoid this trouble?

Read this CAREFULLY [Big Grin]

http://support.microsoft.com/default.aspx?scid=kb;en-us;838253

[ September 15, 2004, 12:24 PM: Message edited by: HiMem ]

(in reply to jmckell)
Post #: 3
RE: Problems logging to SQL - 15.Sep.2004 5:45:00 PM   
jmckell

 

Posts: 6
Joined: 1.Aug.2004
From: Tulsa, OK
Status: offline
I have read that article and have tried that many time, everyting I turn logging on to SQL it shuts down the firwall service.

(in reply to jmckell)
Post #: 4
RE: Problems logging to SQL - 16.Sep.2004 5:42:00 PM   
liuty2006

 

Posts: 88
Joined: 30.Jun.2004
Status: offline
try this one -- more professional!less memory need!
netfee for isa server
http://www.netfeesoftware.com/NetFee/Index.htm

(in reply to jmckell)
Post #: 5

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> Problems logging to SQL 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