ISA server 2004 logging to SQL 2005 EXpress

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

Since I upgraded the MSDE 2000 tot SQL Server 2005 Express, my event logs fill up with event 17137 "Starting up database" (thousands of them).
It is related to the Autoclose=true property of the logging tables that ISA uses.
I can change that option, but ISA creates a new table each day which has again Autoclose=true.
How can I disable this option permanently? I don't want the SQL server to close/reopen the logging table thousands of times a day!

TIA

--
Paul



.

Relevant Pages

  • Re: ISA 2004 - disable MSDE
    ... I've heard that when logging is to an SQL server, ... Follow through the rest of> the wizard and your ISA will be the same, ... I'm tried to stop the> service, but depedences of Microsoft Firewall don't allow me to do> that. ...
    (microsoft.public.isaserver)
  • Re: ISA Enterprise Advanced Logging
    ... go to Add/Remove Programs and change the ISA installation. ... When prompted, remove "Advanced Logging". ... MSDE will be gone from your ISA at this point. ... logging is being done to a centralized SQL Server on the Internal network ...
    (microsoft.public.isa)
  • Re: MSSQL$MSFW :: Can I connect to it with SQL Server Enterprise Manager?
    ... analyze logs. ... Logging is also accessible through ISA administration API. ... > The question is - can I connect to this instance with either SQL Server ...
    (microsoft.public.isa.configuration)
  • Re: How can I publish a named instance of SQL server?
    ... There is nothing in event logs or monitoring reports that I can see. ... The sql server instance is on the same box as the ISA. ... "Jens Baier" wrote: ...
    (microsoft.public.isa.publishing)
  • Re: Why use SQL Server for logs
    ... Also dealing with a SQL database ... >If ISA logging is turned on then ISA must log, ... >> Is there anygood reason for using SQL Server for storing ...
    (microsoft.public.isa)