Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Problem using SQL 2005 Reporting Services & asp.net app

Reply
Thread Tools

Problem using SQL 2005 Reporting Services & asp.net app

 
 
Blasting Cap
Guest
Posts: n/a
 
      07-27-2007
I'm using VS 2005, SQL 2005 reporting services.

SQL reporting services is working, and I have it both on my local
computer, as well as on a server.

I've created a report in the SQL Business Intelligence development
studio that works in that environment.

I've uploaded the same report to both the Reporting services on my local
computer as well as the server, and can log in to them and run the
report there.

In VS 2005, in a test application that otherwise functions, I brought in
a Reportviewer from the toolbar, and added the report to it.

The reportServerUrl is:

http://mylocalcomputer/reports$sql2005

(I have both sql 2000 and sql 2005 on this local box).

The report path is:

J4 Report/J4 Detail Report


When I try to run it, I get:

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.


When I change the server name to the other one, I get the same message.


However, when I go into SQL Server Reporting services, to this link:

http://myserver/Reports$SQL2005/Pages/Report.aspx?ItemPath=%2fJ4+reports%2fJ4+Detail+Rep ort

The report displays fine.

When I go to my local computer & sql reporting services, to this link:

http://mylocalcomputer/Reports$SQL2005/Pages/Report.aspx?ItemPath=%2fJ4+Reports%2fJ4+Detail+Rep ort

I'm not using Localhost either in the VS 2005 app (in the properties for
the report viewer), but I am calling it (the web app itself where I'm
trying to call the report viewer from) thru localhost there.

http://localhost:2228/testjob/default.aspx

I'm calling other things (not report viewers) on this page that appear
to work.

I've seen some notes regarding this error, and that there is a lot of
registry hacks and config file updates you have to make for it, but not
sure if that's a true fix for the problem.

Anyone have any idea why SQL Reporting Services displays it fine, and
the report viewer - which is supposedly calling the same thing, doesn't?

BC

 
Reply With Quote
 
 
 
 
EMartinez
Guest
Posts: n/a
 
      07-28-2007
On Jul 27, 9:16 am, Blasting Cap <(E-Mail Removed)> wrote:
> I'm using VS 2005, SQL 2005 reporting services.
>
> SQL reporting services is working, and I have it both on my local
> computer, as well as on a server.
>
> I've created a report in the SQL Business Intelligence development
> studio that works in that environment.
>
> I've uploaded the same report to both the Reporting services on my local
> computer as well as the server, and can log in to them and run the
> report there.
>
> In VS 2005, in a test application that otherwise functions, I brought in
> a Reportviewer from the toolbar, and added the report to it.
>
> The reportServerUrl is:
>
> http://mylocalcomputer/reports$sql2005
>
> (I have both sql 2000 and sql 2005 on this local box).
>
> The report path is:
>
> J4 Report/J4 Detail Report
>
> When I try to run it, I get:
>
> 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.
>
> When I change the server name to the other one, I get the same message.
>
> However, when I go into SQL Server Reporting services, to this link:
>
> http://myserver/Reports$SQL2005/Pages/Report.aspx?ItemPath=%2fJ4+repo...
>
> The report displays fine.
>
> When I go to my local computer & sql reporting services, to this link:
>
> http://mylocalcomputer/Reports$SQL2005/Pages/Report.aspx?ItemPath=%2f...
>
> I'm not using Localhost either in the VS 2005 app (in the properties for
> the report viewer), but I am calling it (the web app itself where I'm
> trying to call the report viewer from) thru localhost there.
>
> http://localhost:2228/testjob/default.aspx
>
> I'm calling other things (not report viewers) on this page that appear
> to work.
>
> I've seen some notes regarding this error, and that there is a lot of
> registry hacks and config file updates you have to make for it, but not
> sure if that's a true fix for the problem.
>
> Anyone have any idea why SQL Reporting Services displays it fine, and
> the report viewer - which is supposedly calling the same thing, doesn't?
>
> BC



This might be a long shot, but you should check to see if the the
virtual directories (ReportServer and Reports) in IIS are set to the
correct .NET Framework (.NET 2.0) [via: right-click My Computer ->
select Manage -> Services and Applications -> Internet Information
Services -> Web Sites -> Default Web Site -> right-click the Reports/
ReportServer virtual directories -> select Properties -> select the
ASP.NET tab and verify that the ASP.NET version is 2.0.50727]. Hope
this helps.

Regards,

Enrique Martinez
Sr. Software Consultant

 
Reply With Quote
 
 
 
 
=?Utf-8?B?RGF2aWQ=?=
Guest
Posts: n/a
 
      07-30-2007
Connect to ReportServer instead of Reports...i.e.
http://mylocalcomputer/ReportServer$sql2005

"Blasting Cap" wrote:

> I'm using VS 2005, SQL 2005 reporting services.
>
> SQL reporting services is working, and I have it both on my local
> computer, as well as on a server.
>
> I've created a report in the SQL Business Intelligence development
> studio that works in that environment.
>
> I've uploaded the same report to both the Reporting services on my local
> computer as well as the server, and can log in to them and run the
> report there.
>
> In VS 2005, in a test application that otherwise functions, I brought in
> a Reportviewer from the toolbar, and added the report to it.
>
> The reportServerUrl is:
>
> http://mylocalcomputer/reports$sql2005
>
> (I have both sql 2000 and sql 2005 on this local box).
>
> The report path is:
>
> J4 Report/J4 Detail Report
>
>
> When I try to run it, I get:
>
> 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.
>
>
> When I change the server name to the other one, I get the same message.
>
>
> However, when I go into SQL Server Reporting services, to this link:
>
> http://myserver/Reports$SQL2005/Pages/Report.aspx?ItemPath=%2fJ4+reports%2fJ4+Detail+Rep ort
>
> The report displays fine.
>
> When I go to my local computer & sql reporting services, to this link:
>
> http://mylocalcomputer/Reports$SQL2005/Pages/Report.aspx?ItemPath=%2fJ4+Reports%2fJ4+Detail+Rep ort
>
> I'm not using Localhost either in the VS 2005 app (in the properties for
> the report viewer), but I am calling it (the web app itself where I'm
> trying to call the report viewer from) thru localhost there.
>
> http://localhost:2228/testjob/default.aspx
>
> I'm calling other things (not report viewers) on this page that appear
> to work.
>
> I've seen some notes regarding this error, and that there is a lot of
> registry hacks and config file updates you have to make for it, but not
> sure if that's a true fix for the problem.
>
> Anyone have any idea why SQL Reporting Services displays it fine, and
> the report viewer - which is supposedly calling the same thing, doesn't?
>
> BC
>
>

 
Reply With Quote
 
Blasting Cap
Guest
Posts: n/a
 
      07-30-2007
Thank you.

This appeared to work, although I had to put in a slash at the end of
the http://mylocalcomputer/ReportServer$sql2005 line.

However, now that I've gotten it to run, I have some unusual behavior -

The "e" on Internet explorer at the top of the tab now flickers, like
the page is reloading. It also runs the CPU up to 100% on the computer
and although I can go from tab to tab in it (I am using AJAX tab panels
in the page), it will take like up to a minute to go to the next tab.
I'm not doing anything really data-intensive on those tabs, and they had
been functioning fine prior to putting in the report viewer (i.e. they
weren't flickering & clocking the CPU).

I eventually have to kill the page to do anything, because it has the
system up to 100%.

Any idea why reportviewer might make this act this way?

Thanks for the help,

BC





David wrote:
> Connect to ReportServer instead of Reports...i.e.
> http://mylocalcomputer/ReportServer$sql2005
>
> "Blasting Cap" wrote:
>
>> I'm using VS 2005, SQL 2005 reporting services.
>>
>> SQL reporting services is working, and I have it both on my local
>> computer, as well as on a server.
>>
>> I've created a report in the SQL Business Intelligence development
>> studio that works in that environment.
>>
>> I've uploaded the same report to both the Reporting services on my local
>> computer as well as the server, and can log in to them and run the
>> report there.
>>
>> In VS 2005, in a test application that otherwise functions, I brought in
>> a Reportviewer from the toolbar, and added the report to it.
>>
>> The reportServerUrl is:
>>
>> http://mylocalcomputer/reports$sql2005
>>
>> (I have both sql 2000 and sql 2005 on this local box).
>>
>> The report path is:
>>
>> J4 Report/J4 Detail Report
>>
>>
>> When I try to run it, I get:
>>
>> 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.
>>
>>
>> When I change the server name to the other one, I get the same message.
>>
>>
>> However, when I go into SQL Server Reporting services, to this link:
>>
>> http://myserver/Reports$SQL2005/Pages/Report.aspx?ItemPath=%2fJ4+reports%2fJ4+Detail+Rep ort
>>
>> The report displays fine.
>>
>> When I go to my local computer & sql reporting services, to this link:
>>
>> http://mylocalcomputer/Reports$SQL2005/Pages/Report.aspx?ItemPath=%2fJ4+Reports%2fJ4+Detail+Rep ort
>>
>> I'm not using Localhost either in the VS 2005 app (in the properties for
>> the report viewer), but I am calling it (the web app itself where I'm
>> trying to call the report viewer from) thru localhost there.
>>
>> http://localhost:2228/testjob/default.aspx
>>
>> I'm calling other things (not report viewers) on this page that appear
>> to work.
>>
>> I've seen some notes regarding this error, and that there is a lot of
>> registry hacks and config file updates you have to make for it, but not
>> sure if that's a true fix for the problem.
>>
>> Anyone have any idea why SQL Reporting Services displays it fine, and
>> the report viewer - which is supposedly calling the same thing, doesn't?
>>
>> BC
>>
>>

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
2005 Crystal Reports vs Reporting Services Roy ASP .Net 1 12-13-2006 09:12 PM
ASP.Net Web Mobile Applications and SQL Server Reporting Services 2005... SP ASP .Net Mobile 0 05-02-2006 09:22 PM
Using sql reporting services in asp Ganesh ASP General 0 10-21-2005 03:36 PM
Intergrating SQL Server Reporting Services into an ASP.NET app Brendan Reynolds ASP .Net 8 08-18-2005 12:43 PM
Problem in SQL Reporting services Raju ASP .Net 0 08-02-2004 04:01 AM



Advertisments