RS2005 setup blues

I installed RS2005(SP2) with a SQL2000(sp4) db. Both are on seperate Windoes 2003 servers. I configured the reports manager to connect to a different web site on the same server instead of default web site. There were no installation prohlems. The RS server is up and running , all the virtual directories setup etc. When I try to access the reports directory via: http://dev2/Reports or browse the reports virtual directory from IIS, I get a 401 access denied error. The RS log reads:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>D:\ReportingServices2005\MSSQL.1\Reporting Services\LogFiles\ReportServerWebApp__07_10_2007_11_29_21.log</Path>
<SystemName>NWISTCST99</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
<OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!5!7/10/2007-11:29:30:: e ERROR: The request failed with HTTP status 401: Unauthorized.
w3wp!ui!5!7/10/2007-11:29:31:: e ERROR: HTTP status code --> 500
-Details--
System.Net.WebException: The request failed with HTTP status 401: Unauthorized.

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()

at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()

at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)

at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Page.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!5!7/10/2007-11:29:32:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

Please advise.

The RSweApplication.config in the ReportManager folder has the fully qualified URL to ReportServer<ReportServerUrl> and I have blanked out the <ReportServerVirtualDirectory>

Also the <UrlRoot> in rsreportserver.config in ReportServer folder points to the fully qualified URL to ReportServer.

What am I missing here ..?

Hello,

Can you hit http://<server>/ReportServer? This is the underlying worker site for the Web Application found at http://<server>/Reports.

Here is a blog post on troubleshooting 401 errors with IIS: http://blogs.msdn.com/david.wang/archive/2005/07/14/HOWTO_Diagnose_IIS_401_Access_Denied.aspx

You could be having a Kerberos issue because SQL and IIS are on different servers. Here is an blog post from Brian Kelley on troubleshooting Kerberos: http://blogs.sqlservercentral.com/blogs/brian_kelley/archive/2006/04/05/568.aspx.

Let me know if this doesn't help.

Larry

|||

When I try http://<web site>/ReportServer, I can get to it. It comes up with a version number:

10.32.12.204/ReportServer - /

Microsoft SQL Server Reporting Services Version 9.00.3042.00

I had the virtual directories set up for Integtated windows authentication only.

When I enable anonymous access, I do not get the 401 error but there is no way I can create folders, subscriptions set up users etc. There are only 3 links: Home (to the reports directory). My subscriptions that is empty (There are no items to show in this view) and a help link.

Something is missing here ...

|||

Setting the sites to use anonymous and having it work means that it is an IIS permissions issue, thus, a SSRS configuration issue. Your installation worked. Try changing the configuration file to use the IP address or the Fully Qualified Domain Name for the Report Server location. Take a look at the 401 troubleshooting article and see if it can help you track down the problem.

The reason that you can't do anything as anonymous is that the anonymous user does not have any rights in SSRS by default. For testing purposes, you could change the accound used for anonymous access (IUSR_<machine name>) to an account with Admin rights and you would be able to manage SSRS. By default, all Admins are given full rights to an SSRS installation.

Larry

|||

thanks a lot Larry,

change the config files from name to hard coded IP address resolved the issue. I had already re-installed RS and IIS and was running out of options.

|||

No problem! Glad to hear that it worked out!

Larry

RS2005 post installation problems

I am having frustrating errors on RS2005. Here is the scenario:

RS2005 with SQL2000 SP4 db.

Both the above are on 2 seperate servers Windows 2003 SP2.

The setup had no problems. Can see the RS up and running on the RS configuration.

web-interface not configured to default web site: I get a 401 error when I try to access the Reports manager viahttp://dev/Reports . This is my test site. Here is the error from RS logs:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>D:\ReportingServices2005\MSSQL.1\Reporting Services\LogFiles\ReportServerWebApp__07_10_2007_11_29_21.log</Path>
<SystemName>NWISTCST99</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
<OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!5!7/10/2007-11:29:30:: e ERROR: The request failed with HTTP status 401: Unauthorized.
w3wp!ui!5!7/10/2007-11:29:31:: e ERROR: HTTP status code --> 500
---Details---
System.Net.WebException: The request failed with HTTP status 401: Unauthorized.

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()

at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()

at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)

at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Page.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!5!7/10/2007-11:29:32:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

Pls advise

thanks

HI,raghu1:

Verify your NTFS permissions for the users on the folder C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer.

He should have ("Read & Execute", "List Folder Content" and "Read").

In IIS for Reports and ReportServer app set Authenication method to "Basic authentication" from "Integrated Windows authentication".

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

HI,raghu1:

We are marking this issue as "Answered". If you have any new findings or concerns, please feel free to unmark the issue.
Thank you for your understanding!

RS two seperate queries within a report

Hi all.
I was wondering if I have a report andI want to prompt the user to
choose say current inventory or all inventory...Can i do that within a
parameter? The problem I'm having is that if the user chooses current
inventory it runs a query but if the user chooses all inventory it
would have to run a seperate query. Is there any way to do this in RS?
Thanks in advance.
MissyModify you query a little bit will let the user select either all inventory
or a single inventory
Let's say you have 2 datasets:
Dataset Inventory
SELECT * FROM your_table where prod = @.prod OR @.prod = 'All'
and
Dataset Prod
SELECT 'ALL' as Prod UNION
SELECT Prod from your_table -- products list
while in Layout tab change Report Parameters so the Prod parameter will get
result from dataset Prod.
"aggiechick717" <mhoppe@.chkenergy.com> wrote in message
news:1159456164.936789.137990@.m7g2000cwm.googlegroups.com...
> Hi all.
> I was wondering if I have a report andI want to prompt the user to
> choose say current inventory or all inventory...Can i do that within a
> parameter? The problem I'm having is that if the user chooses current
> inventory it runs a query but if the user chooses all inventory it
> would have to run a seperate query. Is there any way to do this in RS?
>
> Thanks in advance.
> Missy
>

RS tiered architecture

I've implemented a solution with application, database and report server on seperate machines. The application is a web app and is Internet facing. What is the best method for executing reports on the RS server that are initiated from the web server? Using URL access requires a login or anonymous access neither of which are desired. Web services works but I loose access to the toolbar. Is there some other way to pull this off where I can let the public access reports and give them access to the toolbar?

Thanks.

Assuming SSRS 2005, the best way will be to use the ASP.NET ReportViewer control since it generates the report on the server and preserves the report interactive features. This article may help to get you started.|||

Thanks.

My understanding is that the Web ReportViewer the report is rendered on the browser not on the server and as such we loose the benefits of server cashing.Does this present a performance issue?

I'll give it a shot.

|||>>

My understanding is that the Web ReportViewer the report is rendered on the browser not on the server and as such we loose the benefits of server cashing. Does this present a performance issue?

<<

Your understanding is incorrect, so it is difficult to gauge the performance issue <s>.

The ReportViewer (web or win) has two modes. One is local, the other is server. But in neither mode would the ReportViewer be rendering in the browser. The difference is whether it is rendering in the RS server or in your web server tier, and also which tier is preparing the data.

In your case it looks like you are going to be using server mode, which means the reports come from the RS server tier and the data is prepared there as well, of course. The web tier hosts the control, requests report pages from the RS server, and sends the full page content for sending to the browser

In local mode the web tier hosts the control *and* the rendering code for the report page(s) without delegating to an RS server.

In local mode, if you are talking about report caching rather than web page, yes you are not going to have it because that is provided by the RS server. But if you are in server mode the RS server is going to decide to deliver a cached report (snapshot) based on its own settings, regardless of the client, as far as I know.

HTH,

>L<

PS To be strictly accurate, in all cases and all types of content a browser also "renders" a web page for display. But how a browser chooses to "render" what a reportcontrol sends is more like how it renders an image downloaded from a server. It doesn't "render" the JPG in the sense of creating it.

|||

My understanding is that the Web ReportViewer the report is rendered on the browser not on the server and as such we loose the benefits of server cashing. Does this present a performance issue?

We need to clarify what you mean by "render" and "server caching". The VS.NET 2005 ASP.NET report viewer is no much different than an ASP.NET page. It submits report requests to the Report Server on behalf of the user, gets the report presentation, and streams it to the client. This all happens on the server side. As with any web application, it is the browser who renders the HTML content to the user but it is a thin client. As far as the "server caching" I have no idea what benefits you are referring to.