[isalist] Re: Every time i try to configure sql logging...

http://www.ISAserver.org
-------------------------------------------------------
  
We need to know what error you got when ISA tried to log to the SQL
database-- specific details...

Without detailed information, we can't effectively troubleshoot SQL logging
problems.  It could be issues with connectivity (i.e. Ensuring that you have
access rules that allow the ISA box to connect to the SQL box via TCP/Names
Pipes, etc), permissions on the SQL server, user/service logon issues,
ODBC/Library configs, name resolution, etc... any number of things,
really... 

I leverage SQL logging extensively, and am happy to help, but I need more
detailed info to do so...

t






On 10/28/06 6:24 PM, "Michael Ross" <mross@xxxxxxxxxxx> spoketh to all:

> the error from isa mgmt just said the service couldnt start
> the event log gave me a 11004 i think.
> i had to uninstall and reinstall ISA again last night.
> 
> ________________________________
> 
> From: isalist-bounce@xxxxxxxxxxxxx on behalf of Thor (Hammer of God)
> Sent: Sat 10/28/2006 3:09 PM
> To: isalist@xxxxxxxxxxxxx
> Subject: [isalist] Re: Every time i try to configure sql logging...
> 
> 
> What was the error?  If lockdown is enabled, and the firewall service can't
> log, it will shut down...   Let me know what error you're getting and we can
> go from there...
> t
> 
> 
> On 10/27/06 8:10 PM, "Michael Ross" <mross@xxxxxxxxxxx> spoketh to all:
> 
> 
> 
> ok
> i finally got the system setup the way i wanted it (isa 2004), minus the sql
> logging. I wanted to change it from msde to sql 2005, sql 2005 is on a
> seperate server.
> i did a backup of the ISA server config from the ISA manager (right click the
> isa server, and choose backup).
> i created the db's, ran the scripts, followed the help file to the letter.
> i tried to configure ISA to log to the SQL server, and it didnt work.. ISA
> gave me an error.
> so, I restored my ISA box from the backup file, and now the Firewall service
> wont start.
> Event ID11004, even after a reboot
> im about to totally give up on getting it to log to SQL.. The last time this
> happened, I had to uninstall ISA, reinstall it, patch it, then do my restore.
> i know im an idiot.. but what in the world am i doing wrong?
> 
> 
> 
> 
> 


------------------------------------------------------
List Archives: http://www.freelists.org/archives/isalist/  
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp 
ISA Server Articles and Tutorials: http://www.isaserver.org/articles_tutorials/ 
ISA Server Blogs: http://blogs.isaserver.org/ 
------------------------------------------------------
Visit TechGenix.com for more information about our other sites:
http://www.techgenix.com 
------------------------------------------------------
To unsubscribe visit http://www.isaserver.org/pages/isalist.asp 
Report abuse to listadmin@xxxxxxxxxxxxx

Other related posts: