Hello, I am literally struggling to enable IIS ODBC Logging in BPC. Recently we have some mandate to capture users last log on time. I went over the install doc and also various other sites to get some info.

Below are the steps that I followed and I still don't see the log info.

1. Server Manage à Role Services
   1. Logging Tools, Custom Logging, ODBC Logging
      ** All of these are installed
2. Created a SQL ID in Appserver database with Read/Write in the BPClog table
3. Created a ODBC Connection:

Go to start-->Run->%WINDIR%\SysWOW64\odbcad32.exe
Create a systemDSN --> BPC_ManagementDSN (Sql Server Driver)

Connect to Sql Server --> abcdef

Sql Server authentication

LoginID –bpc

Pwd – abc

1. Took a back up of
   1. PC_MS\Websrvr\Web\
      Save a COPY of Original“Web.Config” file.

C:\Windows\System32\inetsrv\config\

Save a COPY of Original “applicationHost.Config” file

6 Ran this command from the Command Prompt (ran it as Admin )

appcmd set site /site.name:"Default Web Site" /logFile.customLogPluginClsid:"{FF16065B-DE82-11CF-BC0A-00AA006111E0}"

appcmd set site /site.name:"Default Web Site" /logFile.logFormat:"Custom"

appcmd set config "Default Web Site" /section:odbcLogging /dataSource:"BPC_ManagementDSN" /commit:appHost

appcmd set config "Default Web Site" /section:odbcLogging /tableName:"BPCLog" /commit:appHost

appcmd set config "Default Web Site" /section:odbcLogging /userName:"bpc" /commit:appHost

appcmd set config "Default Web Site" /section:odbcLogging /password:"abc" /commit:appHost

Once this is all done,

Restarted - Send Governer
Restarted – Com+ Services related to BPC e.g k2Processing, Evxxx etc
Reset – IIS
Rebooted Windows Server

*** Still the BPCLog table is not populated**** What could be the REASON Experts ?

WHAT AM I MISSING ? Please send some suggestions...