Re: ISA Connection to SQL Logging DB Drops

Take a look at these two articles for configuring logging and
troubleshooting logging issues:

http://www.microsoft.com/technet/prodtechnol/isa/2004/plan/tb_logging.mspx
http://www.microsoft.com/technet/prodtechnol/isa/2004/plan/logging-best-practices.mspx

Rayne Wiselman [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.

"Larry Bird" <LarryBird@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BF335358-ECA3-4865-9B1D-E07D5DBFF991@xxxxxxxxxxxxxxxx
> I've had ISA logging to an SQL DB for about a week. Everything was
> working
> fine. Starting Saturday the connection between ISA and the SQL DB
> starting
> dropping. The lost connection between the two causes the Firewall to
> stop.
> I check the SQL Database to make sure the USERID is good and that the ISA
> service account for connecting to the database is OK. Everything appears
> to
> be fine. I then go over to the ISA storage server console and the the
> connection the database and it works just fine. I then re-start the
> Firewall
> service on the server and it starts with no problems. After about 5
> minutes
> the Firewall stops because it can't logon on the ISA Logging Database. No
> matter what I do I can re-connect to the Database and things will run for
> a
> while then just stop because on the Firewall not being able to connect the
> database. The SQL logon account does have permissons to execute the
> stored
> procedure "sp_batch_insert".
>
> As any body seen this type of behavior?
>
> I decided to use the local msde database until I figure out what's causing
> this to occur. So far everything is working fine. But I really need and
> want to do all of my logging to a SQL database. My SQL server box is SQL
> Server 2000 EE. I have other application using the same server with no
> problems to include Microsoft server products.
>
> Any input will help.
>
> Thanks
>


.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)