Has anyone seen report-pack for Reporting Services? Similar to one that is
available for IIS, GPS etc.
Or other option is there any database schema description of the "ReportDB"
for Reporting Services 2005?
--
Thanks in advance - Sunil.The closest thing to a report pack for reporting services is the Report
Execution log reports. The package includes a SSIS package, DB and several
reports.
The reports included will tell you about report execution times, parameters
used, etc, etc
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/RSMnRptExPf.asp
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Sunil K" <SunilK@.discussions.microsoft.com> wrote in message
news:8650684C-FBBD-4D94-A662-CAC937654801@.microsoft.com...
> Has anyone seen report-pack for Reporting Services? Similar to one that is
> available for IIS, GPS etc.
> Or other option is there any database schema description of the "ReportDB"
> for Reporting Services 2005?
> --
> Thanks in advance - Sunil.
>
Showing posts with label iis. Show all posts
Showing posts with label iis. Show all posts
Wednesday, March 28, 2012
report pack for iis - report generation taking long?
I've got this installed and the sample database was working fine. I then
imported about a weeks worth from two iis servers (grew the DB to about 5
GB) and now pulling up any of the default 12 reports takes at least 30
minutes to an hour or longer. Is this normal? The SQL server is a dual
xeon, 2 GB of RAM, 3 disk (15k rpm) raid 5 with SQL 2000 SP3 and Reporting
Services SP2.Try to do a select of the same data and see how long it takes...RS will be
slower than that of course - but will not be faster than your select when it
queries the data..
Ensure you have properly indexed tables.
You may also wish to run the query on a schedule and deliver it from cache -
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Joe" <joe@.do.not.email.me> wrote in message
news:%23%234FpU4qFHA.248@.TK2MSFTNGP14.phx.gbl...
> I've got this installed and the sample database was working fine. I then
> imported about a weeks worth from two iis servers (grew the DB to about 5
> GB) and now pulling up any of the default 12 reports takes at least 30
> minutes to an hour or longer. Is this normal? The SQL server is a dual
> xeon, 2 GB of RAM, 3 disk (15k rpm) raid 5 with SQL 2000 SP3 and Reporting
> Services SP2.
>
imported about a weeks worth from two iis servers (grew the DB to about 5
GB) and now pulling up any of the default 12 reports takes at least 30
minutes to an hour or longer. Is this normal? The SQL server is a dual
xeon, 2 GB of RAM, 3 disk (15k rpm) raid 5 with SQL 2000 SP3 and Reporting
Services SP2.Try to do a select of the same data and see how long it takes...RS will be
slower than that of course - but will not be faster than your select when it
queries the data..
Ensure you have properly indexed tables.
You may also wish to run the query on a schedule and deliver it from cache -
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Joe" <joe@.do.not.email.me> wrote in message
news:%23%234FpU4qFHA.248@.TK2MSFTNGP14.phx.gbl...
> I've got this installed and the sample database was working fine. I then
> imported about a weeks worth from two iis servers (grew the DB to about 5
> GB) and now pulling up any of the default 12 reports takes at least 30
> minutes to an hour or longer. Is this normal? The SQL server is a dual
> xeon, 2 GB of RAM, 3 disk (15k rpm) raid 5 with SQL 2000 SP3 and Reporting
> Services SP2.
>
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
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
Tuesday, March 20, 2012
Report Manager Start Up
I believe that I read somewhere in the past that there was a setting in IIS
that you could change in order to have the Report Manager not recompile on
first request. As we all know it takes an unusually long time for Report
Manager to start up the first time you call the application. I would like to
know if there is a setting or change that I can make in order to have Report
Manager Load faster.
Thanks,
--
Andrew
MCSA,MCDBAHi,
I believe the setting you are looking for is the "Shutdown worker processes
after being idle for..." on the Performance tab of the application pool that
the Reports virtual directory is assigned to.
See old post below for details:
>>>>>>>>>>
If you are running Windows 2003 server for your IIS reportserver, then this
is a simple issue - I'll explain what happens:
The report service engine, once it is idle for more than the default 20
minutes, the worker process is shutdown.
This is controlled by IIS.
Open up the Internet Information Services (IIS) Manager
Expand the server node then the application pools.
On my IIS machine, I created an application pool dedicated to the
reportserver & reportmanager virtual webs.
But anyways, for the application pool that the reportserver is pointing to
if you left everything to their defaults will be the DefaultAppPool.
Right click the default app pool and select properties.
There are two things that are checked by default - On the recycling tab
there is a checkbox for recycling worker processes - it is currently set to
1740 minutes (29 hours). Leave it.
The other one is on the performance tab - which is the one you are
interested in changing...
See the "Idle Timeout" section and increase the number of minutes to be 8
hours a typical working day - 8*60 = 480 minutes.
Next, to be sure the "morning person" that runs the first report doesn't get
the delay, set up a schedule for either a dummy or adhoc report to fire off
like at 6am so that the report component worker processes get loaded.
I hope this helps you.
There is no need to have a report fire off every minute to keep things
alive - it is just that the report service was "unloaded" and needed to load
back up.
=-Chris
>>>>>>>>>>
"Andrew" wrote:
> I believe that I read somewhere in the past that there was a setting in IIS
> that you could change in order to have the Report Manager not recompile on
> first request. As we all know it takes an unusually long time for Report
> Manager to start up the first time you call the application. I would like to
> know if there is a setting or change that I can make in order to have Report
> Manager Load faster.
> Thanks,
> --
> Andrew
> MCSA,MCDBA|||Chris,
Thanks, that is exactly what I was looking for.
--
Andrew
MCSA,MCDBA
"Oweste" wrote:
> Hi,
> I believe the setting you are looking for is the "Shutdown worker processes
> after being idle for..." on the Performance tab of the application pool that
> the Reports virtual directory is assigned to.
> See old post below for details:
> >>>>>>>>>>
> If you are running Windows 2003 server for your IIS reportserver, then this
> is a simple issue - I'll explain what happens:
> The report service engine, once it is idle for more than the default 20
> minutes, the worker process is shutdown.
> This is controlled by IIS.
> Open up the Internet Information Services (IIS) Manager
> Expand the server node then the application pools.
> On my IIS machine, I created an application pool dedicated to the
> reportserver & reportmanager virtual webs.
> But anyways, for the application pool that the reportserver is pointing to
> if you left everything to their defaults will be the DefaultAppPool.
> Right click the default app pool and select properties.
> There are two things that are checked by default - On the recycling tab
> there is a checkbox for recycling worker processes - it is currently set to
> 1740 minutes (29 hours). Leave it.
> The other one is on the performance tab - which is the one you are
> interested in changing...
> See the "Idle Timeout" section and increase the number of minutes to be 8
> hours a typical working day - 8*60 = 480 minutes.
> Next, to be sure the "morning person" that runs the first report doesn't get
> the delay, set up a schedule for either a dummy or adhoc report to fire off
> like at 6am so that the report component worker processes get loaded.
> I hope this helps you.
> There is no need to have a report fire off every minute to keep things
> alive - it is just that the report service was "unloaded" and needed to load
> back up.
> =-Chris
> >>>>>>>>>>
>
> "Andrew" wrote:
> > I believe that I read somewhere in the past that there was a setting in IIS
> > that you could change in order to have the Report Manager not recompile on
> > first request. As we all know it takes an unusually long time for Report
> > Manager to start up the first time you call the application. I would like to
> > know if there is a setting or change that I can make in order to have Report
> > Manager Load faster.
> >
> > Thanks,
> >
> > --
> > Andrew
> > MCSA,MCDBA
that you could change in order to have the Report Manager not recompile on
first request. As we all know it takes an unusually long time for Report
Manager to start up the first time you call the application. I would like to
know if there is a setting or change that I can make in order to have Report
Manager Load faster.
Thanks,
--
Andrew
MCSA,MCDBAHi,
I believe the setting you are looking for is the "Shutdown worker processes
after being idle for..." on the Performance tab of the application pool that
the Reports virtual directory is assigned to.
See old post below for details:
>>>>>>>>>>
If you are running Windows 2003 server for your IIS reportserver, then this
is a simple issue - I'll explain what happens:
The report service engine, once it is idle for more than the default 20
minutes, the worker process is shutdown.
This is controlled by IIS.
Open up the Internet Information Services (IIS) Manager
Expand the server node then the application pools.
On my IIS machine, I created an application pool dedicated to the
reportserver & reportmanager virtual webs.
But anyways, for the application pool that the reportserver is pointing to
if you left everything to their defaults will be the DefaultAppPool.
Right click the default app pool and select properties.
There are two things that are checked by default - On the recycling tab
there is a checkbox for recycling worker processes - it is currently set to
1740 minutes (29 hours). Leave it.
The other one is on the performance tab - which is the one you are
interested in changing...
See the "Idle Timeout" section and increase the number of minutes to be 8
hours a typical working day - 8*60 = 480 minutes.
Next, to be sure the "morning person" that runs the first report doesn't get
the delay, set up a schedule for either a dummy or adhoc report to fire off
like at 6am so that the report component worker processes get loaded.
I hope this helps you.
There is no need to have a report fire off every minute to keep things
alive - it is just that the report service was "unloaded" and needed to load
back up.
=-Chris
>>>>>>>>>>
"Andrew" wrote:
> I believe that I read somewhere in the past that there was a setting in IIS
> that you could change in order to have the Report Manager not recompile on
> first request. As we all know it takes an unusually long time for Report
> Manager to start up the first time you call the application. I would like to
> know if there is a setting or change that I can make in order to have Report
> Manager Load faster.
> Thanks,
> --
> Andrew
> MCSA,MCDBA|||Chris,
Thanks, that is exactly what I was looking for.
--
Andrew
MCSA,MCDBA
"Oweste" wrote:
> Hi,
> I believe the setting you are looking for is the "Shutdown worker processes
> after being idle for..." on the Performance tab of the application pool that
> the Reports virtual directory is assigned to.
> See old post below for details:
> >>>>>>>>>>
> If you are running Windows 2003 server for your IIS reportserver, then this
> is a simple issue - I'll explain what happens:
> The report service engine, once it is idle for more than the default 20
> minutes, the worker process is shutdown.
> This is controlled by IIS.
> Open up the Internet Information Services (IIS) Manager
> Expand the server node then the application pools.
> On my IIS machine, I created an application pool dedicated to the
> reportserver & reportmanager virtual webs.
> But anyways, for the application pool that the reportserver is pointing to
> if you left everything to their defaults will be the DefaultAppPool.
> Right click the default app pool and select properties.
> There are two things that are checked by default - On the recycling tab
> there is a checkbox for recycling worker processes - it is currently set to
> 1740 minutes (29 hours). Leave it.
> The other one is on the performance tab - which is the one you are
> interested in changing...
> See the "Idle Timeout" section and increase the number of minutes to be 8
> hours a typical working day - 8*60 = 480 minutes.
> Next, to be sure the "morning person" that runs the first report doesn't get
> the delay, set up a schedule for either a dummy or adhoc report to fire off
> like at 6am so that the report component worker processes get loaded.
> I hope this helps you.
> There is no need to have a report fire off every minute to keep things
> alive - it is just that the report service was "unloaded" and needed to load
> back up.
> =-Chris
> >>>>>>>>>>
>
> "Andrew" wrote:
> > I believe that I read somewhere in the past that there was a setting in IIS
> > that you could change in order to have the Report Manager not recompile on
> > first request. As we all know it takes an unusually long time for Report
> > Manager to start up the first time you call the application. I would like to
> > know if there is a setting or change that I can make in order to have Report
> > Manager Load faster.
> >
> > Thanks,
> >
> > --
> > Andrew
> > MCSA,MCDBA
Monday, March 12, 2012
Report Manager http/https - mixed links
Hi,
I have setup reportserver with default settings (non https) and afterwards in IIS added a certificate and https support.
Know I am able to work really well and secure over the internet, but some links in report manager pointing to http://server.domain.com/reports instead of https:
For example if i call a report and then in the top there are (view, properties,...)
- View is HTTPS
- Properties is HTTPS
- History is HTTP
- Subscription is HTTP
I have setup reportserver with default settings (non https) and afterwards in IIS added a certificate and https support.
Know I am able to work really well and secure over the internet, but some links in report manager pointing to http://server.domain.com/reports instead of https:
For example if i call a report and then in the top there are (view, properties,...)
- View is HTTPS
- Properties is HTTPS
- History is HTTP
- Subscription is HTTP
I have read some articles - mentions I should configure https, but
- in Report Configuration you could not setup HTTPS
- in rsreportserver.config i have entered the https link version but did not change anything
- in RSWebApplication.config the Reportserverurltag is blank - so i did not change anything
Thanks for any help
HANNESCan you check to make sure that in the RSReportServer.config file the SecureConnectionLevel is set to 3?|||after this switch i received an error - SSL/TSL trust relationship could not be established, but then i entered the full qualified certifcate name in report server configuration and now its working fine
may thanks
HANNES|||
You noted you entered the fully qualifed certificate name in the report server configuration and it is working....where exactly did you enter this information in the report server configuration? Are you speaking of the 'Report Server Configuration' application, or some other config file that affects the report server configuration?
Thanks
|||hmayer wrote:
after this switch i received an error - SSL/TSL trust relationship could not be established, but then i entered the full qualified certifcate name in report server configuration and now its working fine may thanks
HANNES
As far as I remember I have modified the RSWebApplication.config config file in the reportmanager directory of report server.
I have modified the ReportServerUrl tag to something like this <ReportServerUrl>https://fullqualifiedhostname/ReportServer</ReportServerUrl> (matching the certificate name.
LG, HANNES
Report Manager http/https - mixed links
Hi,
I have setup reportserver with default settings (non https) and afterwards in IIS added a certificate and https support.
Know I am able to work really well and secure over the internet, but some links in report manager pointing to http://server.domain.com/reports instead of https:
For example if i call a report and then in the top there are (view, properties,...)
- View is HTTPS
- Properties is HTTPS
- History is HTTP
- Subscription is HTTP
I have setup reportserver with default settings (non https) and afterwards in IIS added a certificate and https support.
Know I am able to work really well and secure over the internet, but some links in report manager pointing to http://server.domain.com/reports instead of https:
For example if i call a report and then in the top there are (view, properties,...)
- View is HTTPS
- Properties is HTTPS
- History is HTTP
- Subscription is HTTP
I have read some articles - mentions I should configure https, but
- in Report Configuration you could not setup HTTPS
- in rsreportserver.config i have entered the https link version but did not change anything
- in RSWebApplication.config the Reportserverurltag is blank - so i did not change anything
Thanks for any help
HANNESCan you check to make sure that in the RSReportServer.config file the SecureConnectionLevel is set to 3?|||after this switch i received an error - SSL/TSL trust relationship could not be established, but then i entered the full qualified certifcate name in report server configuration and now its working fine
may thanks
HANNES|||
You noted you entered the fully qualifed certificate name in the report server configuration and it is working....where exactly did you enter this information in the report server configuration? Are you speaking of the 'Report Server Configuration' application, or some other config file that affects the report server configuration?
Thanks
|||after this switch i received an error - SSL/TSL trust relationship could not be established, but then i entered the full qualified certifcate name in report server configuration and now its working fine may thanks
HANNES
As far as I remember I have modified the RSWebApplication.config config file in the reportmanager directory of report server.
I have modified the ReportServerUrl tag to something like this <ReportServerUrl>https://fullqualifiedhostname/ReportServer</ReportServerUrl> (matching the certificate name.
LG, HANNES
Report Manager http/https - mixed links
Hi,
I have setup reportserver with default settings (non https) and afterwards in IIS added a certificate and https support.
Know I am able to work really well and secure over the internet, but some links in report manager pointing to http://server.domain.com/reports instead of https:
For example if i call a report and then in the top there are (view, properties,...)
- View is HTTPS
- Properties is HTTPS
- History is HTTP
- Subscription is HTTP
I have setup reportserver with default settings (non https) and afterwards in IIS added a certificate and https support.
Know I am able to work really well and secure over the internet, but some links in report manager pointing to http://server.domain.com/reports instead of https:
For example if i call a report and then in the top there are (view, properties,...)
- View is HTTPS
- Properties is HTTPS
- History is HTTP
- Subscription is HTTP
I have read some articles - mentions I should configure https, but
- in Report Configuration you could not setup HTTPS
- in rsreportserver.config i have entered the https link version but did not change anything
- in RSWebApplication.config the Reportserverurltag is blank - so i did not change anything
Thanks for any help
HANNESCan you check to make sure that in the RSReportServer.config file the SecureConnectionLevel is set to 3?|||after this switch i received an error - SSL/TSL trust relationship could not be established, but then i entered the full qualified certifcate name in report server configuration and now its working fine
may thanks
HANNES|||
You noted you entered the fully qualifed certificate name in the report server configuration and it is working....where exactly did you enter this information in the report server configuration? Are you speaking of the 'Report Server Configuration' application, or some other config file that affects the report server configuration?
Thanks
|||after this switch i received an error - SSL/TSL trust relationship could not be established, but then i entered the full qualified certifcate name in report server configuration and now its working fine may thanks
HANNES
As far as I remember I have modified the RSWebApplication.config config file in the reportmanager directory of report server.
I have modified the ReportServerUrl tag to something like this <ReportServerUrl>https://fullqualifiedhostname/ReportServer</ReportServerUrl> (matching the certificate name.
LG, HANNES
Report manager home page erroring with an invalid character.
I have a 2003 server with IIS 6.0, SQL Server 2005, Analysis Services 2005,
and Reporting Services 2005 installed. I can create new reports and publish
them. If I go to //localhost/reportserver I can get to the reports and they
will come up. However, if I go to //localhost/Reports I get a message
stating that the XML page cannot be displayed.
A name was started with an invalid character. Error processing resource
'http://localhost/Reports/home.aspx' Line 1, Posi...
<%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false"
Inherits="Microsoft.ReportingServices.UI.HomePag...
I tried uninstalling and re-installing reporting services but I get the same
error. Any thoughts?Luke,
All you have to do is open the IIS MMC and then right click the
"reports" virtual directory, select property and then under the
ASP.NET tab select asp.net version that belongs to the .NET framework
version 2. For some reason, after you installed reporting services,
the version of the ASP.NET was removed from the asp.net tab.
Dave Luna.
Luke wrote:
> I have a 2003 server with IIS 6.0, SQL Server 2005, Analysis Services 2005,
> and Reporting Services 2005 installed. I can create new reports and publish
> them. If I go to //localhost/reportserver I can get to the reports and they
> will come up. However, if I go to //localhost/Reports I get a message
> stating that the XML page cannot be displayed.
> A name was started with an invalid character. Error processing resource
> 'http://localhost/Reports/home.aspx' Line 1, Posi...
> <%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false"
> Inherits="Microsoft.ReportingServices.UI.HomePag...
> I tried uninstalling and re-installing reporting services but I get the same
> error. Any thoughts?
and Reporting Services 2005 installed. I can create new reports and publish
them. If I go to //localhost/reportserver I can get to the reports and they
will come up. However, if I go to //localhost/Reports I get a message
stating that the XML page cannot be displayed.
A name was started with an invalid character. Error processing resource
'http://localhost/Reports/home.aspx' Line 1, Posi...
<%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false"
Inherits="Microsoft.ReportingServices.UI.HomePag...
I tried uninstalling and re-installing reporting services but I get the same
error. Any thoughts?Luke,
All you have to do is open the IIS MMC and then right click the
"reports" virtual directory, select property and then under the
ASP.NET tab select asp.net version that belongs to the .NET framework
version 2. For some reason, after you installed reporting services,
the version of the ASP.NET was removed from the asp.net tab.
Dave Luna.
Luke wrote:
> I have a 2003 server with IIS 6.0, SQL Server 2005, Analysis Services 2005,
> and Reporting Services 2005 installed. I can create new reports and publish
> them. If I go to //localhost/reportserver I can get to the reports and they
> will come up. However, if I go to //localhost/Reports I get a message
> stating that the XML page cannot be displayed.
> A name was started with an invalid character. Error processing resource
> 'http://localhost/Reports/home.aspx' Line 1, Posi...
> <%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false"
> Inherits="Microsoft.ReportingServices.UI.HomePag...
> I tried uninstalling and re-installing reporting services but I get the same
> error. Any thoughts?
Subscribe to:
Posts (Atom)