How to use SQL 2005 as Database Server for ISA Server 2004 logging (Full Version)

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



Message


shnaeemriaz -> How to use SQL 2005 as Database Server for ISA Server 2004 logging (14.Jul.2009 5:43:44 PM)

Dear All,

Kindly let me know step by step configuration How to use SQL 2005 as Database Server for ISA Server 2004 logging.

2ndly how can i generate customized user reports using MS Visual Studio 2005.

thnx in advance.

Naeem




richardhicks -> RE: How to use SQL 2005 as Database Server for ISA Server 2004 logging (14.Jul.2009 8:17:03 PM)

Hi Naeem,

I can't really answer your second question, but I can answer your first question.  With regard to enabling remote SQL logging on ISA Server 2004, take a look at my blog post here:

http://tmgblog.richardhicks.com/2009/05/29/remote-sql-logging-with-microsoft-isa-server-2006/

I think the only thing different with ISA Server 2004 is that you have to use ODBC.  If you configure an ODBC connection to the SQL server I think the rest of my article still applies.

Thanks!




elmajdal -> RE: How to use SQL 2005 as Database Server for ISA Server 2004 logging (15.Jul.2009 4:02:32 AM)

Hi,

How to configure ISA Server 2004, ISA Server 2006, and Microsoft Forefront Threat Management Gateway, Medium Business Edition to log data to an SQL Server database




Page: [1]