Showing posts with label remote. Show all posts
Showing posts with label remote. Show all posts

Friday, March 30, 2012

Reportviewer does not load properly in a content page

Hi all,

I have two (2) questions here:

1) I have a reportviewer control in an aspx page. It is remote access server report. Everything works fine from report server and in vs 2005. But Report does not load properly once put on a content page. The multi-value parameter dropdown list is not clickable! It worked in a non master/content page.

Here is my code for the page that does not work:

<%@. Page Language="C#" MasterPageFile="~/FysbReviewer.master" AutoEventWireup="true" CodeFile="ReportsMenu.aspx.cs" Inherits="ReportsMenu" Title="Report Menu" %><%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder3" Runat="Server">

<rsweb:ReportViewer ID="ReportViewer1" runat="server" style="position:static" ShowParameterPrompts="true"
Font-Names="Verdana" Font-Size="8pt" Height="800px" ProcessingMode="Remote" Width="100%">
<ServerReport ReportPath="/FysbReports/Report1" />
</rsweb:ReportViewer>
</asp:Content>

Here is the code that reportviewer worked:

<%@. Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %>

<%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<rsweb:reportviewer id="ReportViewer1" runat="server" font-names="Verdana" font-size="8pt"
height="800px" processingmode="Remote" width="100%">
<ServerReport ReportPath="/FysbReports/Report1"></ServerReport>
</rsweb:reportviewer>

</div>
</form>
</body>
</html>

Question 2: How can I format the multi-value parameter prompts so that all selection are displayed as checkbox directly instead of clicking the dropdownlist and view the multple choices?

I know it is Friday afternoo. I want to say TIG Friday, but it looks like a long Friday afternoon ahead... Please help!

Hi,

From your description, it seems that your reportviewer works in a normal page but not in a master/content page, right?

Generally, for this kind of issue, the main issue is that the resource of ReportPath attribute of ServerReport maps doesn't exist. You should try to check the relative path of each resource to see if they match the relationship of your masterpage, content and the reportpath.

Second, the viewer does support multivalue parameters, but it doesn't have any concept of parsing based on comma or any other separator. When you supply the value from your textbox to the report, you will need to write your code and parse it on your own and supply the array of values to the ReportParameter object.

Thanks.

Wednesday, March 28, 2012

ReportViewer control

trying to build a test page with a single ReportViewer control



<rsweb:ReportViewer ID="ReportViewer1" ProcessingMode="remote" runat="server">

<ServerReport DisplayName="VSTestReport" ReportPath="MyReports/VSTestReport" ReportServerUrl="http://pugrs/reportserver"/>

</rsweb:ReportViewer>


build fails with 401: Unauthorized.
Not even sure where to begin troubleshooting this one. Any ideas?
Thanks!

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.Net.WebException: The request failed with HTTP status 401: Unauthorized.

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:

[WebException: The request failed with HTTP status 401: Unauthorized.]
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +240
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +86
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname) +33
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +152
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean useCurrentValues) +138
Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +182
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1787
ok. got past the authentication problem... got a new one now:

The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply. > The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply.
|||

I believe the problem is in the placement of your "/"

When naming the the server is should look like "http://localhost/reportserver"
then when naming the report path it would be "/MyReports/VSTestReport"

Good Luck
-JW

|||Hi PugV,

Got the same problem as you had with the authentication. It was probably pretty easy to solve but I'm a newbie so I'm glad for any help. What did you do to make it work? I have no clue where to begin searching for this one.

Thanks for your answer in advance.

Nat|||Thanks JW. -- adding a slash did work

the error message that says: The path must not start with slash, should probably be a bit more helpful ;)

|||

Nat.
We were playing with some domain accounts at the time, and the problem went away once we stopped. I have to assume that error had something to do with that -- I didn't do anything specific to resolve it.

|||Pugv,

I surely need your help TOO. I met the same "unauthorized" error. I cannot use this kind of url:
server: "http://localhost/reportserver"
report path:"/MyReports/VSTestReport"
because it will show 404 Not found error. I used:
server: "http://localhost/reportserver?"
report path:"/MyReports/VSTestReport"
and got the "unauthorized" error. Which version of visual studio are you using? I'm using 2005 beta 2.

I have tried different settings for the reportserver, even implemented IReportServerCredentials, but no luck at all. There is absolutely NO problem when I connect directly to http://localhost/reportserver?/MyReports/VSTestReport

using browser. But when using reportviewer, always "unauthorized". I'm crazy with it now. Can you post your exact codes so that I can try on my machine? Thanks.|||

Camms
I had the same trouble you did. This is what I did to make it work.

reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://localhost/reportserver");
reportViewer1.ServerReport.ReportPath = reportPath;
reportViewer1.RefreshReport();

-JW

|||could you tell me how you solved authentication problem?|||

i have the authentication problem too...

|||

I got it running by Just putting following

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

Height="400px" ProcessingMode="Remote" Width="400px">

<ServerReport ReportPath="/WebReport/warmup"

ReportServerUrl="http://localhost/reportserver" />

</rsweb:ReportViewer>

|||I think that as long you are doing it on localhost, it will work.

I am using a web app on another iss than the on hosting the sql2005.

I have to pass some authentication, but I need a step by step code example. Can anybody please please help?|||

I have the same problem

IIS / ASP.net on Server1, SQL Server 2005 Standard and Reporting Services on Server2

My web app uses forms authentication with the ASP.net SqlAuthenticationProvider. So my users are stored in a table in Sql Server 2005

How do I have to pass a authentication if I like to use the ReportViewer Control in my Website?

Thanks,

Dirk

|||

I am having the same problem, my Reporting Services is also in a different server.

Currently, if I open the the reporting services using a web browser it prompts for a windows login, which I think I need to pass the same information using a ReportViewer control inside a code.

Example:

ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
// Get the Report Server endpoint from the config file
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
ReportViewer1.ServerReport.ReportPath = "DailyCensus";

// Need to a code to pass the windows authentication....
//ReportViewer1.ServerReport.ReportServerCredentials

|||Anyone solved the problem with "401: Unauthorized" when viewing the reportViewer if WebServer and SSRS are in 2 servers?

ReportViewer control

trying to build a test page with a single ReportViewer control



<rsweb:ReportViewer ID="ReportViewer1" ProcessingMode="remote" runat="server">

<ServerReport DisplayName="VSTestReport" ReportPath="MyReports/VSTestReport" ReportServerUrl="http://pugrs/reportserver"/>

</rsweb:ReportViewer>


build fails with 401: Unauthorized.
Not even sure where to begin troubleshooting this one. Any ideas?
Thanks!

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.Net.WebException: The request failed with HTTP status 401: Unauthorized.

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:

[WebException: The request failed with HTTP status 401: Unauthorized.]
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +240
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +86
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname) +33
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +152
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean useCurrentValues) +138
Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +182
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1787
ok. got past the authentication problem... got a new one now:

The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply. > The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply.|||

I believe the problem is in the placement of your "/"

When naming the the server is should look like "http://localhost/reportserver"
then when naming the report path it would be "/MyReports/VSTestReport"

Good Luck
-JW

|||Hi PugV,

Got the same problem as you had with the authentication. It was probably pretty easy to solve but I'm a newbie so I'm glad for any help. What did you do to make it work? I have no clue where to begin searching for this one.

Thanks for your answer in advance.

Nat|||Thanks JW. -- adding a slash did work

the error message that says: The path must not start with slash, should probably be a bit more helpful ;)

|||

Nat.
We were playing with some domain accounts at the time, and the problem went away once we stopped. I have to assume that error had something to do with that -- I didn't do anything specific to resolve it.

|||Pugv,

I surely need your help TOO. I met the same "unauthorized" error. I cannot use this kind of url:
server: "http://localhost/reportserver"
report path:"/MyReports/VSTestReport"
because it will show 404 Not found error. I used:
server: "http://localhost/reportserver?"
report path:"/MyReports/VSTestReport"
and got the "unauthorized" error. Which version of visual studio are you using? I'm using 2005 beta 2.

I have tried different settings for the reportserver, even implemented IReportServerCredentials, but no luck at all. There is absolutely NO problem when I connect directly to http://localhost/reportserver?/MyReports/VSTestReport

using browser. But when using reportviewer, always "unauthorized". I'm crazy with it now. Can you post your exact codes so that I can try on my machine? Thanks.|||

Camms
I had the same trouble you did. This is what I did to make it work.

reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://localhost/reportserver");
reportViewer1.ServerReport.ReportPath = reportPath;
reportViewer1.RefreshReport();

-JW

|||could you tell me how you solved authentication problem?|||

i have the authentication problem too...

|||

I got it running by Just putting following

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

Height="400px" ProcessingMode="Remote" Width="400px">

<ServerReport ReportPath="/WebReport/warmup"

ReportServerUrl="http://localhost/reportserver" />

</rsweb:ReportViewer>

|||I think that as long you are doing it on localhost, it will work.

I am using a web app on another iss than the on hosting the sql2005.

I have to pass some authentication, but I need a step by step code example. Can anybody please please help?|||

I have the same problem

IIS / ASP.net on Server1, SQL Server 2005 Standard and Reporting Services on Server2

My web app uses forms authentication with the ASP.net SqlAuthenticationProvider. So my users are stored in a table in Sql Server 2005

How do I have to pass a authentication if I like to use the ReportViewer Control in my Website?

Thanks,

Dirk

|||

I am having the same problem, my Reporting Services is also in a different server.

Currently, if I open the the reporting services using a web browser it prompts for a windows login, which I think I need to pass the same information using a ReportViewer control inside a code.

Example:

ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
// Get the Report Server endpoint from the config file
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
ReportViewer1.ServerReport.ReportPath = "DailyCensus";

// Need to a code to pass the windows authentication....
//ReportViewer1.ServerReport.ReportServerCredentials

|||Anyone solved the problem with "401: Unauthorized" when viewing the reportViewer if WebServer and SSRS are in 2 servers?

ReportViewer control

trying to build a test page with a single ReportViewer control



<rsweb:ReportViewer ID="ReportViewer1" ProcessingMode="remote" runat="server">

<ServerReport DisplayName="VSTestReport" ReportPath="MyReports/VSTestReport" ReportServerUrl="http://pugrs/reportserver"/>

</rsweb:ReportViewer>


build fails with 401: Unauthorized.
Not even sure where to begin troubleshooting this one. Any ideas?
Thanks!

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.Net.WebException: The request failed with HTTP status 401: Unauthorized.

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:

[WebException: The request failed with HTTP status 401: Unauthorized.]
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +240
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +86
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname) +33
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +152
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean useCurrentValues) +138
Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +182
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1787
ok. got past the authentication problem... got a new one now:

The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply. > The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply.
|||

I believe the problem is in the placement of your "/"

When naming the the server is should look like "http://localhost/reportserver"
then when naming the report path it would be "/MyReports/VSTestReport"

Good Luck
-JW

|||Hi PugV,

Got the same problem as you had with the authentication. It was probably pretty easy to solve but I'm a newbie so I'm glad for any help. What did you do to make it work? I have no clue where to begin searching for this one.

Thanks for your answer in advance.

Nat|||Thanks JW. -- adding a slash did work

the error message that says: The path must not start with slash, should probably be a bit more helpful ;)

|||

Nat.
We were playing with some domain accounts at the time, and the problem went away once we stopped. I have to assume that error had something to do with that -- I didn't do anything specific to resolve it.

|||Pugv,

I surely need your help TOO. I met the same "unauthorized" error. I cannot use this kind of url:
server: "http://localhost/reportserver"
report path:"/MyReports/VSTestReport"
because it will show 404 Not found error. I used:
server: "http://localhost/reportserver?"
report path:"/MyReports/VSTestReport"
and got the "unauthorized" error. Which version of visual studio are you using? I'm using 2005 beta 2.

I have tried different settings for the reportserver, even implemented IReportServerCredentials, but no luck at all. There is absolutely NO problem when I connect directly to http://localhost/reportserver?/MyReports/VSTestReport

using browser. But when using reportviewer, always "unauthorized". I'm crazy with it now. Can you post your exact codes so that I can try on my machine? Thanks.|||

Camms
I had the same trouble you did. This is what I did to make it work.

reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://localhost/reportserver");
reportViewer1.ServerReport.ReportPath = reportPath;
reportViewer1.RefreshReport();

-JW

|||could you tell me how you solved authentication problem?|||

i have the authentication problem too...

|||

I got it running by Just putting following

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

Height="400px" ProcessingMode="Remote" Width="400px">

<ServerReport ReportPath="/WebReport/warmup"

ReportServerUrl="http://localhost/reportserver" />

</rsweb:ReportViewer>

|||I think that as long you are doing it on localhost, it will work.

I am using a web app on another iss than the on hosting the sql2005.

I have to pass some authentication, but I need a step by step code example. Can anybody please please help?|||

I have the same problem

IIS / ASP.net on Server1, SQL Server 2005 Standard and Reporting Services on Server2

My web app uses forms authentication with the ASP.net SqlAuthenticationProvider. So my users are stored in a table in Sql Server 2005

How do I have to pass a authentication if I like to use the ReportViewer Control in my Website?

Thanks,

Dirk

|||

I am having the same problem, my Reporting Services is also in a different server.

Currently, if I open the the reporting services using a web browser it prompts for a windows login, which I think I need to pass the same information using a ReportViewer control inside a code.

Example:

ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
// Get the Report Server endpoint from the config file
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
ReportViewer1.ServerReport.ReportPath = "DailyCensus";

// Need to a code to pass the windows authentication....
//ReportViewer1.ServerReport.ReportServerCredentials

|||Anyone solved the problem with "401: Unauthorized" when viewing the reportViewer if WebServer and SSRS are in 2 servers?

ReportViewer control

trying to build a test page with a single ReportViewer control



<rsweb:ReportViewer ID="ReportViewer1" ProcessingMode="remote" runat="server">

<ServerReport DisplayName="VSTestReport" ReportPath="MyReports/VSTestReport" ReportServerUrl="http://pugrs/reportserver"/>

</rsweb:ReportViewer>


build fails with 401: Unauthorized.
Not even sure where to begin troubleshooting this one. Any ideas?
Thanks!

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.Net.WebException: The request failed with HTTP status 401: Unauthorized.

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:

[WebException: The request failed with HTTP status 401: Unauthorized.]
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +240
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +86
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname) +33
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +152
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean useCurrentValues) +138
Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +182
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1787
ok. got past the authentication problem... got a new one now:

The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply. > The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply.
|||

I believe the problem is in the placement of your "/"

When naming the the server is should look like "http://localhost/reportserver"
then when naming the report path it would be "/MyReports/VSTestReport"

Good Luck
-JW

|||Hi PugV,

Got the same problem as you had with the authentication. It was probably pretty easy to solve but I'm a newbie so I'm glad for any help. What did you do to make it work? I have no clue where to begin searching for this one.

Thanks for your answer in advance.

Nat|||Thanks JW. -- adding a slash did work

the error message that says: The path must not start with slash, should probably be a bit more helpful ;)

|||

Nat.
We were playing with some domain accounts at the time, and the problem went away once we stopped. I have to assume that error had something to do with that -- I didn't do anything specific to resolve it.

|||Pugv,

I surely need your help TOO. I met the same "unauthorized" error. I cannot use this kind of url:
server: "http://localhost/reportserver"
report path:"/MyReports/VSTestReport"
because it will show 404 Not found error. I used:
server: "http://localhost/reportserver?"
report path:"/MyReports/VSTestReport"
and got the "unauthorized" error. Which version of visual studio are you using? I'm using 2005 beta 2.

I have tried different settings for the reportserver, even implemented IReportServerCredentials, but no luck at all. There is absolutely NO problem when I connect directly to http://localhost/reportserver?/MyReports/VSTestReport

using browser. But when using reportviewer, always "unauthorized". I'm crazy with it now. Can you post your exact codes so that I can try on my machine? Thanks.|||

Camms
I had the same trouble you did. This is what I did to make it work.

reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://localhost/reportserver");
reportViewer1.ServerReport.ReportPath = reportPath;
reportViewer1.RefreshReport();

-JW

|||could you tell me how you solved authentication problem?|||

i have the authentication problem too...

|||

I got it running by Just putting following

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

Height="400px"ProcessingMode="Remote"Width="400px">

<ServerReportReportPath="/WebReport/warmup"

ReportServerUrl="http://localhost/reportserver"/>

</rsweb:ReportViewer>

|||I think that as long you are doing it on localhost, it will work.

I am using a web app on another iss than the on hosting the sql2005.

I have to pass some authentication, but I need a step by step code example. Can anybody please please help?|||

I have the same problem

IIS / ASP.net on Server1, SQL Server 2005 Standard and Reporting Services on Server2

My web app uses forms authentication with the ASP.net SqlAuthenticationProvider. So my users are stored in a table in Sql Server 2005

How do I have to pass a authentication if I like to use the ReportViewer Control in my Website?

Thanks,

Dirk

|||

I am having the same problem, my Reporting Services is also in a different server.

Currently, if I open the the reporting services using a web browser it prompts for a windows login, which I think I need to pass the same information using a ReportViewer control inside a code.

Example:

ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
// Get the Report Server endpoint from the config file
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
ReportViewer1.ServerReport.ReportPath = "DailyCensus";

// Need to a code to pass the windows authentication....
//ReportViewer1.ServerReport.ReportServerCredentials

|||Anyone solved the problem with "401: Unauthorized" when viewing the reportViewer if WebServer and SSRS are in 2 servers?

ReportViewer control

trying to build a test page with a single ReportViewer control



<rsweb:ReportViewer ID="ReportViewer1" ProcessingMode="remote" runat="server">

<ServerReport DisplayName="VSTestReport" ReportPath="MyReports/VSTestReport" ReportServerUrl="http://pugrs/reportserver"/>

</rsweb:ReportViewer>


build fails with 401: Unauthorized.
Not even sure where to begin troubleshooting this one. Any ideas?
Thanks!

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.Net.WebException: The request failed with HTTP status 401: Unauthorized.

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:

[WebException: The request failed with HTTP status 401: Unauthorized.]
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +240
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +86
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname) +33
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +152
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean useCurrentValues) +138
Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +182
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1787
ok. got past the authentication problem... got a new one now:

The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply. > The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply.
|||

I believe the problem is in the placement of your "/"

When naming the the server is should look like "http://localhost/reportserver"
then when naming the report path it would be "/MyReports/VSTestReport"

Good Luck
-JW

|||Hi PugV,

Got the same problem as you had with the authentication. It was probably pretty easy to solve but I'm a newbie so I'm glad for any help. What did you do to make it work? I have no clue where to begin searching for this one.

Thanks for your answer in advance.

Nat|||Thanks JW. -- adding a slash did work

the error message that says: The path must not start with slash, should probably be a bit more helpful ;)

|||

Nat.
We were playing with some domain accounts at the time, and the problem went away once we stopped. I have to assume that error had something to do with that -- I didn't do anything specific to resolve it.

|||Pugv,

I surely need your help TOO. I met the same "unauthorized" error. I cannot use this kind of url:
server: "http://localhost/reportserver"
report path:"/MyReports/VSTestReport"
because it will show 404 Not found error. I used:
server: "http://localhost/reportserver?"
report path:"/MyReports/VSTestReport"
and got the "unauthorized" error. Which version of visual studio are you using? I'm using 2005 beta 2.

I have tried different settings for the reportserver, even implemented IReportServerCredentials, but no luck at all. There is absolutely NO problem when I connect directly to http://localhost/reportserver?/MyReports/VSTestReport

using browser. But when using reportviewer, always "unauthorized". I'm crazy with it now. Can you post your exact codes so that I can try on my machine? Thanks.|||

Camms
I had the same trouble you did. This is what I did to make it work.

reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://localhost/reportserver");
reportViewer1.ServerReport.ReportPath = reportPath;
reportViewer1.RefreshReport();

-JW

|||could you tell me how you solved authentication problem?|||

i have the authentication problem too...

|||

I got it running by Just putting following

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

Height="400px" ProcessingMode="Remote" Width="400px">

<ServerReport ReportPath="/WebReport/warmup"

ReportServerUrl="http://localhost/reportserver" />

</rsweb:ReportViewer>

|||I think that as long you are doing it on localhost, it will work.

I am using a web app on another iss than the on hosting the sql2005.

I have to pass some authentication, but I need a step by step code example. Can anybody please please help?|||

I have the same problem

IIS / ASP.net on Server1, SQL Server 2005 Standard and Reporting Services on Server2

My web app uses forms authentication with the ASP.net SqlAuthenticationProvider. So my users are stored in a table in Sql Server 2005

How do I have to pass a authentication if I like to use the ReportViewer Control in my Website?

Thanks,

Dirk

|||

I am having the same problem, my Reporting Services is also in a different server.

Currently, if I open the the reporting services using a web browser it prompts for a windows login, which I think I need to pass the same information using a ReportViewer control inside a code.

Example:

ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
// Get the Report Server endpoint from the config file
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
ReportViewer1.ServerReport.ReportPath = "DailyCensus";

// Need to a code to pass the windows authentication....
//ReportViewer1.ServerReport.ReportServerCredentials

|||Anyone solved the problem with "401: Unauthorized" when viewing the reportViewer if WebServer and SSRS are in 2 servers?

ReportViewer control

trying to build a test page with a single ReportViewer control



<rsweb:ReportViewer ID="ReportViewer1" ProcessingMode="remote" runat="server">

<ServerReport DisplayName="VSTestReport" ReportPath="MyReports/VSTestReport" ReportServerUrl="http://pugrs/reportserver"/>

</rsweb:ReportViewer>


build fails with 401: Unauthorized.
Not even sure where to begin troubleshooting this one. Any ideas?
Thanks!

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.Net.WebException: The request failed with HTTP status 401: Unauthorized.

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:

[WebException: The request failed with HTTP status 401: Unauthorized.]
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +240
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +86
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname) +33
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +152
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean useCurrentValues) +138
Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +182
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1787
ok. got past the authentication problem... got a new one now:

The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply. > The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply.|||

I believe the problem is in the placement of your "/"

When naming the the server is should look like "http://localhost/reportserver"
then when naming the report path it would be "/MyReports/VSTestReport"

Good Luck
-JW

|||Hi PugV,

Got the same problem as you had with the authentication. It was probably pretty easy to solve but I'm a newbie so I'm glad for any help. What did you do to make it work? I have no clue where to begin searching for this one.

Thanks for your answer in advance.

Nat|||Thanks JW. -- adding a slash did work

the error message that says: The path must not start with slash, should probably be a bit more helpful ;)

|||

Nat.
We were playing with some domain accounts at the time, and the problem went away once we stopped. I have to assume that error had something to do with that -- I didn't do anything specific to resolve it.

|||Pugv,

I surely need your help TOO. I met the same "unauthorized" error. I cannot use this kind of url:
server: "http://localhost/reportserver"
report path:"/MyReports/VSTestReport"
because it will show 404 Not found error. I used:
server: "http://localhost/reportserver?"
report path:"/MyReports/VSTestReport"
and got the "unauthorized" error. Which version of visual studio are you using? I'm using 2005 beta 2.

I have tried different settings for the reportserver, even implemented IReportServerCredentials, but no luck at all. There is absolutely NO problem when I connect directly to http://localhost/reportserver?/MyReports/VSTestReport

using browser. But when using reportviewer, always "unauthorized". I'm crazy with it now. Can you post your exact codes so that I can try on my machine? Thanks.|||

Camms
I had the same trouble you did. This is what I did to make it work.

reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://localhost/reportserver");
reportViewer1.ServerReport.ReportPath = reportPath;
reportViewer1.RefreshReport();

-JW

|||could you tell me how you solved authentication problem?|||

i have the authentication problem too...

|||

I got it running by Just putting following

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

Height="400px" ProcessingMode="Remote" Width="400px">

<ServerReport ReportPath="/WebReport/warmup"

ReportServerUrl="http://localhost/reportserver" />

</rsweb:ReportViewer>

|||I think that as long you are doing it on localhost, it will work.

I am using a web app on another iss than the on hosting the sql2005.

I have to pass some authentication, but I need a step by step code example. Can anybody please please help?|||

I have the same problem

IIS / ASP.net on Server1, SQL Server 2005 Standard and Reporting Services on Server2

My web app uses forms authentication with the ASP.net SqlAuthenticationProvider. So my users are stored in a table in Sql Server 2005

How do I have to pass a authentication if I like to use the ReportViewer Control in my Website?

Thanks,

Dirk

|||

I am having the same problem, my Reporting Services is also in a different server.

Currently, if I open the the reporting services using a web browser it prompts for a windows login, which I think I need to pass the same information using a ReportViewer control inside a code.

Example:

ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
// Get the Report Server endpoint from the config file
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
ReportViewer1.ServerReport.ReportPath = "DailyCensus";

// Need to a code to pass the windows authentication....
//ReportViewer1.ServerReport.ReportServerCredentials

|||Anyone solved the problem with "401: Unauthorized" when viewing the reportViewer if WebServer and SSRS are in 2 servers?sql

ReportViewer control

trying to build a test page with a single ReportViewer control



<rsweb:ReportViewer ID="ReportViewer1" ProcessingMode="remote" runat="server">

<ServerReport DisplayName="VSTestReport" ReportPath="MyReports/VSTestReport" ReportServerUrl="http://pugrs/reportserver"/>

</rsweb:ReportViewer>


build fails with 401: Unauthorized.
Not even sure where to begin troubleshooting this one. Any ideas?
Thanks!

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.Net.WebException: The request failed with HTTP status 401: Unauthorized.

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:

[WebException: The request failed with HTTP status 401: Unauthorized.]
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +240
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +86
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname) +33
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +152
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean useCurrentValues) +138
Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +182
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1787
ok. got past the authentication problem... got a new one now:

The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply. > The path of the item "MyReports/VSTestReport" is not valid. The path must be less than 260 characters long and must not start with slash. Other restrictions apply.|||

I believe the problem is in the placement of your "/"

When naming the the server is should look like "http://localhost/reportserver"
then when naming the report path it would be "/MyReports/VSTestReport"

Good Luck
-JW

|||Hi PugV,

Got the same problem as you had with the authentication. It was probably pretty easy to solve but I'm a newbie so I'm glad for any help. What did you do to make it work? I have no clue where to begin searching for this one.

Thanks for your answer in advance.

Nat|||Thanks JW. -- adding a slash did work

the error message that says: The path must not start with slash, should probably be a bit more helpful ;)

|||

Nat.
We were playing with some domain accounts at the time, and the problem went away once we stopped. I have to assume that error had something to do with that -- I didn't do anything specific to resolve it.

|||Pugv,

I surely need your help TOO. I met the same "unauthorized" error. I cannot use this kind of url:
server: "http://localhost/reportserver"
report path:"/MyReports/VSTestReport"
because it will show 404 Not found error. I used:
server: "http://localhost/reportserver?"
report path:"/MyReports/VSTestReport"
and got the "unauthorized" error. Which version of visual studio are you using? I'm using 2005 beta 2.

I have tried different settings for the reportserver, even implemented IReportServerCredentials, but no luck at all. There is absolutely NO problem when I connect directly to http://localhost/reportserver?/MyReports/VSTestReport

using browser. But when using reportviewer, always "unauthorized". I'm crazy with it now. Can you post your exact codes so that I can try on my machine? Thanks.|||

Camms
I had the same trouble you did. This is what I did to make it work.

reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://localhost/reportserver");
reportViewer1.ServerReport.ReportPath = reportPath;
reportViewer1.RefreshReport();

-JW

|||could you tell me how you solved authentication problem?|||

i have the authentication problem too...

|||

I got it running by Just putting following

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

Height="400px" ProcessingMode="Remote" Width="400px">

<ServerReport ReportPath="/WebReport/warmup"

ReportServerUrl="http://localhost/reportserver" />

</rsweb:ReportViewer>

|||I think that as long you are doing it on localhost, it will work.

I am using a web app on another iss than the on hosting the sql2005.

I have to pass some authentication, but I need a step by step code example. Can anybody please please help?|||

I have the same problem

IIS / ASP.net on Server1, SQL Server 2005 Standard and Reporting Services on Server2

My web app uses forms authentication with the ASP.net SqlAuthenticationProvider. So my users are stored in a table in Sql Server 2005

How do I have to pass a authentication if I like to use the ReportViewer Control in my Website?

Thanks,

Dirk

|||

I am having the same problem, my Reporting Services is also in a different server.

Currently, if I open the the reporting services using a web browser it prompts for a windows login, which I think I need to pass the same information using a ReportViewer control inside a code.

Example:

ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
// Get the Report Server endpoint from the config file
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
ReportViewer1.ServerReport.ReportPath = "DailyCensus";

// Need to a code to pass the windows authentication....
//ReportViewer1.ServerReport.ReportServerCredentials

|||Anyone solved the problem with "401: Unauthorized" when viewing the reportViewer if WebServer and SSRS are in 2 servers?

ReportViewer Connection to Remote Server

Hello,
I have a ReportViewer placed in a webform in remote mode and am having a
difficult time getting it to connect to a remote 2005 Report Server.
I can connect to the report manager remotely; however, all my attempts at
connnecting a reportviewer to that same Report Server has failed.
I believe it has something to do with impersonation but everything I see is
in c# and I use vb.net.
A step by step tutorial using VB.NET would be great but I have been unable
to locate any.
Any suggestions?
Thanks,
JohnHello Steven,
>What's the error messge you got in the
> reportviewer control at runtime, is it a message indicate that the current
> security context doesn't have sufficient permission?
The request failed with HTTP status 401: Unauthorized.
> 1. Is the SSRS reportserver installed with default setting?(using
> integrated windows security in IIS) Also, have you ever customized the
> role based security setting of the certain report you want to access in
> reportviewer?
The SSRS is using integrated windows security in IIS and I have not
customized any role-based security in the report.
> 2. What's OS and IIS version of your ASP.NET web application's host
> machine? Is it IIS 5 or IIS6. If you haven't manually configured to use
> impersonate for your ASP.NET application, the reportViewer page will run
> under your ASP.NET application's process identity and use this identity to
> access the remote reportserver. For IIS6, ASP.NET process identity is
> configured in the application pool identity and the default value is "NT
> AUTHORITY\NETWORK SERVICE". As for IIS5, is still use the machine.config's
> <processModel> section for setting ASP.NET process identity and the default
> value is machine\ASPNET. The following msdn article also described on
> configuring ASP.NET process identity:
> #Configuring ASP.NET Process Identity
> http://msdn2.microsoft.com/en-us/library/dwc1xthy.aspx
> And in your page you can use the following code snippet to printout the
> current security identity:
> =============> protected void Page_Load(object sender, EventArgs e)
> {
> Response.Write("<br/>Identity: " +
> System.Security.Principal.WindowsIdentity.GetCurrent().Name);
> }
> =============
I am currently developing on a WinXP Pro OS and trying to connect to the
SSRS 2005 on a Windows 2003 Standard OS. I will eventually need to move my
application to a production web server that is running Windows 2003 Web
Edition and connecting to a SSRS 2005 installation on a remote Windows
Standard 2003 server.
I tried changing the identity in the machine.config; however, no matter what
I change it to I get a response.write computername\mywindowsloginname when I
run in the integrated file based development environment. If I launch it from
IIS5 I get computername\ASPNET.
I can not go any further in your steps until I get this resolved.
Thanks,
John
"Steven Cheng[MSFT]" wrote:
> Hello John,
> Thank you for posting in the MSDN newsgroup.
> From your description, I understand you're developing an ASP.NET
> application which use the webform reportViewer control to access and
> display some server-reports from the SSRS 2005 reportserver. However, you
> found that the reportviewer always failed to connect to the
> reportserver(server report), correct? If there is anything I missed, please
> feel free to let me know.
> As for this problem, based on my experience, it is likely cause by security
> permission setting issue. What's the error messge you got in the
> reportviewer control at runtime, is it a message indicate that the current
> security context doesn't have sufficient permission? First, I'd like to
> confrim some environment info about the problem server machine and the
> reportserver with you:
> 1. Is the SSRS reportserver installed with default setting?(using
> integrated windows security in IIS) Also, have you ever customized the
> role based security setting of the certain report you want to access in
> reportviewer?
> 2. What's OS and IIS version of your ASP.NET web application's host
> machine? Is it IIS 5 or IIS6. If you haven't manually configured to use
> impersonate for your ASP.NET application, the reportViewer page will run
> under your ASP.NET application's process identity and use this identity to
> access the remote reportserver. For IIS6, ASP.NET process identity is
> configured in the application pool identity and the default value is "NT
> AUTHORITY\NETWORK SERVICE". As for IIS5, is still use the machine.config's
> <processModel> section for setting ASP.NET process identity and the default
> value is machine\ASPNET. The following msdn article also described on
> configuring ASP.NET process identity:
> #Configuring ASP.NET Process Identity
> http://msdn2.microsoft.com/en-us/library/dwc1xthy.aspx
> And in your page you can use the following code snippet to printout the
> current security identity:
> =============> protected void Page_Load(object sender, EventArgs e)
> {
> Response.Write("<br/>Identity: " +
> System.Security.Principal.WindowsIdentity.GetCurrent().Name);
> }
> =============>
> 3. After you've detect and ensure the running security identity of your
> ASP.NET application(the one reportviewer will use to access the remote
> report server). You can consider the role based permission setting on the
> remote reportServer. First, you should check whether the security identity
> can be identified and recognized on the remote reportserver machine. for
> example, the "NT AUTHORITY\NETWORK SERVICE" account is recognized as the
> machine's account on remote machine in windows domain. After you've
> verified that the identity can be recognized as a valid account on the
> remote reportserver, you should grant that account the sufficient
> permission to access that report. Generally, since we only view the report,
> so the "browser" role is sufficient. You can grant certain user/group one
> or more roles through the ReportManager or SQL Server management studio.
> Here are some resources on SSRS 2005 role based security managment:
> #Using Role-Based Security
> http://msdn2.microsoft.com/en-us/library/ms156014.aspx
> #Role Assignments
> http://msdn2.microsoft.com/en-us/library/ms156406.aspx
> #Creating, Modifying, and Deleting Role Definitions
> http://msdn2.microsoft.com/en-us/library/ms156264.aspx
> And I've also attached a screenshot of the role management interface in the
> ReportManager web application(grant a certain user with certain role).
> If you have anything unclear on the above things or if there is any further
> questions, please feel free to let me know.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> ==================================================> 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 John,
Thanks for your response.
From your further description, I've got that your current development
machine is a winxp box and the error you got is a "401 unauthorized" error.
I think this is due to the security identity passed from your XP dev box is
not recognizable in the reportserver machine(2003 test server). Here is my
understanding and analysis on the following symptom you described:
===============I tried changing the identity in the machine.config; however, no matter
what
I change it to I get a response.write computername\mywindowsloginname when
I
run in the integrated file based development environment. If I launch it
from
IIS5 I get computername\ASPNET.
===============
At first, when you change different identities in the machine.config, since
you're developing through the VS 2005 built-in tes webserver/File system
based project), the ASP.NET application is always running in the test
server and will run under your current logon user accountand.(That's why
you always see the "computername\mylogonuser") Thus, the reportViewer will
use this identity to access remote server report, surely this local account
is not valid on the remote reportserver machine(different machine) and the
IIS windows authentication will fail with 401.
Again, when you host the ASP.NET application in IIS, it will use the
ASP.NET worker process identity which is configured in the <processModel>
element in machine.config, and by default it is "machine\ASPNET". And this
account is also a machine specfic local account, therefore it is also
invalid when the reportviewer use the it to access the remote reportserver.
To resolve this, you can consider the following possible means:
1. When deveoping use Test web server, logon with a domain account (have
sufficient permission on the devbox) which is also recognizable on the
remote reportserver machine. This require that both machines are in the
same local domain.
2. Still developing use the test webserver, and still logon with a local
account. However, you need to create a duplicated local account on the
remote reportserver machine(with the same username and password). This can
make your local account on XP dev machine also recognizable(be
authenticated) on the remote reportserver machine. This is a workable
solution for all windows system use NTLM authentication.
3. If you will use IIS host ASP.NET application, then just change the
account in the <processModel> element in machine.config. And which account
to use also reference to the #1 and #2
BTW, when you finally move the ASP.NET application to a windows 2003
server, since IIS6 use application pool to configure worker process
identity and it use "NetworkService" account by default(this account is
recognized as the server's machine account on other remote machines in the
same domain), it'll be eaiser for you to configure the security setting if
your machines are in a domain environment.
Please feel free to let me know if there is anything unclear or if you
still have any other concerns on this.
Regards,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
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.|||Hello Steven,
I added a user account to the remote server with my local machine's username
and password. I gave that user Administrative priveledges. Also, my local and
my remote computers are on two seperate domains.
I am no longer getting the error:
The request failed with HTTP status 401: Unauthorized.
I am now getting the following error:
The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version.
The request failed with HTTP status 404: Not Found.
If I change the password on the remote server to be different than my local
password, I once again get the 401 unauthorized error. It therefore seems to
me that I am little farther.
What would you suggest?
Thanks,
John
"Steven Cheng[MSFT]" wrote:
> Hello John,
> Thanks for your response.
> From your further description, I've got that your current development
> machine is a winxp box and the error you got is a "401 unauthorized" error.
> I think this is due to the security identity passed from your XP dev box is
> not recognizable in the reportserver machine(2003 test server). Here is my
> understanding and analysis on the following symptom you described:
> ===============> I tried changing the identity in the machine.config; however, no matter
> what
> I change it to I get a response.write computername\mywindowsloginname when
> I
> run in the integrated file based development environment. If I launch it
> from
> IIS5 I get computername\ASPNET.
> ===============> At first, when you change different identities in the machine.config, since
> you're developing through the VS 2005 built-in tes webserver/File system
> based project), the ASP.NET application is always running in the test
> server and will run under your current logon user accountand.(That's why
> you always see the "computername\mylogonuser") Thus, the reportViewer will
> use this identity to access remote server report, surely this local account
> is not valid on the remote reportserver machine(different machine) and the
> IIS windows authentication will fail with 401.
> Again, when you host the ASP.NET application in IIS, it will use the
> ASP.NET worker process identity which is configured in the <processModel>
> element in machine.config, and by default it is "machine\ASPNET". And this
> account is also a machine specfic local account, therefore it is also
> invalid when the reportviewer use the it to access the remote reportserver.
>
> To resolve this, you can consider the following possible means:
> 1. When deveoping use Test web server, logon with a domain account (have
> sufficient permission on the devbox) which is also recognizable on the
> remote reportserver machine. This require that both machines are in the
> same local domain.
> 2. Still developing use the test webserver, and still logon with a local
> account. However, you need to create a duplicated local account on the
> remote reportserver machine(with the same username and password). This can
> make your local account on XP dev machine also recognizable(be
> authenticated) on the remote reportserver machine. This is a workable
> solution for all windows system use NTLM authentication.
> 3. If you will use IIS host ASP.NET application, then just change the
> account in the <processModel> element in machine.config. And which account
> to use also reference to the #1 and #2
> BTW, when you finally move the ASP.NET application to a windows 2003
> server, since IIS6 use application pool to configure worker process
> identity and it use "NetworkService" account by default(this account is
> recognized as the server's machine account on other remote machines in the
> same domain), it'll be eaiser for you to configure the security setting if
> your machines are in a domain environment.
> Please feel free to let me know if there is anything unclear or if you
> still have any other concerns on this.
> Regards,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> ==================================================> 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.
>
>
>
>
>|||Thanks for your followup John,
I thank we've made some progress on this. As you can find the remote server
now correctly recognize and validate the user on your cilent dev machine
and no longer display the 401 error, you can also check the IIS server's
log to see whether it list the client user's username in the request log
entry.
For the new problem you mentioned, I think it is somewhat specific to the
reportServer (server-side configuration). Have you tried directly use the
IE browser to visit that report in reportserver(not reportManager)? And
you can test by using the same account as you developed in VS IDE to access
that server report in IE browser(on XP dev box ) to see whether it report
the same error. The reportserver's url is like below by default:
Http://servername/reportserver/
Please let me know what you get on this. If convenient, you can also attach
some screenshot on the error.
Looking forward to your reply.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Steven,
I have no problems connecting to the remote ReportServer or ReportManager
from a browser.
Thanks,
John
"Steven Cheng[MSFT]" wrote:
> Thanks for your followup John,
> I thank we've made some progress on this. As you can find the remote server
> now correctly recognize and validate the user on your cilent dev machine
> and no longer display the 401 error, you can also check the IIS server's
> log to see whether it list the client user's username in the request log
> entry.
> For the new problem you mentioned, I think it is somewhat specific to the
> reportServer (server-side configuration). Have you tried directly use the
> IE browser to visit that report in reportserver(not reportManager)? And
> you can test by using the same account as you developed in VS IDE to access
> that server report in IE browser(on XP dev box ) to see whether it report
> the same error. The reportserver's url is like below by default:
> Http://servername/reportserver/
> Please let me know what you get on this. If convenient, you can also attach
> some screenshot on the error.
> Looking forward to your reply.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Thanks for your reply John,
Since you can visit the reportserver correctly through webbrowser, the
problem should be specific to the reportviewer control. Based on my
investigation, the reportViewer control internally use a pregenerated
webservice proxy to call the reportserver's webservice (the ReportService
and ReportExecutionService), so we may perform some test against the
webservice call to the remote reportserver. To do this, you can still use
your ASP.NET web application (running under the certain user account that
has mapped account on remote server), add the webreference to the reporting
service webservice:
#Report Server Web Service
http://msdn2.microsoft.com/en-us/library/ms152787.aspx
You can reference the two main reporting service webservices through the
following two endpoints under the reportserver web root:
ReportService2005.asmx
ReportExecution2005.asmx
So, the url will be like:
http://servername/reportserver/ReportService2005.asmx or
http://servername/reportserver/ReportExecution2005.asmx
Please try calling some methods on it to see whether your ASP.NET
application can correctly consume the webmethods. You can also check the
reportserver's log files to see what's the error generated when your client
ASP.NET application fails to access it.
BTW, I've also found some other former issue which had the similar symptom
with yours. In those cases, their reportServer application's IIS virtual
directory or IIS site is using a custom host header(dosn't use the default
website/machine name). And we need to check the some URL settings(like the
reportserver virtual directory, UrlRoot ...) in the
RsWebApplication.config file, you can find those setting in the following
BOL reference:
#RSWebApplication Configuration File
http://msdn2.microsoft.com/en-us/library/ms155878.aspx
Based on my local test, the <UrlRoot> element in the rsreportserver.config
file should be conform to your reportserver's external url(to other
machines).
<UrlRoot>http://myservermachine/reportserver</UrlRoot>
the file is under the reportserver application directory(C:\Program
Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer)
Here are some related threads over the internet discussing on the similar
issue:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=256312&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=256312&SiteID=1
Hope this helps. If you there is anything unclear or have any further
question, please feel free to post here.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Steven,
I too am having the same problem. I''m getting the error: The request failed
with HTTP status 401: Unauthorized.
I'm very sure this is happening because I am not passing my Credentials to
the ReportViewer Control. I cannot seem to get the syntax correct.
Here is how I did it using the rs.render method:
Dim strUserName_Dev As String =System.Configuration.ConfigurationManager.AppSettings("UserName_Dev")
Dim strPWD_Dev As String =System.Configuration.ConfigurationManager.AppSettings("PWD_Dev")
Dim strDomain_Dev As String =System.Configuration.ConfigurationManager.AppSettings("Domain_Dev")
RS.Credentials = New System.Net.NetworkCredential(strUserName_Dev,
strPWD_Dev, strDomain_Dev)
Dim data As Byte()
data = RS_Dev.Render(Path2, Format, Nothing, Nothing, Parameters, _
Nothing, Nothing, Encoding, MimeType,
ParametersUsed, _
Warnings, StreamIDs)
The above methods works very well when I'm sending the output to a binary
stream or writer.
I need to now use the ReportViewer Control.
Can you please help me assign the same credentials to the ReportViewer
Control? I cannot figure out the syntax. Here is what I'm trying:
Getting the credentials:
RS.Credentials = New System.Net.NetworkCredential(strUserName_Dev,
strPWD_Dev, strDomain_Dev)
ReportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials =RS.credentials
I get a compile error telling me this is a Read Only Property.
I'm not sure what to do next.
Thanks,
Rwiethorn
"Steven Cheng[MSFT]" wrote:
> Thanks for your reply John,
> Since you can visit the reportserver correctly through webbrowser, the
> problem should be specific to the reportviewer control. Based on my
> investigation, the reportViewer control internally use a pregenerated
> webservice proxy to call the reportserver's webservice (the ReportService
> and ReportExecutionService), so we may perform some test against the
> webservice call to the remote reportserver. To do this, you can still use
> your ASP.NET web application (running under the certain user account that
> has mapped account on remote server), add the webreference to the reporting
> service webservice:
> #Report Server Web Service
> http://msdn2.microsoft.com/en-us/library/ms152787.aspx
> You can reference the two main reporting service webservices through the
> following two endpoints under the reportserver web root:
> ReportService2005.asmx
> ReportExecution2005.asmx
> So, the url will be like:
> http://servername/reportserver/ReportService2005.asmx or
> http://servername/reportserver/ReportExecution2005.asmx
> Please try calling some methods on it to see whether your ASP.NET
> application can correctly consume the webmethods. You can also check the
> reportserver's log files to see what's the error generated when your client
> ASP.NET application fails to access it.
> BTW, I've also found some other former issue which had the similar symptom
> with yours. In those cases, their reportServer application's IIS virtual
> directory or IIS site is using a custom host header(dosn't use the default
> website/machine name). And we need to check the some URL settings(like the
> reportserver virtual directory, UrlRoot ...) in the
> RsWebApplication.config file, you can find those setting in the following
> BOL reference:
> #RSWebApplication Configuration File
> http://msdn2.microsoft.com/en-us/library/ms155878.aspx
> Based on my local test, the <UrlRoot> element in the rsreportserver.config
> file should be conform to your reportserver's external url(to other
> machines).
> <UrlRoot>http://myservermachine/reportserver</UrlRoot>
> the file is under the reportserver application directory(C:\Program
> Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer)
> Here are some related threads over the internet discussing on the similar
> issue:
>
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=256312&SiteID=1
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=256312&SiteID=1
> Hope this helps. If you there is anything unclear or have any further
> question, please feel free to post here.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Hello Steven,
I still haven't had any luck; however, the Report Services was not set up to
a default install. I am going to reinstall and see if that helps.
Thanks,
John
"Steven Cheng[MSFT]" wrote:
> Thanks for your reply John,
> Since you can visit the reportserver correctly through webbrowser, the
> problem should be specific to the reportviewer control. Based on my
> investigation, the reportViewer control internally use a pregenerated
> webservice proxy to call the reportserver's webservice (the ReportService
> and ReportExecutionService), so we may perform some test against the
> webservice call to the remote reportserver. To do this, you can still use
> your ASP.NET web application (running under the certain user account that
> has mapped account on remote server), add the webreference to the reporting
> service webservice:
> #Report Server Web Service
> http://msdn2.microsoft.com/en-us/library/ms152787.aspx
> You can reference the two main reporting service webservices through the
> following two endpoints under the reportserver web root:
> ReportService2005.asmx
> ReportExecution2005.asmx
> So, the url will be like:
> http://servername/reportserver/ReportService2005.asmx or
> http://servername/reportserver/ReportExecution2005.asmx
> Please try calling some methods on it to see whether your ASP.NET
> application can correctly consume the webmethods. You can also check the
> reportserver's log files to see what's the error generated when your client
> ASP.NET application fails to access it.
> BTW, I've also found some other former issue which had the similar symptom
> with yours. In those cases, their reportServer application's IIS virtual
> directory or IIS site is using a custom host header(dosn't use the default
> website/machine name). And we need to check the some URL settings(like the
> reportserver virtual directory, UrlRoot ...) in the
> RsWebApplication.config file, you can find those setting in the following
> BOL reference:
> #RSWebApplication Configuration File
> http://msdn2.microsoft.com/en-us/library/ms155878.aspx
> Based on my local test, the <UrlRoot> element in the rsreportserver.config
> file should be conform to your reportserver's external url(to other
> machines).
> <UrlRoot>http://myservermachine/reportserver</UrlRoot>
> the file is under the reportserver application directory(C:\Program
> Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer)
> Here are some related threads over the internet discussing on the similar
> issue:
>
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=256312&SiteID=1
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=256312&SiteID=1
> Hope this helps. If you there is anything unclear or have any further
> question, please feel free to post here.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Thanks for your followup John,
I think the non-default installed location of the webservice could be the
potential cause as the configuration file of reportserver contains some
settings that identitfy the webservice's url(virtual directory or server
url).
Before you performing the reinstall, I still suggest you have a look at the
following threads and tried the settings mentioned there:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=256312&SiteID=1
#Installing Microsoft SQL Server 2005 Reporting Services on a non-default
web site.
http://www.mathgv.com/sql2005docs/SQL2005ReportingServicesInstall.htm
Hope that also helps.
If you meet any further problem or need any assistance, please feel free to
let me know.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Rwiethorn,
Yes, 401 error indicate that the supplied credential (security identity) is
not valid. What's your client appilcation(calling the SSRS webservice)'s
type, winform or asp.net? You can first try changing your client
appliation's security identity to a valid account which is recognizable on
the remote server to see whether it works.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||Steven Thanks for your response.
To answer your questions:
>What's your client application(calling the SSRS webservice)'s type, winform or
asp.net?
Its an ASP.NET application.
>You can first try changing your client applicationâ's security identity to a valid account which is recognizable on the remote server to see whether it works.
I've done that using the SOAP API Render method, and rendering the report to
a Response Object works perfectly. (Response.BinaryWrite(data))
When I use the SOAP method, I assign credentials to the RS object via this
method:
RS.Credentials = New System.Net.NetworkCredential(â'MyNameâ', â'MyPWDâ',
â'MyDomainâ')
Then proceed to assign the other propeties ie: parameters, and call the
Render method of the RS object as so:
data = RS.Render(Path2, Format, Nothing, Nothing, Parameters, Nothing,
Nothing, Encoding, MimeType, ParametersUsed, Warnings, StreamIDs)
When I try to use the ReportViewer Control, Iâ'm getting an error: â'Unable to
cast object of type 'System.Net.NetworkCredential' to type
'Microsoft.Reporting.WebForms.IReportServerCredentials'â'. From the following
lines of code:
Dim RC As New NetworkCredential("strUserName_Dev", "strPWD_Dev",
"strDomain_Dev")
ReportViewer1.ServerReport.ReportServerCredentials = RC
ReportViewer1.ServerReport.ReportPath = "/PA/CASNO_with_UNASSIGNED"
ReportViewer1.ServerReport.Refresh()
Iâ've also tried:
Dim CC As New System.Net.CredentialCache
CC.Add(New
Uri("http://bdcintra557.internal.pg.com/ReportServer$SQL2005/ReportService.asmx"),
"Digest", New System.Net.NetworkCredential("strUserName_Dev", "strPWD_Dev",
"strDomain_Dev"))
ReportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = CC
ReportViewer1.ServerReport.ReportPath = "/PA/CASNO_with_UNASSIGNED"
ReportViewer1.ServerReport.Refresh()
But I get an error trying to assign the CredentialCache to the ReporViewer
Control: Property 'NetworkCredentials' is 'ReadOnly'
I need help to assign these same NetworkCredentials to the ReportViewer
Control.
I just donâ't know the VB syntax to do it; Iâ'm not a very strong programmer.
Thanks,
Robert Wiethorn
rwiethorn
"Steven Cheng[MSFT]" wrote:
> Hello Rwiethorn,
> Yes, 401 error indicate that the supplied credential (security identity) is
> not valid. What's your client appilcation(calling the SSRS webservice)'s
> type, winform or asp.net? You can first try changing your client
> appliation's security identity to a valid account which is recognizable on
> the remote server to see whether it works.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
>|||Hello Robert,
AS for the ReportViewer's Credential property, you can not directly use the
System.Net.NetworkCredential class, you need to implement a custom
IReportCredential interface's concrete class. Here is a previous thread in
which I've provided a sample IReportCredential implementation:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/brow
se_thread/thread/359cd6fce6f3ab37/dadf62fe2aed9f87?lnk=st&q=&rnum=1&hl=en#da
df62fe2aed9f87
In addition, do you think it's also possible that we programmatically
imerpsonate the ASP.NET worker thread as a specific user(which has
sufficient permission on the remote server)? If so, you can
programmtically impersonate in the reportviewer page (as a specific
account) so that you do not need to implement a custom ReportCredential
class. For programmtic impersonate in ASP.NET, please refer to the
following kb:
#How to implement impersonation in an ASP.NET application
http://support.microsoft.com/kb/306158/en-us
Hope this helps.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||Steven,
Thanks for the info, and all I can say is wow, thats going deep, but I got
it to work, I'll paste the code that I found after following a couple of
links:
Public Class MyReportViewerCredentials
Implements IReportServerCredentials
Private _userName As String
Private _password As String
Private _domain As String
Public Sub New(ByVal userName As String, ByVal password As String, ByVal
domain As String)
_userName = userName
_password = password
_domain = domain
End Sub
Public ReadOnly Property ImpersonationUser() As
System.Security.Principal.WindowsIdentity Implements
Microsoft.Reporting.WebForms.IReportServerCredentials.ImpersonationUser
Get
Return Nothing
End Get
End Property
Public ReadOnly Property NetworkCredentials() As System.Net.ICredentials
Implements
Microsoft.Reporting.WebForms.IReportServerCredentials.NetworkCredentials
Get
Return New Net.NetworkCredential(_userName, _password, _domain)
End Get
End Property
Public Function GetFormsCredentials(ByRef authCookie As
System.Net.Cookie, ByRef userName As String, ByRef password As String, ByRef
authority As String) As Boolean Implements
Microsoft.Reporting.WebForms.IReportServerCredentials.GetFormsCredentials
userName = _userName
password = _password
authority = _domain
Return Nothing
End Function
End Class
I then call that class in using:
ReportViewer1.ServerReport.ReportServerCredentials = New
MyReportViewerCredentials(strUserName_Dev, strPWD_Dev, strDomain_Dev)
ReportViewer1.ServerReport.Refresh()
Here is the link I found:
http://forums.asp.net/thread/1271383.aspx
Thanks for the help.
rwiethorn
"Steven Cheng[MSFT]" wrote:
> Hello Robert,
> AS for the ReportViewer's Credential property, you can not directly use the
> System.Net.NetworkCredential class, you need to implement a custom
> IReportCredential interface's concrete class. Here is a previous thread in
> which I've provided a sample IReportCredential implementation:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/brow
> se_thread/thread/359cd6fce6f3ab37/dadf62fe2aed9f87?lnk=st&q=&rnum=1&hl=en#da
> df62fe2aed9f87
> In addition, do you think it's also possible that we programmatically
> imerpsonate the ASP.NET worker thread as a specific user(which has
> sufficient permission on the remote server)? If so, you can
> programmtically impersonate in the reportviewer page (as a specific
> account) so that you do not need to implement a custom ReportCredential
> class. For programmtic impersonate in ASP.NET, please refer to the
> following kb:
> #How to implement impersonation in an ASP.NET application
> http://support.microsoft.com/kb/306158/en-us
> Hope this helps.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
>|||Thanks for the followup Robert,
Glad that you've got it working.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead|||Hello Steven,
I finally got this to work.
I had to change the Report Server URL to http://IPADDRESS/Reportserver from
http://IPADDRESS/Reports
I also was then able to set my credentials up using the information from
Rwiethorn's posts.
Thank you for the help.
John
"Steven Cheng[MSFT]" wrote:
> Thanks for your followup John,
> I think the non-default installed location of the webservice could be the
> potential cause as the configuration file of reportserver contains some
> settings that identitfy the webservice's url(virtual directory or server
> url).
> Before you performing the reinstall, I still suggest you have a look at the
> following threads and tried the settings mentioned there:
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=256312&SiteID=1
>
> #Installing Microsoft SQL Server 2005 Reporting Services on a non-default
> web site.
> http://www.mathgv.com/sql2005docs/SQL2005ReportingServicesInstall.htm
>
> Hope that also helps.
> If you meet any further problem or need any assistance, please feel free to
> let me know.
>
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi John,
Thanks for the followup and glad that you've got it working.
Have a good day!
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.

Friday, March 23, 2012

ReportServer Problem

Hi!
I get suddenly the following error when accessing the error:
"The underlying connection was closed: Unable to connect to the remote
server."
The configuration has not been changed.....!?!
Greets
ChrisHello'
Noone knows an answer?
greetz
chris
"Christian Weber" <avbc.def@.ghi.de> wrote in message
news:cdqjei$1a7$1@.papyrus.erlm.siemens.de...
> Hi!
> I get suddenly the following error when accessing the error:
> "The underlying connection was closed: Unable to connect to the remote
> server."
> The configuration has not been changed.....!?!
> Greets
> Chris
>|||Sorry, I will be no help here. I have the same problem. It just magically
happened when I came to work this Monday. Everything was working normally
when I left Friday. No configuration changes have been done.
The only good thing is I can still render reports through the web service.
So this is an annoyance but thankfully my application is still working for
now.
If I go to:
http://reportserver/reports/
I get the exact same error you got.
If I go to:
http://reportserver/reportserver/
everything works fine and I see folders and links to previously uploaded
reports. I can also run reports from here.
My reporting services app runs on Windows 2003 Server. It is on a separate
server from SQL Server 2000 Standard which is also a Windows 2003 Server. I
have been running Reporting Services SP1 for a few weeks now. I do not think
that Windows XP SP2 has been applied to the servers by the sysadmins yet.
If you solve this yourself or find the solution could you please reply to
this thread. I will do that same for you.
Jeff
"Christian Weber" wrote:
> Hello'
> Noone knows an answer?
> greetz
> chris
> "Christian Weber" <avbc.def@.ghi.de> wrote in message
> news:cdqjei$1a7$1@.papyrus.erlm.siemens.de...
> > Hi!
> >
> > I get suddenly the following error when accessing the error:
> >
> > "The underlying connection was closed: Unable to connect to the remote
> > server."
> >
> > The configuration has not been changed.....!?!
> >
> > Greets
> >
> > Chris
> >
> >
>
>sql

Wednesday, March 21, 2012

ReportServer DB blocking !

Hi There

I have installed Reporting Services 2005 on a server, this uses a remote ReportServer Database on a Sql Server 2000 instance.

Everything has been working fine until a few days ago, i am picking up long blocking in the 2005 ReportServer database.

Up to 3-4 minutes.

The blocking is occuring on table locks on the "Keys" and "SnapshotData" tables in the report server database.

Now as a dba all i can see is the 2 spid's that are involved in the blocking, the spid that is blocking is at the time not doing anything, it is waititng while holding these locks.

I have a feeling this is due to long running reports, but iam not so sure because long running reports are a fact of life , i do not see how they should block other report user on ReportServer system tables ?

However how do i troubleshoot this? I dont know how to link these spids in sql server to reports being run , or to prove or disprove that his is due to long running reports ?

In other words how do i trouble shoot blocking in the reportserver database ?

Thanx

I've experienced the same problem. I contacted microsoft support regarding the issue, but they haven't found the solution.|||

Hi

Please keep me updated if you receive any feedback, i was going to open a case myself.

Thank You

Monday, March 12, 2012

Reports broke from remote

Hello
Recently this one report errors as below when running on any machine except
the actual server hosting the
reporting services.
a.. An error has occurred during report processing.
a.. Cannot create a connection to data source 'databasename.
a.. For more information about this error navigate to the report
server on the local server machine, or enable remote errors
They did recently change the name of the machine hosting the datasource, but
it shows up OK
in RS config manager.
Anything else I could look at?
Regards
CTCheck out the credentials for the report datasource. I always use shared
datasources but perhaps this report uses a report specific datasource that
has a problem.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MSNewsGroup" <Cal@.obded.org> wrote in message
news:eYZ0uws0HHA.3848@.TK2MSFTNGP03.phx.gbl...
> Hello
> Recently this one report errors as below when running on any machine
> except the actual server hosting the
> reporting services.
> a.. An error has occurred during report processing.
> a.. Cannot create a connection to data source 'databasename.
> a.. For more information about this error navigate to the report
> server on the local server machine, or enable remote errors
> They did recently change the name of the machine hosting the datasource,
> but it shows up OK
> in RS config manager.
> Anything else I could look at?
> Regards
> CT
>|||Could that be if it works on the machine hosting RS?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:e3Ywj7s0HHA.464@.TK2MSFTNGP02.phx.gbl...
> Check out the credentials for the report datasource. I always use shared
> datasources but perhaps this report uses a report specific datasource that
> has a problem.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "MSNewsGroup" <Cal@.obded.org> wrote in message
> news:eYZ0uws0HHA.3848@.TK2MSFTNGP03.phx.gbl...
>> Hello
>> Recently this one report errors as below when running on any machine
>> except the actual server hosting the
>> reporting services.
>> a.. An error has occurred during report processing.
>> a.. Cannot create a connection to data source 'databasename.
>> a.. For more information about this error navigate to the report
>> server on the local server machine, or enable remote errors
>> They did recently change the name of the machine hosting the datasource,
>> but it shows up OK
>> in RS config manager.
>> Anything else I could look at?
>> Regards
>> CT
>|||It depends on how the credentials are configured. Check and see if it is
using a shared datasource or report datasource. If report datasource compare
how its credentials are setup compared to a report datasource/shared
datasource that works.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MSNewsGroup" <Cal@.obded.org> wrote in message
news:%23ag1lpt0HHA.4824@.TK2MSFTNGP02.phx.gbl...
> Could that be if it works on the machine hosting RS?
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:e3Ywj7s0HHA.464@.TK2MSFTNGP02.phx.gbl...
>> Check out the credentials for the report datasource. I always use shared
>> datasources but perhaps this report uses a report specific datasource
>> that has a problem.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "MSNewsGroup" <Cal@.obded.org> wrote in message
>> news:eYZ0uws0HHA.3848@.TK2MSFTNGP03.phx.gbl...
>> Hello
>> Recently this one report errors as below when running on any machine
>> except the actual server hosting the
>> reporting services.
>> a.. An error has occurred during report processing.
>> a.. Cannot create a connection to data source 'databasename.
>> a.. For more information about this error navigate to the report
>> server on the local server machine, or enable remote errors
>> They did recently change the name of the machine hosting the datasource,
>> but it shows up OK
>> in RS config manager.
>> Anything else I could look at?
>> Regards
>> CT
>>
>