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

Report Manager on 64 bit machine does not recognize 32 bit data sources

I'm a report developer who has created some reportsd against sybase data on another server. I am developing on a 64 bit Server 2003 box using SQL 2005 Reporting services. I hace created 32 bit ODBC data dsns using the supplied utitlity (odbcad32.exe). As I am creating the reports I can pull data using the data sources without a problem, however when I deploy my datasource and report to Report manager and run I get the following:

An error has occurred during report processing.

Cannot create a connection to data source 'Chicago_Reporting'.

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

This has been driving me crazy for 2 days now. Any help would be very much appreciated.

Thanks

Hi Rick!

I use a 64-bit Windows Server 2003 Enterprise server also and connect to about seven different database types, although Sybase is not one of them. Have you installed SQL Server 2005 Service Pack 2?

|||

HI Chuck,

Thanks for the response. I have limited experience with server admin stuff. I was brought for my reporting experience more then anything else. As far as I can tell our build number is 2005.090.3042.00 which equates to the original version of SP2 on the build list.

Rick

report manager datasources

RS is installed on a 64 bit system. I am pulling my data from Foxpro. I can
get it fine in the report designer, but when deployed to the Report Manager
it wont work....Any ideas or workarounds?Is the datasource shared? If so - are the details correct?
If the data source is custom, does the user running the report have
permission?
"Ben" wrote:
> RS is installed on a 64 bit system. I am pulling my data from Foxpro. I can
> get it fine in the report designer, but when deployed to the Report Manager
> it wont work....Any ideas or workarounds?

report is always one page regardless of how long it is...could somebody help?

Hi anyone,

my problem is a bit simillar with harry but we are making a report and when viewing it, we still see one page even how long the report is, I had viewed the XML code and search fot the property InteractiveHeight but I found out it has 8.5 by 11in on its page height...but still when viewing it has too long one page report

Can anyone help me with this? thanks a lot... we need to cut the report in pages.....God Speed

Hi,

where are you experiencing the long Report. If you mean within the report HTML view, you might have a look on the PDF rendered format. That differs to the HTMl ouput.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||We are experiencing a long report upon generating the report bu cliking the view report button. the report is generaed successfully but still it has only one page even how long the report is...thank you