Problem with Resporting services on sharepoint: Server Error in '/' Application.

Hi,

I have a problem with Resporting services on sharepoint. My local host machine reporting services is ok though.

The problem is when I click on "properties" button on sharepoint reporting services, and when I click on Parameters, Data Sources, Execution, and other bottons on the left hand side, I get the following error:

Server Error in '/' Application.

---

The resource cannot be found.

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested Url: /Reports/Pages/Report.aspx

Does anybody know how to fix this?

Thanks,

Yes, this is a common problem with sharepoint installed on the Report Server. Sharepoint claims all HTTP request for itself and used therefore its own HTTP handler, the request won′t get further to Reporting Services, it will be caught by SPS. To fix this problem, you can define excluded path which "excludes" the path for the SPS Http Handler und lets it through to the other HTTP Handler.

YOu can find these settings under the Central administation of Sharepoint. I f I have time this weekend, I will record a screencast for that and publish that on my site under the section Screencasts.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks. Please do That!

I NEED HELP!!!!

|||

Goods news Alexan,

after several hours I finished the screencast. Look in the screencast section on my site. Would be nice to have some feedback what you are thinking about that and if that helped.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I see only three previous screencasts. Are you sure you uploaded it?

|||Look in the screencast section, not the announcements.

HTH, Jens Suessmeyer.

http://www.sqlserver0205.de|||Was the Screencast helpful ?|||

Thank you very much for all that Jens.

I showed it to my supervisor and he said he already tried that (excluded them) but it didn't work for him, so he is probably going to reinstall sharepoint and reporting server again.

I appreciate your help and support anyway.

Sincerely,

Alexan

|||I know this is late, but I have just posted an entry on my blog that helps for some of this configuration... http://portal.sqltrainer.com/Lists/Posts/Post.aspx?ID=11

Problem with Resporting services on sharepoint: Server Error in '/' Application.

Hi,

I have a problem with Resporting services on sharepoint. My local host machine reporting services is ok though.

The problem is when I click on "properties" button on sharepoint reporting services, and when I click on Parameters, Data Sources, Execution, and other bottons on the left hand side, I get the following error:

Server Error in '/' Application.

---

The resource cannot be found.

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested Url: /Reports/Pages/Report.aspx

Does anybody know how to fix this?

Thanks,

Yes, this is a common problem with sharepoint installed on the Report Server. Sharepoint claims all HTTP request for itself and used therefore its own HTTP handler, the request won′t get further to Reporting Services, it will be caught by SPS. To fix this problem, you can define excluded path which "excludes" the path for the SPS Http Handler und lets it through to the other HTTP Handler.

YOu can find these settings under the Central administation of Sharepoint. I f I have time this weekend, I will record a screencast for that and publish that on my site under the section Screencasts.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks. Please do That!

I NEED HELP!!!!

|||

Goods news Alexan,

after several hours I finished the screencast. Look in the screencast section on my site. Would be nice to have some feedback what you are thinking about that and if that helped.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I see only three previous screencasts. Are you sure you uploaded it?

|||Look in the screencast section, not the announcements.

HTH, Jens Suessmeyer.

http://www.sqlserver0205.de|||Was the Screencast helpful ?|||

Thank you very much for all that Jens.

I showed it to my supervisor and he said he already tried that (excluded them) but it didn't work for him, so he is probably going to reinstall sharepoint and reporting server again.

I appreciate your help and support anyway.

Sincerely,

Alexan

|||I know this is late, but I have just posted an entry on my blog that helps for some of this configuration... http://portal.sqltrainer.com/Lists/Posts/Post.aspx?ID=11

Problem with Resporting services on sharepoint: Server Error in '/' Application.

Hi,

I have a problem with Resporting services on sharepoint. My local host machine reporting services is ok though.

The problem is when I click on "properties" button on sharepoint reporting services, and when I click on Parameters, Data Sources, Execution, and other bottons on the left hand side, I get the following error:

Server Error in '/' Application.

---

The resource cannot be found.

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested Url: /Reports/Pages/Report.aspx

Does anybody know how to fix this?

Thanks,

Yes, this is a common problem with sharepoint installed on the Report Server. Sharepoint claims all HTTP request for itself and used therefore its own HTTP handler, the request won′t get further to Reporting Services, it will be caught by SPS. To fix this problem, you can define excluded path which "excludes" the path for the SPS Http Handler und lets it through to the other HTTP Handler.

YOu can find these settings under the Central administation of Sharepoint. I f I have time this weekend, I will record a screencast for that and publish that on my site under the section Screencasts.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks. Please do That!

I NEED HELP!!!!

|||

Goods news Alexan,

after several hours I finished the screencast. Look in the screencast section on my site. Would be nice to have some feedback what you are thinking about that and if that helped.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I see only three previous screencasts. Are you sure you uploaded it?

|||Look in the screencast section, not the announcements.

HTH, Jens Suessmeyer.

http://www.sqlserver0205.de|||Was the Screencast helpful ?|||

Thank you very much for all that Jens.

I showed it to my supervisor and he said he already tried that (excluded them) but it didn't work for him, so he is probably going to reinstall sharepoint and reporting server again.

I appreciate your help and support anyway.

Sincerely,

Alexan

|||I know this is late, but I have just posted an entry on my blog that helps for some of this configuration... http://portal.sqltrainer.com/Lists/Posts/Post.aspx?ID=11

Problem with Resporting services on sharepoint: Server Error in '/' Application.

Hi,

I have a problem with Resporting services on sharepoint. My local host machine reporting services is ok though.

The problem is when I click on "properties" button on sharepoint reporting services, and when I click on Parameters, Data Sources, Execution, and other bottons on the left hand side, I get the following error:

Server Error in '/' Application.

---

The resource cannot be found.

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested Url: /Reports/Pages/Report.aspx

Does anybody know how to fix this?

Thanks,

Yes, this is a common problem with sharepoint installed on the Report Server. Sharepoint claims all HTTP request for itself and used therefore its own HTTP handler, the request won′t get further to Reporting Services, it will be caught by SPS. To fix this problem, you can define excluded path which "excludes" the path for the SPS Http Handler und lets it through to the other HTTP Handler.

YOu can find these settings under the Central administation of Sharepoint. I f I have time this weekend, I will record a screencast for that and publish that on my site under the section Screencasts.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks. Please do That!

I NEED HELP!!!!

|||

Goods news Alexan,

after several hours I finished the screencast. Look in the screencast section on my site. Would be nice to have some feedback what you are thinking about that and if that helped.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I see only three previous screencasts. Are you sure you uploaded it?

|||Look in the screencast section, not the announcements.

HTH, Jens Suessmeyer.

http://www.sqlserver0205.de|||Was the Screencast helpful ?|||

Thank you very much for all that Jens.

I showed it to my supervisor and he said he already tried that (excluded them) but it didn't work for him, so he is probably going to reinstall sharepoint and reporting server again.

I appreciate your help and support anyway.

Sincerely,

Alexan

|||I know this is late, but I have just posted an entry on my blog that helps for some of this configuration... http://portal.sqltrainer.com/Lists/Posts/Post.aspx?ID=11

Problem with Report Services Integration in MOSS 2007

Specifics:
First machine: SharePoint single server Farm
Second machine: SQL 2005 with Report Services
Installed SP2 and RS Add-in, added SQL pc to farm, and followed steps to set
up integration, including changing SQL service accounts to domain accounts.
Everything went smoothly until we clicked on â'Set Server Defaultsâ' under
Reporting Services in SharePoint Central Admin and we got an error message:
An unexpected error occurred while connecting to the report server. Verify
that the report server is available and configured for SharePoint integrated
mode. --> Server was unable to process request. --> The request failed with
HTTP status 401: Unauthorized.
Nothing in the Event Log on the MOSS server but on the SQL server there is
an Event ID 529 â' unknown user name or bad password. This error message also
shows that the Logon Process and the Authentication Package are Kerberos.
We have beaten our heads against the wall trying to solve. Any help would be
appreciated.Did you check your Service Accounts in IIS and the Reporting Services setup
in SQL server. We had the same issue and it turned out to be we had missed
some of the accounts in Central Admin and IIS.
"AlisonZ" wrote:
> Specifics:
> First machine: SharePoint single server Farm
> Second machine: SQL 2005 with Report Services
> Installed SP2 and RS Add-in, added SQL pc to farm, and followed steps to set
> up integration, including changing SQL service accounts to domain accounts.
> Everything went smoothly until we clicked on â'Set Server Defaultsâ' under
> Reporting Services in SharePoint Central Admin and we got an error message:
> An unexpected error occurred while connecting to the report server. Verify
> that the report server is available and configured for SharePoint integrated
> mode. --> Server was unable to process request. --> The request failed with
> HTTP status 401: Unauthorized.
> Nothing in the Event Log on the MOSS server but on the SQL server there is
> an Event ID 529 â' unknown user name or bad password. This error message also
> shows that the Logon Process and the Authentication Package are Kerberos.
> We have beaten our heads against the wall trying to solve. Any help would be
> appreciated.
>

Problem with Report Pack for sharepoint's, rpdataextraction parser

hi,

when i try to execute the rpdataextraction parser, i am getting the following message - Unable to access site collection: User cannot be found.

it will be of immense help for me if any one helps me on this or directs me to right resource.

thanks

hello,

I have the same problem, so yesterday I found a possible solution for this problem, I'm trying to follow it:

There are a french blog for this issue: http://fmdain.blogspot.com/2006/06/reporting-pack-sps.pour-sql2k5.html.

The solution consist in:

1 - Verify that the tables DimDate and DimTime was complete filled. In my case the DimTime wasn't.

2 - an edition on procedures on database dbSPSReporting, to comment's lines : WHERE dd.DateFull and DATEADD, for all procedures on database.

I localized only those below:

PROCEDURE dbo.uspStorage_AreaGrowthTrend
PROCEDURE dbo.uspStorage_ListGrowthTrend
PROCEDURE dbo.uspStorage_SiteCollectionTrend
PROCEDURE dbo.uspStorage_SizeTrend
PROCEDURE dbo.usp_StartDateEndDate_Retrieve

If you use this solution and works, please send me a confirmation and any other comments about, or other solution.

Regards,

Ernani

Problem with Report Pack for sharepoint's, rpdataextraction parser

hi,

when i try to execute the rpdataextraction parser, i am getting the following message - Unable to access site collection: User cannot be found.

it will be of immense help for me if any one helps me on this or directs me to right resource.

thanks

hello,

I have the same problem, so yesterday I found a possible solution for this problem, I'm trying to follow it:

There are a french blog for this issue: http://fmdain.blogspot.com/2006/06/reporting-pack-sps.pour-sql2k5.html.

The solution consist in:

1 - Verify that the tables DimDate and DimTime was complete filled. In my case the DimTime wasn't.

2 - an edition on procedures on database dbSPSReporting, to comment's lines : WHERE dd.DateFull and DATEADD, for all procedures on database.

I localized only those below:

PROCEDURE dbo.uspStorage_AreaGrowthTrend
PROCEDURE dbo.uspStorage_ListGrowthTrend
PROCEDURE dbo.uspStorage_SiteCollectionTrend
PROCEDURE dbo.uspStorage_SizeTrend
PROCEDURE dbo.usp_StartDateEndDate_Retrieve

If you use this solution and works, please send me a confirmation and any other comments about, or other solution.

Regards,

Ernani