Report Pack for IIS

Hi,
I am wondering if I can run the "Microsoft SQL Server Report Pack for
Internet Information Services (IIS)" on a SQL 2005 64 bit.
2nd question, where can I find the script as well as some DTS or jobs to
populate the IISlog DB.
ThanksHello,
Based on my research, Microsoft SQL Server Report Pack for Internet
Information Services (IIS) only support SQL Server 2000.
To confirm that, I tried to tested on my side and I could not install it on
the SQL 2005 server.
As for the second question, I am not sure what you want to do with the
IISLog DB. Would you please try to make it more clear?
Please NOTE: Microsoft SQL Server Report Pack for Internet Information
Services (IIS) is licensed "as-is" It is not supported, and you bear the
risk of using it. Microsoft gives no express warranties, guarantees or
conditions.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi, I found the package for sql 2005 at
"http://www.microsoft.com/downloads/details.aspx?FamilyId=D81722CE-408C-4FB6-A429-2A7ECD62F674&displaylang=en
I managed to make it work, For the second question, I need to know if there
is any process has been devloped to import data from log files to the Database
Thansk
"Wei Lu [MSFT]" wrote:
> Hello,
> Based on my research, Microsoft SQL Server Report Pack for Internet
> Information Services (IIS) only support SQL Server 2000.
> To confirm that, I tried to tested on my side and I could not install it on
> the SQL 2005 server.
> As for the second question, I am not sure what you want to do with the
> IISLog DB. Would you please try to make it more clear?
> Please NOTE: Microsoft SQL Server Report Pack for Internet Information
> Services (IIS) is licensed "as-is" It is not supported, and you bear the
> risk of using it. Microsoft gives no express warranties, guarantees or
> conditions.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>|||Hello
Based on my test, you could the Log Parser which included with the IIS 6.0
Resource Kit to populated with your own IIS Log to your SQL Server.
Internet Information Services (IIS) 6.0 Resource Kit Tools
http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=56fc
92ee-a71a-4c73-b628-ade629c89499
The following example exports data from W3C Extended log files and writes
it to a SQL table:
logparser "Select TO_TIMESTAMP(date, time) as Timestamp,
cs-uri-stem as UriStem, cs-uri-query as UriQuery FROM ex000123.log TO
TestTable"
¨Ci:W3C -o:SQL -server:SERVERSQL
-driver:"SQL Server" -database:LogDB -username:user
-password:xxx
-createtable:ON
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.sql