Re: Logging to SQL Server
- From: "cismic" <cismic@xxxxxxx>
- To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
- Date: Mon, 12 Apr 2004 10:57:53 -0700
ISA Server >> ODBC DRIVER >> REMOTE SQL
On my ISA Server I utilize HOSTS FILE. I setup where my SQL machine resides
so that when I create an ODBC rule, the host header knows what to grab.
I'm not sure where your SQL machine resides. I have a back to back setup
ISASERVER >> DMZ >> ISASERVER >> SQL MACHINE
On my second ISA server is where I have the publishing rule for the SQL
machine. Machines in the DMZ use the hosts file to point to the external
NIC of the internal ISASERVER.
I also, don't use "SA" without a password nor do I use "SA" with a password
on my machines in the DMZ or external ISASERVER.
On my SQL Machine, I create a local user (example) LoggingUser with log on
locally rights. Then I create a new logon user in SQL and point to my
statistics DB as the default DB for that user.
Once all that is done and you have created similar users on the machines in
the DMZ then you can utilize a trusted connection via only with
"LoggingUser" This user does not need to be part of the internal ACTIVE
DIRECTORY. So, when you create you ODBC connection specify the LoggingUser
account along with your password that you setup for that account. Rember
the password would be the same on the ISASERVER LoggingUser and the SQL
LoggingUser.
HTH,
Joseph
----- Original Message -----
From: "Greg Hess" <gmh@xxxxxxxx>
To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
Sent: Monday, April 12, 2004 8:58 AM
Subject: [isalist] Logging to SQL Server
http://www.ISAserver.org
Hello everyone,
I am trying to configure logging to our SQL server from our ISA
server. I followed the article on ISAserver.org and I can test the ODBC
connection fine, but when I configure the logging and restart the
service I get an error indicating I don't have permissions. This is a
remote SQL box, do I have to configure the services to start under
another user account or...something? Any help is appreciated.
Tx.
Greg.
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
Leading Network Software Directory: http://www.serverfiles.com
No.1 Exchange Server Resource Site: http://www.msexchange.org
Windows Security Resource Site: http://www.windowsecurity.com/
Network Security Library: http://www.secinf.net/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
cismic@xxxxxxx
To unsubscribe send a blank email to $subst('Email.Unsub')
Other related posts:
