RE: RES: RE: Info II
- From: "Thomas W Shinder" <tshinder@xxxxxxxxxxx>
- To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
- Date: Thu, 1 Sep 2005 11:50:05 -0500
To set up SQL Server for ISA Server logging
1. Set up SQL Server with a database file:
a. On the SQL Server computer, start Enterprise Manager.
b. Connect to the SQL Server computer that you want to host the
database files.
c. On the Tools menu, click SQL Query Analyzer.
d. On the File menu, click Open and open "ISA CD":\Isa.
e. Open one of the following .sql files, based on how you want to
log to an SQL database:
* For the Microsoft Firewall service, open the Fwsrv.sql
file.
* For Web Proxy, open the W3proxy.sql file.
f. Add the following lines to the top of each script:
Create database <database name> Go
Use <database name>
Go
g. On the Query menu, click Execute.
2. Set up SQL Server to accept the Open Database Connectivity (ODBC) data
connection from the ISA Server computer. If ISA Server is not located in the
same Windows Server 2003 domain or Windows 2000 domain, you must set up a SQL
Server account:
a. Start the SQL Enterprise Manager and connect to the SQL Server
computer that you set up to host your databases.
b. Click Microsoft SQL Servers, click SQL Server Group, click
server_name, click Security, and then right-click Logins.
c. Click New Login.
d. If you are located in the same domain as ISA Server, you can
click Windows Authentication.
1. In Name, type: domainname\isaservername$
2. On the Database Access tab, click the databases that
this logon method can access (the databases that you created earlier).
e. If you are located on a different domain than ISA Server, you
must use SQL Server Authentication:
1. (Optional) In Name, type a specific name.
2. Use a name to describe the logon method.
3. Enter a password for this logon method.
4. On the Database Access tab, select the databases that
this logon method can access (the databases that you created earlier).
f. Select Change the default database, and then select the
database to which ISA Server will log data.
g. If you are using SQL Server 2000 or later, you must configure
"SELECT" and "INSERT" permissions.
h. Stop, and then start the SQL Server service.
3. Set up the ODBC data source on the ISA Server computer:
a. Under Administrative Tools, click Data Sources (ODBC).
b. On the System DSN tab, click Add.
c. Click the SQL Server driver, and then click Finish.
d. Assign the data source with the same name that you used for the
database file.
e. Type the name of the SQL Server computer, and then click Next.
f. There are two options for database authentication. These
options correspond to the account that you set up in step two:
* Click With Windows NT authentication using the network
login ID, to use the ISA Server computer account for authentication. This
option can only be used in a Windows Server 2003 or Windows 2000 domain.
* Click With SQL Server authentication using a login ID
and password entered by the user to use an SQL account for authentication.
g. Follow the on-screen instructions.
Thomas W Shinder, M.D.
Site: www.isaserver.org <http://www.isaserver.org/>
Blog: http://spaces.msn.com/members/drisa/
Book: http://tinyurl.com/3xqb7 <http://tinyurl.com/3xqb7>
MVP -- ISA Firewalls
________________________________
From: LEANDRO DOS S. FERREIRA - TI [mailto:LEANDRO@xxxxxxxxxxx]
Sent: Thursday, September 01, 2005 10:11 AM
To: [ISAserver.org Discussion List]
Subject: [isalist] RES: RE: Info II
http://www.ISAserver.org
http://www.ISAserver.org
ok... How I can use the option in IsaServer Log tab to put the database
directly in my SQL.... its just create a DSN connection ???
-----Mensagem original-----
De: Thomas W Shinder [mailto:tshinder@xxxxxxxxxxx]
Enviada em: quinta-feira, 1 de setembro de 2005 12:05
Para: [ISAserver.org Discussion List]
Assunto: [isalist] RE: Info II
http://www.ISAserver.org
http://www.ISAserver.org
Yes, many do.
Thomas W Shinder, M.D.
Site: www.isaserver.org <http://www.isaserver.org/>
Blog: http://spaces.msn.com/members/drisa/
Book: http://tinyurl.com/3xqb7 <http://tinyurl.com/3xqb7>
MVP -- ISA Firewalls
________________________________
From: LEANDRO DOS S. FERREIRA - TI
[mailto:LEANDRO@xxxxxxxxxxx]
Sent: Thursday, September 01, 2005 9:46 AM
To: [ISAserver.org Discussion List]
Subject: [isalist] Info II
http://www.ISAserver.org
http://www.ISAserver.org
Hi...
I would like to know if someone use any kind of
database (for instance SQL Server) to store isa_logs ?
Best Regards
LEANDRO DOS SANTOS FERREIRA
IT Team
<Mailto:leandro@xxxxxxxxxxx>
http://www.cbmm.com.br <http://www.cbmm.com.br/>
CBMM - Companhia Brasileira de Metalurgia e Mineração
This message (including any attachments) is intended
only for the use of the individual or entity to which it is addressed and may
contain information that is non-public, proprietary, privileged, confidential,
and exempt from disclosure under applicable law or may constitute as attorney
work product. If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this communication is
strictly prohibited. If you have received this communication in error, notify
us immediately by telephone and (i) destroy this message if a facsimile or (ii)
delete this message immediately if this is an electronic communication. Thank
you.
------------------------------------------------------
List Archives:
http://www.webelists.com/cgi/lyris.pl?enter=alist
ISA Server Newsletter:
http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ:
http://www.isaserver.org/pages/larticle.asp?typeúQ
------------------------------------------------------
Visit TechGenix.com for more information about our
other sites:
http://www.techgenix.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org
Discussion List as: tshinder@xxxxxxxxxxxxxxxxxx
To unsubscribe visit
http://www.webelists.com/cgi/lyris.pl?enter=alist
Report abuse to listadmin@xxxxxxxxxxxxx
------------------------------------------------------
List Archives:
http://www.webelists.com/cgi/lyris.pl?enter=alist
ISA Server Newsletter:
http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ:
http://www.isaserver.org/pages/larticle.asp?typeúQ
------------------------------------------------------
Visit TechGenix.com for more information about our
other sites:
http://www.techgenix.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org
Discussion List as: tshinder@xxxxxxxxxxxxxxxxxx
To unsubscribe visit
http://www.webelists.com/cgi/lyris.pl?enter=alist
Report abuse to listadmin@xxxxxxxxxxxxx
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=alist
ISA Server Newsletter:
http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ:
http://www.isaserver.org/pages/larticle.asp?typeúQ
------------------------------------------------------
Visit TechGenix.com for more information about our other sites:
http://www.techgenix.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion
List as: leandro@xxxxxxxxxxx
To unsubscribe visit
http://www.webelists.com/cgi/lyris.pl?enter=alist
Report abuse to listadmin@xxxxxxxxxxxxx
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=alist
ISA Server Newsletter:
http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ:
http://www.isaserver.org/pages/larticle.asp?typeúQ
------------------------------------------------------
Visit TechGenix.com for more information about our other sites:
http://www.techgenix.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion
List as: leandro@xxxxxxxxxxx
To unsubscribe visit
http://www.webelists.com/cgi/lyris.pl?enter=alist
Report abuse to listadmin@xxxxxxxxxxxxx
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=alist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?typeúQ
------------------------------------------------------
Visit TechGenix.com for more information about our other sites:
http://www.techgenix.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
tshinder@xxxxxxxxxxxxxxxxxx
To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=alist
Report abuse to listadmin@xxxxxxxxxxxxx
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=alist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?typeúQ
------------------------------------------------------
Visit TechGenix.com for more information about our other sites:
http://www.techgenix.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
tshinder@xxxxxxxxxxxxxxxxxx
To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=alist
Report abuse to listadmin@xxxxxxxxxxxxx
Other related posts:
