ReportBuilder & FQDN

Anyone run into this?

ReportBuilder fails to load when using a FQDN (fully qualified domain name) URL.
ie: http://servername.xyz.company.com/Reports/Pages/Folder.aspx

ReportBuilder loads with no issue when using the shortname URL.
ie: http://servername/Reports/Pages/Folder.aspx

details:

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://servername.xyz.company.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://servername.xyz.company.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (403) Forbidden.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

Nevermind Figured it out -

Modify RSWebApplication.config for Hard IP.

<ReportServerUrl>http://<Site IP Address>/ReportServer</ReportServerURL>

<ReportServerVirtualDirectory></ReportServerVirtualDirectory>

Works - just recycle the application pools in IIS. By the way if you are configuring the manager for a non-default IP address be carefull. For some reason the report manager does not like a <ReportServerVirtualDirectory> value if <ReportServerURL> is supplied.

Report Viewer Toolbar Style messed up

Hi All,
When I run a report from Report Manager or from a URL using the ReportViewer
the toolbar looses all styling - it runs down over several lines. I am using
RS 2005 and have also got a RS2000 set-up where we don't have this problem. I
have tried to put in the reference to the stylesheet in the URL access but it
hasn't done anything. Anyone know what the problem could be here? Everything
else in RS2005 works fine.
I also have a problem with Dundas Charts. When accessing the reports via a
URL the charts display if I put in &rc:Toolbar=True but if I put
&rc:Toolbar=False then the Charts don't display and I get a box with a red
cross in it. On the report there are also some tables of data and these
display in both cases.
Any answers to the above much appreciated!
Thanks
RichardHi Richard -
Did you ever get this sorted out? I'm having the same problem, too. I do
have a feeling this is a Win2K3 issue, but just want to guidance as to what
it could be.
Microsoft dudes -- any ideas here?
Thanks,
Brent
"Richard" wrote:
> Hi All,
> When I run a report from Report Manager or from a URL using the ReportViewer
> the toolbar looses all styling - it runs down over several lines. I am using
> RS 2005 and have also got a RS2000 set-up where we don't have this problem. I
> have tried to put in the reference to the stylesheet in the URL access but it
> hasn't done anything. Anyone know what the problem could be here? Everything
> else in RS2005 works fine.
> I also have a problem with Dundas Charts. When accessing the reports via a
> URL the charts display if I put in &rc:Toolbar=True but if I put
> &rc:Toolbar=False then the Charts don't display and I get a box with a red
> cross in it. On the report there are also some tables of data and these
> display in both cases.
> Any answers to the above much appreciated!
> Thanks
> Richardsql

Report Viewer through SOAP webservices

Hi everyone,
I want to use report viewer throught SOAP webservices. How to do this?
I dont want to use the URL access. I want to use reportviewer control and
the report to be access through the webservice.
Advance thanks for help.
regards,
J.SingaraveluSetup Instructions for ReportViewer
Before you can run and examine the code for the ReportViewer sample ASP.NET
server control, several components and tools must be installed.
After you follow the instructions for installation and configuration of the
items listed in the prerequisites section, you can view the sample by using
Visual Studio .NET.
Important Sample applications should not be connected to or used with
your production SQL Server database or your report server without the
permission of the system administrator.
Prerequisites
In addition to being familiar with Visual Studio .NET and either C# or
Visual Basic, to use ReportViewer you must install or verify the
installation of the following items on your development system:
a.. Microsoft Visual Studio .NET 2003.
b.. Microsoft .NET Framework version v1.1.4322.
c.. The Reporting Services samples. You can choose to install the samples
during Reporting Services setup. To install the samples, select
Documentation and Samples on the component feature tree during setup. For
more information, see Selecting Components of Reporting Services to Install.
d.. A report server that you have permission to access on your network, if
you plan to use the sample server control to view reports on a Web Forms
page.
Note ReportViewer may be converted to compile and run in previous
versions of Visual Studio .NET. However, it is designed specifically to be
compatible with the version mentioned in this section.
Install Location
After the prerequisite components and tools are installed, you can begin
using ReportViewer. By default, the ReportViewer server control is installed
to C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\Samples\Applications\ReportViewer. To begin using the sample, open
the ReportViewer sample application solution file, ReportViewer.sln, using
Visual Studio .NET. For more information, see Using the ReportViewer Server
Control.
extracted from reporting services books online
"singaravelu" <singaravelu@.discussions.microsoft.com> wrote in message
news:CB4ACB94-FA43-4016-81D1-2C7349B22FA9@.microsoft.com...
> Hi everyone,
> I want to use report viewer throught SOAP webservices. How to do
> this?
> I dont want to use the URL access. I want to use reportviewer control and
> the report to be access through the webservice.
>
> Advance thanks for help.
> regards,
> J.Singaravelu
>
begin 666 important.gif
M1TE&.#EA# `+`(#_`,P``,# P"'Y! $```$`+ `````,``L`0 (7C(\9`&H,
3X8F43>E>2]CRZFF1$V9E4 ``.P``
`
end
begin 666 note.gif
M1TE&.#EA# `+`(#_`(2&`,# P"'Y! $```$`+ `````,``L`0 (:C(\(H'S[
68%R0&ED;M7,'[%S2YW#1)VJ;4P``.P``
`
end

Report Viewer Jump to URL error after drilldown

Hello,

I'm using an ASPX page + ReportViewer + remote report with drilldown and Jump to Url (target _blank) in IE 6.

The ReportViewer's property AsyncRendering is set to true.

After drilldown, if i click on the text with the navigation action "Jump to Url", i have this error message in IE : Javascript Error : can't execute code from a freed script.

The jump to URL "works", but not in a "blank" page (in the same page of the ReportViewer).

If the the ReportViewer's property AsyncRendering is set to false, "Jump to Url" works fine (in a new IE page). But my report is very large, and i need the AsyncRendering set to true.

The only solution i found is to use IFrame with direct URL access to ReportServer, instead of ReportViewer.

I would prefer to use ReportViewer, so if someone as an idea of this problem, many thanks for is help !

Thanks,

Frederic

I am having the same error that Frederic is having. not only that my web page is loading within the report viewer I am getting the same script error. When I set AsyncRendering =false, the script error goes away and web page loads correctly( in the same browser); however, my report is centered in the report viewer and I have to scroll to the right to see it. Everytime I expland or collapse the focus changes and I can't see the report unless I scroll to the right(that's annoying)

I am working with local reports since the data for my report come from class objects. I am not publishing my reports to the report server. Is there a way to accomplish this with Frames without the report viewer? If so please let me know. I have been having this problem for 2 weeks now and I am not finding any resolution for it.

I will appreciate any help I coul get with this.

Thanks in advance,

Mini

|||

Frederic,

Can you tell me how you got it to work with IFrame. I cant't get it to open an external link.

thanks

Mini

|||

Hi Mini,

I'm using a Report Server, not a local report, that's why instead of using ReportViewer i can use an IFrame with an URL to my ReportServer.

In the ASPX page i have declared :

<iframeid="frameRS"runat="server"src="http://localhost/ReportServer?/ReportFolder/Report1&rs:Command=Render&rc:LinkTarget=blank"width="100%"height="100%"></iframe>

In this exemple, the Report Server is local (localhost/ReportServer).

It's possible to change the value of the src property (C# exemple in the .aspx.cs file) :

protected

void Page_Load(object sender,EventArgs e)

{

this.frameRS.Attributes["src"] ="http://localhost/ReportServer?/ReportFolder/Report2&rs:Command=Render&rc:LinkTarget=blank";

}

Unfortunately, i'm not sure that you can use this solution with a local report.

Bests regards,

Frederic

|||

I managed to get my report loaded into the Frame and executed the hyperlink. However I am encountered with a new problem

My report is pretty wide and the report is not showing all of it to the right. I know my frame width is 100% thus I am not getting the scrollbar but some how part of the report on the right is missing. I am thinking it is not being returned from the report server. Howerver if I directly go to the server and run it, I see it all

Any idea what is going on

Thanks

Mini

|||

Hi Mini,

Did you manage with the example i sent you last week ?

Best regards,

Frederic

report viewer embedded in a frame

I have a report viewer control embedded in a frame. The problem is with the jump to url property of the report. I want to use javascript to pop up a new window and display the desired content. However, this is not working - I can only assume due to the frame the report viewer is embedded in - any thoughts? Thanks.I solved this months back now. The control was in a html table too, which a removed. After that, the control worked fine. Cheers!

report via url with parameters: strange issue....

Hi all,

I'm testing my report via a url, with report parameters.
But i have a strange issue:

If I open a new browser, and I do:
"http://localhost/reportserver?/r1/Report_R1&rs:Command=Render&rc:Toolbar=False" (thus without parameters)
Then it takes the default values that are configured in the report.
This returns 3 records, which is OK

If I open a new browser, and I do:
"http://localhost/reportserver?/r1/Report_R1&rs:Command=Render&rc:Toolbar=False&STAmonth=6"
This returns 5 records, which is OK

If I open a new browser, and I do:
"http://localhost/reportserver?/r1/Report_R1&rs:Command=Render&rc:Toolbar=False&STAmonth=5"
This returns 0 records, which is OK

BUT HERE COMES THE STRANGE THING:
If i try to go to two url's after eachother in the same browser, it gives bad result....
thus:
"http://localhost/reportserver?/r1/Report_R1&rs:Command=Render&rc:Toolbar=False&STAmonth=5"
this returns 0 records, this is OK
but if I do hereafter (in the same browser)
"http://localhost/reportserver?/r1/Report_R1&rs:Command=Render&rc:Toolbar=False" (thus without parameters)
it still returns 0 records, while it should return 3 records.

Anyone experienced this also?
What can I do or what am I doing wrong?

Thanks

Hi sttke,

This looks to be a by-product of keeping the session open and caching information. You can add rs:ClearSession=true to the url and it should clear the parameters.

|||that does the job !!!
thanks a lot, Brad !!!

report to url

I have a question to ask:
I type
"http://reportserverurl/pages/reports.aspx?ItemPath=%2ftargetfolder%2ftestreport"
in jump to url box, it will go to open a report named testreport in my report
server. It is good. I want to rename the testreport to a variable name.
If I change testreport to Field!ReportName.Value in stead, then it does
not work, how do you make the Field!ReportName.Value to convert to
testreport. I have other reports in the report server="http://reportserverurl/pages/reports.aspx?ItemPath=%2ftargetfolder%2f" &
Feild!ReportName.Value
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Henry Chen" <HenryChen@.discussions.microsoft.com> wrote in message
news:85B76250-BB7F-4C78-96CB-2BB5B0C7804F@.microsoft.com...
>I have a question to ask:
> I type
> "http://reportserverurl/pages/reports.aspx?ItemPath=%2ftargetfolder%2ftestreport"
> in jump to url box, it will go to open a report named testreport in my
> report
> server. It is good. I want to rename the testreport to a variable name.
> If I change testreport to Field!ReportName.Value in stead, then it does
> not work, how do you make the Field!ReportName.Value to convert to
> testreport. I have other reports in the report server

Report to Report Navigation problem

when I use "Navigation, Jump to URL" feature to navigate from one report to another, the .Net report service always alto generate the html code as: "TARGET="_top" which navigete the current frame page to the parent page. How can I make it generate the code like "TARGET="_self"? Because I display the report in a frame, and don't want let the report jump out of the frame when I click on the hyperlink.
Anybody can help? thanks.

This post is just below, they too talk about how to get the report to render in a certiain frame, as well as some discussion on the rc:LinkTarget Parameter that can help you out in pointing to the right place, or just google rc:LinkTarget and you will get some bolgs and stuff where they discuss this,...
I know for sure rc:LinkTarget can take therse arguments out of the box

rc:LinkTarget=_blank
rc:LinkTarget=_parent
rc:LinkTarget=_search
rc:LinkTarget=_self
rc:LinkTarget=_top



http://forums.asp.net/971389/ShowPost.aspx

report table with links

How do you add a URL to the table? For example:

Post column
=Fields!PostID.Value

URL column
="<a href = ""http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=" & Fields!PostID.Value & """>" & Fields!PostID.Value & "</a"

Check out the JumpToUrl property of your textbox (on the Navigation tab), and set it to something like this:

=void(window.open('http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=" & Fields!PostID.Value & "','_blank'))"

Report Server URL vs Report Manager URL

What is the difference between Report Server URL and Report Manager URL?
What does the URL's look like when displayed?
Thank you.http://<servername>/reports is basically Report Manager URL
http://<servername>/reportserver is for report server URL, where you deploy.
Is this you had asked for ? let me know if not.
Amarnath, MCTS
"Terry" wrote:
> What is the difference between Report Server URL and Report Manager URL?
> What does the URL's look like when displayed?
> Thank you.|||Thank you very much for your speedy response and assistance.
However, where can I find technical documents using filters with reports in
CRM?
"Amarnath" wrote:
> http://<servername>/reports is basically Report Manager URL
> http://<servername>/reportserver is for report server URL, where you deploy.
> Is this you had asked for ? let me know if not.
> Amarnath, MCTS
> "Terry" wrote:
> > What is the difference between Report Server URL and Report Manager URL?
> >
> > What does the URL's look like when displayed?
> >
> > Thank you.|||Not sure what you are wanting but if what you want to do is to create a URL
that passes the appropriate parameters to a report then what you want is URL
Access (Search on URL phrase in Books Online).
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsprg9/html/52c3f2a3-3d6d-4fee-9c46-83f366919398.htm
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Terry" <Terry@.discussions.microsoft.com> wrote in message
news:97149427-8A5F-47AA-8BDF-5595419C9863@.microsoft.com...
> Thank you very much for your speedy response and assistance.
> However, where can I find technical documents using filters with reports
> in
> CRM?
> "Amarnath" wrote:
>> http://<servername>/reports is basically Report Manager URL
>> http://<servername>/reportserver is for report server URL, where you
>> deploy.
>> Is this you had asked for ? let me know if not.
>> Amarnath, MCTS
>> "Terry" wrote:
>> > What is the difference between Report Server URL and Report Manager
>> > URL?
>> >
>> > What does the URL's look like when displayed?
>> >
>> > Thank you.

Report Server renders incorrect URL for [Export] button

Good day,
We have a Report Server 2000 on a client site. The server is accessible
via server name (NetBIOS name) from the local LAN, but only via a DNS name
from outer regions of the WAN (these users are on a different but trusted
domain in the bigger forest). The reports render successfully when accessed
via either the NetBIOS or DNS name, but the URL rendered for the â'Exportâ'
functionality always refers to the NetBIOS (server) name. As a result users
on the WAN cannot use the â'Exportâ' functionality since the URL is not found
from that network location (without us adding a local host entry which is
against company policy).
The page source shows a number of variables, including dmRepUrl,
touchSessionUrl, printUrl, renderingUrl, exportUrl and docMapUrl â' these are
all incorrectly mapping to the server name.
I cannot find any matching entry in the Report Server configuration and it
seems as-if this code is output by a compiled assembly on the Report Server.
Are these URLs configurable at all?
Thank you,
James Avenant
GijimaAst ConsultantHi James,
Thank you for your posting!
From your description, my understanding of this issue is: You want to
deploy your report server on a WAN environment. If I misunderstood your
concern, please feel free to let me know.
Based on my experience, you need to specify a fully qualified domain name
instead of the Netbios name in the config file.
The first step is to change the following two registry values under this
key to the appropriate new values:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Reporting
Services\
RSVirtualDir = http://server.company.com/ReportServer (Old Value was
http://server/ReportServer)
WAVirtualDir = http://server.company.com/Reports (Old Value was
http://server/Reports)
The final piece is to make a change in the following to config files on
your reporting server:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config
Each file will contain one instance of the server referenced by name
(http://server/ReportServer). Replace it with the fully qualified domain
name, keeping the trailing directory
(http://server.company.com/ReportServer)
Now just restart the service and you should be able to access the reports
inside or out using a fully qualified domain name.
Hope this will be helpful!
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.

Report Server is not responding for XP2 sp2 and SQL Server 05 Dev

I am encountering this issue when I try and go to the Report Server url
http://localhost/reports
I get the message:
"The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version."
I get the same message when I used the computer name insteaed of localhost
The Reports Virtual Directory and the Report Server virtual directory are
installed under the default web site
--
adamHello Adam,
Thank you for using Microsoft MSDN newsgroup!
From your description, I understand that you installed SRS 2005 on WinXP
SP2 machine, but you received the following error message when accessing
http://localhost/reports. If I'm off-base, please let me know.
"The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version."
Based on my experience, you may want to temporarily remove the following
entry from C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportManager\RSWebApplication.config file:
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>.
Also, please make sure the following entry is listed in above file:
<ReportServerUrl>http://localhost/reportserver</ReportServerUrl>
Note: Please back up above file before you do any modification.
If the issue persists, please go to following URL and let me know the
result.
http://localhost/reportserver
Do you configure SSL for the reportserver/reports virtual directories?
If you have any update or questions, please feel free to let's know. I look
forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
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 peter,
Thx for your reply â' Iâ'm afraid that didnâ't work.
Here is the RSWebApplication.config after the edits you suggested. The
Report Server VD line I commented out rather than removed.
<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerUrl>http://localhost/reportserver</ReportServerUrl
<!--<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>-->
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
<Extensions>
<DeliveryUI>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">
<DefaultDeliveryExtension>True</DefaultDeliveryExtension>
<Configuration>
<RSEmailDPConfiguration>
<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/>
</DeliveryUI>
</Extensions>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DisplayErrorLink" Value="true"/>
</Configuration>
Do you configure SSL for the reportserver/reports virtual directories? â' No
Look forward to hearing from you as to what our next step is
Cheers
adam
--
adam
""privatenews"" wrote:
> Hello Adam,
> Thank you for using Microsoft MSDN newsgroup!
> From your description, I understand that you installed SRS 2005 on WinXP
> SP2 machine, but you received the following error message when accessing
> http://localhost/reports. If I'm off-base, please let me know.
> "The attempt to connect to the report server failed. Check your connection
> information and that the report server is a compatible version."
> Based on my experience, you may want to temporarily remove the following
> entry from C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> Services\ReportManager\RSWebApplication.config file:
> <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>.
> Also, please make sure the following entry is listed in above file:
> <ReportServerUrl>http://localhost/reportserver</ReportServerUrl>
> Note: Please back up above file before you do any modification.
> If the issue persists, please go to following URL and let me know the
> result.
> http://localhost/reportserver
> Do you configure SSL for the reportserver/reports virtual directories?
> If you have any update or questions, please feel free to let's know. I look
> forward to your reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> 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 Adam,
Thank you for your update. I found reportserverurl entry is empty on the
first line. Please remove the following line to test the sitaution.
<ReportServerUrl></ReportServerUrl>
We look forward to yur reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||--
adam
""privatenews"" wrote:
> Hello Adam,
> Thank you for your update. I found reportserverurl entry is empty on the
> first line. Please remove the following line to test the sitaution.
> <ReportServerUrl></ReportServerUrl>
> We look forward to yur reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hi Peter,
I removed the line but to no avail
"<ReportServerUrl></ReportServerUrl> "
is there additonal information I can provide you to help diagonse the
situation?
many thx
ps i seemed to have posted a blank response by accident
adam
--
adam
""privatenews"" wrote:
> Hello Adam,
> Thank you for your update. I found reportserverurl entry is empty on the
> first line. Please remove the following line to test the sitaution.
> <ReportServerUrl></ReportServerUrl>
> We look forward to yur reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hello Adam,
Thank you for your update. Before we go further on this issue, I'd like to
know the following information:
1. please go to following URL and let me know the result.
http://localhost/reportserver
2. Please check if sharepoint extension is installed on the default website
Run inetmgr, right click the default Web site->properties->ISAPI Filter,
and check if stsfltr is listed. If so, please add reports and reportserver
virtual directlory Sharepoint Exclusion paths. You can add the Reports
virtual directory to the exclusion paths using Sharepoint administration:
http://msdn2.microsoft.com/en-us/library/ms159697.aspx
3. Did you configure hostheader for your default Web site? Did you use
default 80 port for your default web site?
Run inetmgr,right click the default Web site->properties->Web
site->Advanced, make sure it is default to 80, and no host header if used.
IP address is set to "All unassigned"
4. Change the RSWebApplication.config to following to test
<UI>
<ReportServerUrl>http://localhost/reportserver/</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
</UI>
I'm looking forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi Peter - see my detailed answers below:
It didn't seem to work though: Dont have wss installed so much didn't apply.
many thx adam - look forward to your next installement so we can move on.
Hope we are ruling out the usual suspects. adam
1) please go to following URL and let me know the result.
http://localhost/reportserver
Result below
localhost/ReportServer - /
________________________________________
________________________________________
Microsoft SQL Server Reporting Services Version 9.00.2047.00
2. Please check if sharepoint extension is installed on the default website
Run inetmgr, right click the default Web site->properties->ISAPI Filter,
and check if stsfltr is listed.
IIS - Default Web Site â' ISAPI Filter â' Properties
No Filter listed
3) a) Did you use default 80 port for your default web site? Yes
IIS - Default Web Site â'Web Site - Properties - TCP Port: = 80
b) Is IP address is set to "All unassigned"?
IIS - Default Web Site â'â' Properties â' IP Address: = (All Unassigned)
c) Did you configure hostheader for your default Web site? â' No see below
IIS - Default Web Site â' Properties â' Web Site - IP Address - Advanced
Under: Multiple Identities for this web site
Has the following values
IP Address: Default â' TCP Port: 80 - Host Header Name: BLANK
4. Change the RSWebApplication.config to following to test:
Changes made:
Added â'/â' to the end of
<ReportServerUrl>http://localhost/reportserver</ReportServerUrl>
So it reads
<ReportServerUrl>http://localhost/reportserver/</ReportServerUrl>
Removed the line
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
RSWebApplication.config file after changes below
<Configuration>
<UI>
<ReportServerUrl>http://localhost/reportserver/</ReportServerUrl>
<!--<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>-->
</UI>
<Extensions>
<DeliveryUI>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">
<DefaultDeliveryExtension>True</DefaultDeliveryExtension>
<Configuration>
<RSEmailDPConfiguration>
<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/>
</DeliveryUI>
</Extensions>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DisplayErrorLink" Value="true"/>
</Configuration>
--
adam
""privatenews"" wrote:
> Hello Adam,
> Thank you for your update. Before we go further on this issue, I'd like to
> know the following information:
> 1. please go to following URL and let me know the result.
> http://localhost/reportserver
> 2. Please check if sharepoint extension is installed on the default website
> Run inetmgr, right click the default Web site->properties->ISAPI Filter,
> and check if stsfltr is listed. If so, please add reports and reportserver
> virtual directlory Sharepoint Exclusion paths. You can add the Reports
> virtual directory to the exclusion paths using Sharepoint administration:
> http://msdn2.microsoft.com/en-us/library/ms159697.aspx
>
> 3. Did you configure hostheader for your default Web site? Did you use
> default 80 port for your default web site?
> Run inetmgr,right click the default Web site->properties->Web
> site->Advanced, make sure it is default to 80, and no host header if used.
> IP address is set to "All unassigned"
>
> 4. Change the RSWebApplication.config to following to test
>
> <UI>
> <ReportServerUrl>http://localhost/reportserver/</ReportServerUrl>
> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> </UI>
> I'm looking forward to your reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hello Adam,
Thank you for your update.
Going forward, please collect reporting services web application log under
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\log\ReportserverWebApp*.log
You could send them to me at petery@.microsoft.com
Also, please disable the loopback check on WinXP machine to see if it makes
any difference:
1. Click Start, click Run, type regedit, and then click OK.
2. In Registry Editor, locate and then click the following registry key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
3. Right-click Lsa, point to New, and then click DWORD Value.
4. Type DisableLoopbackCheck, and then press ENTER.
5. Right-click DisableLoopbackCheck, and then click Modify.
6. In the Value data box, type 1, and then click OK.
7. Quit Registry Editor, and then restart your computer.
Since the issue is most likely related to Reportserverurl configuration.
Please change the RSWebApplication.config file to include the exact
following content:
<UI>
<ReportServerUrl>http://localhost/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
And/or
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>http://localhost/reportserver</ReportServerVir
tualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
Please make sure you run iisreset after each test. Thank you for your time
and I look forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||thx
i'll mail the logs to your email.
here's the rest Changed the Registery setting as instructed.
After having made registry editor changes below and before having made
changes to the RSWebApplication.config file I tried the URL
http://localhost/reports/ and got the following error. Please read past the
error as there is more
Server Error in '/Reports' Application.
________________________________________
The report server configuration file specifies localhost for the Web server
name. The report server requires that the computer name be specified instead.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Exception: The report server configuration file
specifies localhost for the Web server name. The report server requires that
the computer name be specified instead.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[Exception: The report server configuration file specifies localhost for the
Web server name. The report server requires that the computer name be
specified instead.]
Microsoft.ReportingServices.Diagnostics.UIConfiguration.ParseXML(XmlNode
node, RSConfiguration configObject) +1211
Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument()
+972
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +32
[ServerConfigurationErrorException: The report server has encountered a
configuration error. See the report server log files for more information.]
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +166
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String
configFileName) +62
Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String
configFileName, String location) +296
Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String
configFileName, String configLocation) +134
Microsoft.ReportingServices.UI.Global.get_ConfigurationManager() +84
Microsoft.ReportingServices.UI.GlobalApp.Application_Start(Object sender,
EventArgs e) +32
________________________________________
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET
Version:2.0.50727.42
********************************************************
I changed the RSWebconfig file as instructed and here were the results:
<UI>
<ReportServerUrl>http://localhost/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
Gave
Server Error in '/Reports' Application.
----
The report server configuration file specifies localhost for the Web server
name. The report server requires that the computer name be specified instead.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Exception: The report server configuration file
specifies localhost for the Web server name. The report server requires that
the computer name be specified instead.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[Exception: The report server configuration file specifies localhost for the
Web server name. The report server requires that the computer name be
specified instead.]
Microsoft.ReportingServices.Diagnostics.UIConfiguration.ParseXML(XmlNode
node, RSConfiguration configObject) +1211
Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument()
+972
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +32
[ServerConfigurationErrorException: The report server has encountered a
configuration error. See the report server log files for more information.]
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +166
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String
configFileName) +62
Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String
configFileName, String location) +296
Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String
configFileName, String configLocation) +134
Microsoft.ReportingServices.UI.Global.get_ConfigurationManager() +84
Microsoft.ReportingServices.UI.Global.get_Configuration() +4
Microsoft.ReportingServices.UI.GlobalApp.Application_AuthenticateRequest(Object sender, EventArgs e) +84
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +64
----
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET
Version:2.0.50727.42
For
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>http://localhost/reportserver</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
The http://localhost/reports/
Gave
The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version.
Thanks very much and I look forward to your next post and help
adam
""privatenews"" wrote:
> Hello Adam,
> Thank you for your update.
> Going forward, please collect reporting services web application log under
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\log\ReportserverWebApp*.log
> You could send them to me at petery@.microsoft.com
> Also, please disable the loopback check on WinXP machine to see if it makes
> any difference:
> 1. Click Start, click Run, type regedit, and then click OK.
> 2. In Registry Editor, locate and then click the following registry key:
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
> 3. Right-click Lsa, point to New, and then click DWORD Value.
> 4. Type DisableLoopbackCheck, and then press ENTER.
> 5. Right-click DisableLoopbackCheck, and then click Modify.
> 6. In the Value data box, type 1, and then click OK.
> 7. Quit Registry Editor, and then restart your computer.
> Since the issue is most likely related to Reportserverurl configuration.
> Please change the RSWebApplication.config file to include the exact
> following content:
> <UI>
> <ReportServerUrl>http://localhost/reportserver</ReportServerUrl>
> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
>
> And/or
>
> <UI>
> <ReportServerUrl></ReportServerUrl>
>
> <ReportServerVirtualDirectory>http://localhost/reportserver</ReportServerVir
> tualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
>
> Please make sure you run iisreset after each test. Thank you for your time
> and I look forward to your reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hello Adam,
Thank you for your update and log infomration. Going forward, please
replace reportserverurl to your computername to test:
<UI>
<ReportServerUrl>http://yourcomputername/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
Also, you may try to use FQDN of your computer name such as
"server.domain.com" to test
<UI>
<ReportServerUrl>http://server.domain.com/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
I appreciate your efforts in working with us and I look forward to your
reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi Peter â' Iâ'm afraid the results were not good
After having placed the computername, both with and without fqdn, in the
ReportServer URL I am afraid I still get
â'The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version. â'
The URLs I used to test were http://computername/reports and
http://localhost/reports
Both gave the same result.
Please could you get back to me with your next suggestions.
adam
--
adam
""privatenews"" wrote:
> Hello Adam,
> Thank you for your update and log infomration. Going forward, please
> replace reportserverurl to your computername to test:
> <UI>
> <ReportServerUrl>http://yourcomputername/reportserver</ReportServerUrl>
> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
> Also, you may try to use FQDN of your computer name such as
> "server.domain.com" to test
> <UI>
> <ReportServerUrl>http://server.domain.com/reportserver</ReportServerUrl>
> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
> I appreciate your efforts in working with us and I look forward to your
> reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Do those two websites exist in IIS (using IIS tools to look at your web
site).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"adam" <adam@.noemail.noemail> wrote in message
news:81A4375D-46B5-478E-B2F5-4FD44F297A05@.microsoft.com...
> Hi Peter - I'm afraid the results were not good
> After having placed the computername, both with and without fqdn, in the
> ReportServer URL I am afraid I still get
> "The attempt to connect to the report server failed. Check your
> connection
> information and that the report server is a compatible version. "
> The URLs I used to test were http://computername/reports and
> http://localhost/reports
> Both gave the same result.
> Please could you get back to me with your next suggestions.
> adam
> --
> adam
>
> ""privatenews"" wrote:
>> Hello Adam,
>> Thank you for your update and log infomration. Going forward, please
>> replace reportserverurl to your computername to test:
>> <UI>
>> <ReportServerUrl>http://yourcomputername/reportserver</ReportServerUrl>
>> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
>> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
>> </UI>
>> Also, you may try to use FQDN of your computer name such as
>> "server.domain.com" to test
>> <UI>
>> <ReportServerUrl>http://server.domain.com/reportserver</ReportServerUrl>
>> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
>> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
>> </UI>
>> I appreciate your efforts in working with us and I look forward to your
>> reply.
>> Best Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>>
>> =====================================================>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> ======================================================>>|||hi bruce
underneath the deafult web site in ISS there are two directories entitled
ReportServer
Reports
please tell me anything else you need to know to help diagnose.
many thx
adam
adam
"Bruce L-C [MVP]" wrote:
> Do those two websites exist in IIS (using IIS tools to look at your web
> site).
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "adam" <adam@.noemail.noemail> wrote in message
> news:81A4375D-46B5-478E-B2F5-4FD44F297A05@.microsoft.com...
> > Hi Peter - I'm afraid the results were not good
> >
> > After having placed the computername, both with and without fqdn, in the
> > ReportServer URL I am afraid I still get
> >
> > "The attempt to connect to the report server failed. Check your
> > connection
> > information and that the report server is a compatible version. "
> >
> > The URLs I used to test were http://computername/reports and
> > http://localhost/reports
> >
> > Both gave the same result.
> >
> > Please could you get back to me with your next suggestions.
> >
> > adam
> >
> > --
> > adam
> >
> >
> > ""privatenews"" wrote:
> >
> >> Hello Adam,
> >>
> >> Thank you for your update and log infomration. Going forward, please
> >> replace reportserverurl to your computername to test:
> >>
> >> <UI>
> >>
> >> <ReportServerUrl>http://yourcomputername/reportserver</ReportServerUrl>
> >>
> >> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> >> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> >>
> >> </UI>
> >>
> >> Also, you may try to use FQDN of your computer name such as
> >> "server.domain.com" to test
> >>
> >> <UI>
> >>
> >> <ReportServerUrl>http://server.domain.com/reportserver</ReportServerUrl>
> >>
> >> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> >> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> >>
> >> </UI>
> >>
> >> I appreciate your efforts in working with us and I look forward to your
> >> reply.
> >>
> >> Best Regards,
> >>
> >> Peter Yang
> >> MCSE2000/2003, MCSA, MCDBA
> >> Microsoft Online Partner Support
> >>
> >>
> >> =====================================================> >>
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >> ======================================================> >>
> >>
> >>
>
>|||Hello Adam,
It seems there are some issue on the components of reportmanager. If you do
not have SQL 2005 SP1 installed, you may want to install it from the
follwoing link:
http://www.microsoft.com/sql/sp1.mspx
if you have SQL 2005 SP1 installed, and you'd like to keep the old
database, please backup databases via the following method, and
remove/reinstall RS component, and then reinstall SP1 for RS component.
How to move a Reporting Services database from a computer that is running
Reporting Services to another computer
http://support.microsoft.com/default.aspx?scid=842425
If the issue persists, I'd like to know the following information. .
How did you configure <UrlRoot> entry in RSReportServer.Config? Do you have
other Web sites running on the server? If so, if you temporarily stop other
web sites and only keep default Web site running, what's the result?
please also help gather the IIS metabase and send them to me
A. Install IIS 6 resource kit which include metaexploer
http://www.microsoft.com/downloads/details.aspx?FamilyID=56FC92EE-A71A-4C73-
B628-ADE629C89499&displaylang=en
B. Run MBExplorer.exe.
C. Right-click LM and click Export to file.
D. Type a name such as "lm" and click OK.
E. Repeat steps for the rest containers.
F. Please compress the files to a ZIP file and send it to me
Thanks for your patience and time, and we look forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi Peter,
The Version of SQLServer that I am running is below
9.00.2047.00 SP1 Developer Edition
Question Peter: is there a way to not have installed SP1 for RS but have
installed it for the rest of RS?
Clarification to be sure:
You would like me to uninstall Reporting Services entirely and reinstall it?
If so thatâ's ok just want to be sure.
The <UrlRoot> entry in RSReportServer.Config is configured as follows
<UrlRoot> http://computername/reportserver<UrlRoot>
Do you have other Web sites running on the server?
No there is just the Report Server sites under the default web sites
IIS Metabase: I have emailed this to you.
Adam
--
adam
""privatenews"" wrote:
> Hello Adam,
> It seems there are some issue on the components of reportmanager. If you do
> not have SQL 2005 SP1 installed, you may want to install it from the
> follwoing link:
> http://www.microsoft.com/sql/sp1.mspx
> if you have SQL 2005 SP1 installed, and you'd like to keep the old
> database, please backup databases via the following method, and
> remove/reinstall RS component, and then reinstall SP1 for RS component.
> How to move a Reporting Services database from a computer that is running
> Reporting Services to another computer
> http://support.microsoft.com/default.aspx?scid=842425
>
> If the issue persists, I'd like to know the following information. .
> How did you configure <UrlRoot> entry in RSReportServer.Config? Do you have
> other Web sites running on the server? If so, if you temporarily stop other
> web sites and only keep default Web site running, what's the result?
>
> please also help gather the IIS metabase and send them to me
> A. Install IIS 6 resource kit which include metaexploer
> http://www.microsoft.com/downloads/details.aspx?FamilyID=56FC92EE-A71A-4C73-
> B628-ADE629C89499&displaylang=en
> B. Run MBExplorer.exe.
> C. Right-click LM and click Export to file.
> D. Type a name such as "lm" and click OK.
> E. Repeat steps for the rest containers.
> F. Please compress the files to a ZIP file and send it to me
> Thanks for your patience and time, and we look forward to your reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hello Adam,
Thank you for your update and information attached to your email.
>Question Peter: is there a way to not have installed SP1 for RS but have
>installed it for the rest of RS?
If you want to install SP1 for components other than SRS, you could
deselect SRS on steup program when prompted.
>You would like me to uninstall Reporting Services entirely and reinstall
it?
>If so thatâ's ok just want to be sure.
Yes. I suggested that remove RS component (including sp1) from Add/Remove
program, reinstall RS compoennt and re-apply SP1 to the component.
From IIS metabase, it seems ASP.net is not working properly for the Rreport
VD since some properties are missing. You could compare reports and
reportserver VD in metabase explorer, some ASP related entries are missed.
I suspect web.config under reportmanager folder is corrupted or has some
missed configuration.
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportManager\
I have included a copy of web.config on my side just for your reference. If
you want to modify the file, please back up it first.
Also, you may want to try to create a new VD for report mangaer by
referring to link below. However, this is just for test and is not a
support situation.
http://sqljunkies.com/Article/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
Thank you for your efforts, and I look forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi Peter,
I unistalled and reinstalled SRS
I then reinstalled sp1
I deleted the Report Server and Report Manager Viritual Directories. I got
Reporting services Configuration screen dumps for you to look at.
Once I completed this it failed however there is something new
http://localhost/Reports
same as before
"The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version"
http://localhost/ReportServer
*NEW MESSAGE*
Reporting Services Error
________________________________________
â?¢ The report server has encountered a configuration error. See the report
server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is
denied.
________________________________________
SQL Server Reporting Services
*ANOTHER NEW MESSAGE*
http://<computer name>/reportserver
Reporting Services Erro
----
The report server installation is not initialized.
(rsReportServerNotActivated) (rsRPCError) Get Online Help
----
SQL Server Reporting Services
Peter need exact instruction on what you think I should modify to proceed.
I wasn't clear what you wanted me to do with the Web config file.
adam
""privatenews"" wrote:
> Hello Adam,
> Thank you for your update and information attached to your email.
> >Question Peter: is there a way to not have installed SP1 for RS but have
> >installed it for the rest of RS?
> If you want to install SP1 for components other than SRS, you could
> deselect SRS on steup program when prompted.
>
> >You would like me to uninstall Reporting Services entirely and reinstall
> it?
> >If so that�s ok just want to be sure.
> Yes. I suggested that remove RS component (including sp1) from Add/Remove
> program, reinstall RS compoennt and re-apply SP1 to the component.
>
> From IIS metabase, it seems ASP.net is not working properly for the Rreport
> VD since some properties are missing. You could compare reports and
> reportserver VD in metabase explorer, some ASP related entries are missed.
> I suspect web.config under reportmanager folder is corrupted or has some
> missed configuration.
> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> Services\ReportManager\
> I have included a copy of web.config on my side just for your reference. If
> you want to modify the file, please back up it first.
>
> Also, you may want to try to create a new VD for report mangaer by
> referring to link below. However, this is just for test and is not a
> support situation.
> http://sqljunkies.com/Article/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
> Thank you for your efforts, and I look forward to your reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hello Adam,
Thank you for your update. Sorry to hear that reinstall doesn't solve the
issue.
From the error message of reportserver, it seems the application pool of
Reportserver VD does not have permission of the file RSReportServer.config
You may want to grant <computername>\aspnet account full NTFS control
permission to the following folders
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportManager\
Right click the folder->Properties->Security, and check the NTFS
permission.
You may add ASPNET account to SQL Server login, and grant it sysadmin role
to isolate the issue
In management studio, find security->login, and add the account
<computername>\aspnet, and grant it sysadmin role.
You could try to connect to ReportServer and reports VDs to test the
situation. You may want to try to initialize RS via RS configuration tool
before doing so.
If you encounter "cannot connect to reportserver database" error, try to
run the following command to re-configure database connection of RS:
rsconfig -s -d reportserver -a Windows -U <domain user account that want
to use> -P <password of the domain user>
Please let me know if you have any update. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi Peter
no luck
followed the steps you outlined please see my status report below!
please read to the bottom.
ASP.net account granted full control to both the REportServer and
ReportManager directory
ASP.net account was part of SQL Server login. I added sysadmin role
RS configuration tool.
Confused here. There are 2 entries on the Intitaliazation page - however
only one of the line items has the intialization check bok filled in.
here are the error items provided by clicking "Tell me more about the
problem and how to resolve it"
ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server
installation is not initialized. (rsReportServerNotActivated)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.InitializeReportServer(String installationId)
ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server
installation is not initialized. (rsReportServerNotActivated)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.InitializeReportServer(String installationId)
Did not use the rsconfig utility in case what I have written changes
anything in anyway.
Also for using the RSconfig utility - please coudl you give me blow blow
instructions of how to use it.
many thx adam
adam
""privatenews"" wrote:
> Hello Adam,
> Thank you for your update. Sorry to hear that reinstall doesn't solve the
> issue.
> From the error message of reportserver, it seems the application pool of
> Reportserver VD does not have permission of the file RSReportServer.config
> You may want to grant <computername>\aspnet account full NTFS control
> permission to the following folders
> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> Services\ReportServer\
> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> Services\ReportManager\
> Right click the folder->Properties->Security, and check the NTFS
> permission.
> You may add ASPNET account to SQL Server login, and grant it sysadmin role
> to isolate the issue
> In management studio, find security->login, and add the account
> <computername>\aspnet, and grant it sysadmin role.
> You could try to connect to ReportServer and reports VDs to test the
> situation. You may want to try to initialize RS via RS configuration tool
> before doing so.
> If you encounter "cannot connect to reportserver database" error, try to
> run the following command to re-configure database connection of RS:
> rsconfig -s -d reportserver -a Windows -U <domain user account that want
> to use> -P <password of the domain user>
> Please let me know if you have any update. Thanks.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hello Adam,
You could try the following command to reconfigure your reporting service:
rsconfig -s -d reportserver -a Windows -U <domain user account that want >
to use> -P <password of the domain user>
For example, your servername is server1, you have domain account
domain1\user1, and password is pass1. The account has sysadmin role on SQL
Server. You want reporting server to use this user's credential to connect
to SQL 2000 and backend reportserver database (YOu could confirm the
database name in enterprise manager of SQL Server, since you reinstall RS,
you may find 2 reportserver databases, please make sure the one you want).
You could use the following command:
rsconfig -s server1 -d reportserver -a Windows -U domain1\user1 -P pass1
More related information:
How to move a Reporting Services database from a computer that is running
Reporting Services to another computer
http://support.microsoft.com/default.aspx?scid=842425
I look forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hello Adam,
Just want to check in if you have further questions on the issue. Please
feel free to post back if need any help.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||--
adam
""privatenews"" wrote:
> Hello Adam,
> Just want to check in if you have further questions on the issue. Please
> feel free to post back if need any help.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hello Adam,
It seems you post this by accident. Not sure if you need further assistance
on this issue? I look forward to your reply. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================
From: =?Utf-8?B?YWRhbQ==?= <adam@.noemail.noemail>
Subject: RE: Report Server is not responding for XP2 sp2 and SQL Server 05
Date: Tue, 8 Aug 2006 07:51:01 -0700
Newsgroups: microsoft.public.sqlserver.reportingsvcs
adam

report server instance question

I know the default web URL for report server is
http://servername/ReportServer .
How do you specify the RS installed on an specified instance? I mean the
syntax. Say if my instance name is finance . Is it
http://servername/ReportServerfinance or something esle? Please let me
know. Thanks.On Oct 4, 8:47 pm, " 00 Michael Jordan" <a...@.b.com> wrote:
> I know the default web URL for report server ishttp://servername/ReportServer.
> How do you specify the RS installed on an specified instance? I mean the
> syntax. Say if my instance name is finance . Is ithttp://servername/ReportServerfinance or something esle? Please let me
> know. Thanks.
The syntax should be: http://servername/ReportServer$finance
Also, this link should be helpful.
http://msdn2.microsoft.com/en-us/library/ms403426.aspx
Regards,
Enrique Martinez
Sr. Software Consultant

Report Server Instance

How do I reference a URL for a Report Server Running on an instance in SQL
Server 2005. I thought it was a $ sign but this is not working (i.e.
http://REPORTSERVER$DEVDW/Reports)
Default Instance : REPORTSERVER
URL: http://REPORTSERVER/Reports
Instance 1: REPORTSERVER\DEVDW
http://?/Reports
Instance 2; REPORTSERVER\PRODDW
http://?/ReportsGot it!!!
http://REPORTSERVER/Reports$INSTANCENAME
"Scott" wrote:
> How do I reference a URL for a Report Server Running on an instance in SQL
> Server 2005. I thought it was a $ sign but this is not working (i.e.
> http://REPORTSERVER$DEVDW/Reports)
> Default Instance : REPORTSERVER
> URL: http://REPORTSERVER/Reports
> Instance 1: REPORTSERVER\DEVDW
> http://?/Reports
> Instance 2; REPORTSERVER\PRODDW
> http://?/Reports

Report Server access via WebClient / HttpWebRequest

Hi,
This is a follow-up question I have to a previous post about accessing the
Reporting Services server without exposing a URL to the user that can be
tampered with.
I am using WebClient / HttpWebRequest to screen scrape a server-side
initiated request to the Reporting Service and writing the output into an
ASPX page. This works to a certain extent.
Unfortunately, when the ASPX page initiates the call, all relative URLs are
not correctly processed. For example, the usual address of the report server
might be http://brensydsql/ReportServer however, using a WebClient /
HttpWebRequest will use the hostname of the machine it's on, so relative URLs
will be relative to the local hostname instead of the report server's
hostname.
ie /images/blah.jpg would resolve as http://hostname/images/blah.jpg instead
of http://brensydsql/images/blah.jpg
Adding a <base href='http://brensydsql'> doesn't work either because Sql
Reporting services resources are only accessible during the request
processing and cannot be directly linked after the request has finished. The
Reporting Server needs to be fooled into thinking the root server is
brensydsql when the request is first initiated.
For some reason, after the report has been processed, the fully qualified
url to the image / whatever resource is no longer valid - seems like it is
only valid for the duration of the request?
I've tried to set the BaseAddress property of the WebClient object but this
has no effect.I have been looking at the same problem. I can't believe Microsoft
decided to pass the parameters unencrypted. Surely they must have
realised developers would need to have hidden and secured params.
Anyway, I digress.
Try using regular expressions to alter all of the links in the report.
The basics of this is here:
http://www.junto.co.uk/Diary/2005/10/6363e490-89a1-4f22-b811-d8d82c98acc9.aspx
Hope this helped.
Philip York wrote:
> Hi,
> This is a follow-up question I have to a previous post about accessing the
> Reporting Services server without exposing a URL to the user that can be
> tampered with.
> I am using WebClient / HttpWebRequest to screen scrape a server-side
> initiated request to the Reporting Service and writing the output into an
> ASPX page. This works to a certain extent.
> Unfortunately, when the ASPX page initiates the call, all relative URLs are
> not correctly processed. For example, the usual address of the report server
> might be http://brensydsql/ReportServer however, using a WebClient /
> HttpWebRequest will use the hostname of the machine it's on, so relative URLs
> will be relative to the local hostname instead of the report server's
> hostname.
> ie /images/blah.jpg would resolve as http://hostname/images/blah.jpg instead
> of http://brensydsql/images/blah.jpg
> Adding a <base href='http://brensydsql'> doesn't work either because Sql
> Reporting services resources are only accessible during the request
> processing and cannot be directly linked after the request has finished. The
> Reporting Server needs to be fooled into thinking the root server is
> brensydsql when the request is first initiated.
> For some reason, after the report has been processed, the fully qualified
> url to the image / whatever resource is no longer valid - seems like it is
> only valid for the duration of the request?
> I've tried to set the BaseAddress property of the WebClient object but this
> has no effect.

REPORT SERVER

Hi - I am trying to access the report server installed by SQL2005 for the first time and keep receiving this error message: using url -http://localhost/reports

Failed to map the path '/Reports/App_GlobalResources/

Have you gone through the configuration yet?

Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > Reporting Services Configuration

I hope this helps

Report Refresh through code in reporting services

I use some editor to edit the data in the backend. I view the report in sharepoint portal using url access of the report in reporting services with the toolbar disabled by rc:toolbar=false. Now, as and when I edit the data of the report using an editor, I want the report to be updated with the new data. This I want to do it by placing a button or some link in the Sharepoint, clicking which should update the report with the new data. Is there any parameter like rc:refresh which will refresh the report?
--
Message posted via http://www.sqlmonster.comYes, rs:ClearSession=true will refresh the report.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Varma via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:9fcebb16b4f6418fb26b01a1a4841f5d@.SQLMonster.com...
>I use some editor to edit the data in the backend. I view the report in
>sharepoint portal using url access of the report in reporting services with
>the toolbar disabled by rc:toolbar=false. Now, as and when I edit the data
>of the report using an editor, I want the report to be updated with the new
>data. This I want to do it by placing a button or some link in the
>Sharepoint, clicking which should update the report with the new data. Is
>there any parameter like rc:refresh which will refresh the report?
> --
> Message posted via http://www.sqlmonster.com