• 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

ISA+SQL-MSDE

Users viewing this topic: none

Logged in as: Guest
  Printable Version
All Forums >> [ISA 2006 Firewall] >> Logging and Reporting >> ISA+SQL-MSDE Page: [1]
Login
Message << Older Topic   Newer Topic >>
ISA+SQL-MSDE - 1.Feb.2008 4:29:50 AM   
zabirovr

 

Posts: 2
Joined: 21.Dec.2007
Status: offline
Hi,


In my test environment ISA server 2006 Enterprise Edition configured to log data to an SQL Server 2005 database. I've seen that logs exist in database through SQL Server console. When I try to query historical data by changing value of "Log Time" to "Last hour" I get an error "The query stopped because an error while it was running". The query stops successfully only when "Advanced Logging" component installed. So does ISA Server need MSDE to query data from SQL Server?

< Message edited by zabirovr -- 4.Feb.2008 9:30:05 AM >
Post #: 1
RE: ISA+SQL-MSDE - 19.May2008 2:02:09 PM   
DarkFear_DK

 

Posts: 12
Joined: 1.Feb.2003
Status: offline
Hi zabirovr

We are experiencing the same as you. I would also like to hear from someone who has been working with ISA+SQL logging and knows why this is so?

We are using ISA EE + SQL 2005 EE, so there shouldn't be any "lesser version limits" there.

Do you have any new experiences to share? :)

Thx, D.

(in reply to zabirovr)
Post #: 2
RE: ISA+SQL-MSDE - 24.Jun.2008 11:23:41 AM   
itadmin

 

Posts: 30
Joined: 21.Jul.2006
Status: offline
We have the same issue.  I am going to search through the old posts and Microsoft's site, but I haven't seen anything in the past.

(in reply to DarkFear_DK)
Post #: 3
RE: ISA+SQL-MSDE - 24.Jun.2008 11:25:52 AM   
itadmin

 

Posts: 30
Joined: 21.Jul.2006
Status: offline
My problem is the version, according to this post.

http://forums.isaserver.org/***INFO***_ISA%2bRemoteSQL%2bHistorical_Logging/m_2002066528/tm.htm

(in reply to itadmin)
Post #: 4
RE: ISA+SQL-MSDE - 24.Jun.2008 2:19:42 PM   
DarkFear_DK

 

Posts: 12
Joined: 1.Feb.2003
Status: offline
Hi again all,

I've got an update for you.. I was fiddling around with this particular problem and realised that when MSDE was installed onto the ISA it could successfully query the SQL server - even though the MSDE was not being used for anything.

I talked to our technical account manager at Microsoft who then asked other Microsoft specialists who then replied that, sad as it may be, is a bug and that they apparently are aware of it (but haven't acknowledged it?).
The bug is that the ISA server in some cases have a tendency to check if MSDE is installed and if it isn't then it stops with the error "the query stopped because an error occurred while it was running".

Our TAM also said that it will be fixed in service pack 1 for ISA.

So for my concern I'll just have to wait until this is fixed... :(

(in reply to zabirovr)
Post #: 5

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [ISA 2006 Firewall] >> Logging and Reporting >> ISA+SQL-MSDE 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