I am having a problem trying to get my Routing and Remote Access server to
log to my SQL Server. My RRAS Server is also running ISA 2004. I created a
blank database on my SQL server and then in RRAS I picked that database.
When
I click Test Connection it says succeeded. Both the RRAS and SQL server
are
members of the same domain. (I am using NT Security setting in RRAS).
In the ISA System Policy Editor I enabled Remote Logging (SQL and
NetBIOS).
The problem is that nothing is logged in my SQL database.
What am I missing here? I found 2 scripts to create a database for ISA
Server logging (WebProxy and Firewall), is there something like this for
the
RRAS log? Do I need to create some type of ODBC connection on the RRAS
server? Do I to create a special username on the SQL server?