On the computer running SQL Server, start Enterprise
Manager.
Connect to the computer running SQL Server that you want to
host the database files.
On the Tools menu, click SQL Query Analyzer.
On the File menu, click Open and open "ISA
CD":\FPC\Program Files\Microsoft ISA Server.
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.
Create a database.
Add the following lines to the top of each script:
Use <database name>
Go
On the Query menu, click Execute.
Set up SQL Server to accept the 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:
Start the SQL Enterprise Manager and connect to the computer
running SQL Server that you set up to host your databases.
Click Microsoft SQL Servers, click SQL Server
Group, click server_name, click Security,
and then right-click Logins.
Click New Login.
If you are located in the same domain as ISA Server, you can
click Windows Authentication.
In Name, type:
domainname\isaservername$
On the Database Access tab, click the databases that
this logon method can access (the databases that you created
earlier).
For ISA Server 2006 Enterprise Edition, in an array
configuration, a separate logon should be created for each array
member.
If you are located on a different domain than ISA Server, you
must use SQL Server authentication:
In Name, type a specific name.
Use a name to describe the logon method.
Enter a password for this logon method.
On the Database Access tab, select the databases that
this logon method can access (the databases that you created
earlier).
Select Change the default database, and then select the
database to which ISA Server will log data.
Configure SELECT and INSERT permissions for the table.
Configure EXECUTE permissions for the sp_batch_insert procedure for
ISA Server services for logging to this database.
Notes
For ISA Server 2006 Enterprise Edition, by default, ISA
Server uses a Secure Sockets Layer (SSL)-encrypted connection to
the computer running SQL Server, to help secure the sensitive data
in the log files. To enable this connection, you must install a
root certification authority (CA) certificate on the array members.
For more information, see HOW TO:
Enable SSL Encryption for SQL Server 2000 with Certificate
Server(http://www.microsoft.com/).
For ISA Server 2006 Standard Edition, by default, ISA
Server uses a Secure Sockets Layer (SSL)-encrypted connection to
the computer running SQL Server, to help secure the sensitive data
in the log files. To enable this connection, you must install a
root certification authority (CA) certificate on the ISA Server
computer. For more information, see HOW TO:
Enable SSL Encryption for SQL Server 2000 with Certificate
Server(http://www.microsoft.com/).
For ISA Server 2006 Enterprise Edition, we recommend that
you use Ethernet cards for the Peripheral Component Interconnect
(PCI) bus with transfer rates of 100 megabits per second for
communication between the array members and the computer running
SQL Server.
For ISA Server 2006 Standard Edition, we recommend that
you use Ethernet cards for the Peripheral Component Interconnect
(PCI) bus with transfer rates of 100 megabits per second for
communication between the ISA Server computer and the computer
running SQL Server.