• 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

Reports failed with SQL 2005 SP2

Users viewing this topic: none

Logged in as: Guest
  Printable Version
All Forums >> [ISA 2006 Firewall] >> Logging and Reporting >> Reports failed with SQL 2005 SP2 Page: [1]
Login
Message << Older Topic   Newer Topic >>
Reports failed with SQL 2005 SP2 - 2.May2007 8:27:37 AM   
bjwild

 

Posts: 1
Joined: 2.May2007
Status: offline
I just installed Isa 2006 std in a virtual environment on Windows 2003 R2 Std + Sp2 and changed the logging to a SQL 2005 SP2 Database.

Now everytime i want to make a report it gives me a instant failure with the following alert:

Source: Microsoft ISA Report Generator
Event ID: 21022

The action to summarize all period summaries from the array, into report "1" failed. The error description is: Unspecified error
. Use the source location 1200.193.5.0.5720.157 to report the failure.


Source: Microsoft ISA Report Generator
Event ID: 21000
 
The action to connect to ISA Server report data collector on array member ULC-ISASERVER failed.  The error description is: The server threw an exception.
. Use the source location 1201.414.5.0.5720.157 to report the failure.

My database connection goes thru the test, i checked the database and everything works.

I connect to the database as SA

Searching for the event id or keywords havn't gotten me anywhere.
Using MSDE does create reports for me.

Hope someone had this problem and knows the solution

< Message edited by bjwild -- 2.May2007 2:37:27 PM >
Post #: 1
RE: Reports failed with SQL 2005 SP2 - 3.Jul.2007 1:52:19 PM   
Yorgy

 

Posts: 158
Joined: 20.Sep.2006
Status: offline
This link might help.
It almost sounds like the problem you may be experiencing.

http://www.microsoft.com/technet/isa/2004/plan/disablelockdownonlogfailure.mspx


HIH
Yorgy

_____________________________

Life is a zoo in a jungle!

(in reply to bjwild)
Post #: 2

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [ISA 2006 Firewall] >> Logging and Reporting >> Reports failed with SQL 2005 SP2 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