Re: Database logging with IIS 7.0
- From: "Steve Schofield" <steve@xxxxxxxxxxx>
- Date: Fri, 27 Nov 2009 01:51:06 -0500
Hi Thomas,
Here is an article with some additional steps I did to get to ODBC Logging
on IIS 7.5.
http://weblogs.asp.net/steveschofield/archive/2009/11/26/odbc-logging-iis-7-5-sql-server-2008.aspx
Hope this helps,
Steve Schofield
Microsoft MVP - IIS
"Thomas J" <newsgroups101@xxxxxxxxx> wrote in message
news:085c446b-db0a-4981-aa06-1559ada73b17@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi
I am trying to setup database logging with IIS 7. I am following these
instructions:
http://weblogs.asp.net/steveschofield/archive/2007/12/20/iis7-post-57-how-to-setup-odbc-logging-in-iis-7-0.aspx
This is not working and I am receiving the following error in the
System event log:
"The World Wide Web Publishing Service (WWW Service) did not configure
logging for site 1. The data field contains the error number."
This is the same problem that has been experienced here:
http://forums.iis.net/t/1154908.aspx
This is a x64 W2K8 environment. SQL Server is 2008
I have tried the following:
- Logging to a remote SQL Server and logging to a local SQL Express
2008 instance. Same problem.
- Turning on ODBC tracing. No log file was created.
- Turning on SQL Profiler. Nothing was captured.
- Tried all the three SQL Server ODBC clients (SQL Server, Native
Clients, Native Clients 10). No difference
- SQL Server user is a Sys Admin
- Tried using Named Pipes and tried TCP/IP. No difference. (BTW Named
Pipes is enabled on the SQL Servers)
- Cross referenced my configuration with this article:
http://blogs.iis.net/rakkimk/archive/2008/04/16/how-to-configure-iis-7-0-for-odbc-logging.aspx
and checked my appcmd parameters a hundred times. Still no difference.
- UAC is turned off.
I believe this is a problem in IIS. This Event Viewer error message
always appears during the Start phase of an IISRESET, even before a
web resource is even access.
From the applicationHost.config here is the odbcLogging section
<odbcLogging dataSource="InternetDB" tableName="inetlog"
userName="IISLogsUser"
password="[enc:AesProvider:J5roPFr1OyiT4EmFUm1AjeoY3KJF0uGyLaKp9DSBKZE=:enc]"
/
and here is the Site section:
<site name="Microsoft Dynamics CRM" id="1"
serverAutoStart="true">
<application path="/" applicationPool="CRMAppPool">
<virtualDirectory path="/" physicalPath="C:\inetpub
\wwwroot" />
</application>
<application path="/ISV/Praxa/Praxa.Web"
applicationPool="CRMAppPool">
<virtualDirectory path="/" physicalPath="C:\inetpub
\wwwroot\ISV\Praxa\Praxa.Web" />
</application>
<application path="/Help"
applicationPool="CRMAppPool">
<virtualDirectory path="/" physicalPath="C:\inetpub
\wwwroot\Help" />
</application>
<bindings>
<binding protocol="http" bindingInformation=":
80:" />
</bindings>
<logFile customLogPluginClsid="{FF16065B-DE82-11CF-
BC0A-00AA006111E0}" logFormat="Custom" enabled="true" />
</site>
I have spent a full day on this, and my client cannot justify anymore
time. I really hope someone can point me in the right direction.
Regards,
TJ
.
- References:
- Database logging with IIS 7.0
- From: Thomas J
- Database logging with IIS 7.0
- Prev by Date: Re: Database logging with IIS 7.0
- Next by Date: Re: Database logging with IIS 7.0
- Previous by thread: Re: Database logging with IIS 7.0
- Next by thread: Reinstalling IIS7 on Windows 2008 Standard Server
- Index(es):
Relevant Pages
|
