From: Steve Schofield on 28 Nov 2009 11:41 I also tried changing my app pool to classic, in my experience it didn't matter if it was integrated or classic mode. SS "Thomas J" <newsgroups101(a)gmail.com> wrote in message news:e756ce9c-0741-4e0e-b692-aed956696f49(a)f20g2000prn.googlegroups.com... > Hi Jeffrey, this sounds promising. Looking forward to your response. > > Hi Steve. Thanks for your follow up Blog post. I tried your > suggestions: > - I changed the App Pool owner to a domain user, added this domain to > the local IIS_IUSRS group, and to SQL Server as a DBO. > Unfortunately this made no difference. I check the SQL Server logs I > have never experiencing the 'Login Failed' issue which you > experienced. I don't understand why the App Pool must run as a domain > user; authentication to SQL Server should be handled by the ODBC > connection. I am relucent to change the App Pool owner in production > as it is currently running with Network Service, and changing this > will require system testing. I noticed one difference with your App > Pool setup; my site has the setting Managed Pipeline Mode set to > Classic, not Integrated. I believe the system I am running requires > the Classic mode. Could this be a problem? > > I couple of other question Steve: > - What ODBC protocol did you use? SQL Server, Native Clients, Native > Clients 10? Should it matter? > - Is Named Pipes required? Or will TCP/IP also work? > - Is your SQL Server 2008 local or remote? > > thank again. > TJ
From: Jeffrey Ingalls on 2 Dec 2009 00:10 Hi TJ, Sorry for the long delay. I spent quite a bit of time investigating this one. I'm happy to report I was able to get ODBC logging to work but made the cardinal sin of working late in the night and making several changes without writing them down before a reboot. I am still troubled by the fact that the same error continues to be generated in the system log when I restart IIS however the entries are coming in to the table. For this test I installed a fresh Windows 2008 R2 and SQL 2008 SP1 on the same server. It did not take me to long to reproduce the system log error. The error was generated immediately after I had ran the appcmd command to set the website to use ODBC logging and recycled IIS. In addition to going through Steve's blog on this topic (Thanks Steve!) there were a few things I checked: * run cliconfg.exe and enable TCP/IP and Named Pipes if not already. Out of the box with a fresh install mine were disabled. * When you configure the System DSN in the ODBC connection, verify your Named Pipes settings are valid. For my test lab scenerio with SQL installed on the same box as IIS the named pipe should be \\.\pipe\sql\query I noticed this was somehow blown away and I had to put this entry back in there. Here is an article on creating a valid connection string using named pipes that I think you will find useful: http://msdn.microsoft.com/en-us/library/ms189307.aspx The last few things I did were to install IIS Advanced Logging (see below for link) and use it to set the standard IIS log file. After setting logging to use standard IIS logging format I recylced IIS then reran the command: appcmd set site "The Name of Your Website Here" -logFile.logFormat:Custom -logFile.customLogPluginClsid:{FF16065B-DE82-11CF-BC0A-00AA006111E0} I browsed the website and looked in the table to find entries. My guess is enabling Named Pipes using cliconfg and getting a valid named pipes connection was the semi-solution to getting it to work for me. I say semi because that error shouldn't be writing to the system log. I will continue to work on this as time permits. I hope these suggestions help get you to semi-solution. :) IIS Advanced Logging: http://www.microsoft.com/downloads/details.aspx?familyid=793051A8-36A0-4342-BDFE-47A6B0E3488F All the best, Jeffrey Ingalls "Thomas J" wrote: > Hi Jeffrey, this sounds promising. Looking forward to your response. > > Hi Steve. Thanks for your follow up Blog post. I tried your > suggestions: > - I changed the App Pool owner to a domain user, added this domain to > the local IIS_IUSRS group, and to SQL Server as a DBO. > Unfortunately this made no difference. I check the SQL Server logs I > have never experiencing the 'Login Failed' issue which you > experienced. I don't understand why the App Pool must run as a domain > user; authentication to SQL Server should be handled by the ODBC > connection. I am relucent to change the App Pool owner in production > as it is currently running with Network Service, and changing this > will require system testing. I noticed one difference with your App > Pool setup; my site has the setting Managed Pipeline Mode set to > Classic, not Integrated. I believe the system I am running requires > the Classic mode. Could this be a problem? > > I couple of other question Steve: > - What ODBC protocol did you use? SQL Server, Native Clients, Native > Clients 10? Should it matter? > - Is Named Pipes required? Or will TCP/IP also work? > - Is your SQL Server 2008 local or remote? > > thank again. > TJ > . >
From: Thomas J on 30 Dec 2009 20:47 Hi Jeff Thank you kindly for your investigation and response. I since solved my usage audit problem by using CRM plugins, and therefore I will not have an opportunity to try your suggestions. Your response is going to be very valuable to the next person who attempts to setup database logging under Win2K8. Thanks again. TJ
First
|
Prev
|
Pages: 1 2 3 Prev: error 500.24 and CS0016 Next: Reinstalling IIS7 on Windows 2008 Standard Server |