Showing posts with label deployed. Show all posts
Showing posts with label deployed. Show all posts

Monday, March 26, 2012

Images aren't being displayed in deployed Reports

Hi everybody,

When I develop and run (preview) a report in my machine (Vs.net 2003), the report is displayed correctly, including images.

But, when I deploy the report to the server (Win2k Server), the report runs OK, but the images are not displayed! Tongue Tied

I've already tried everything I found in the internet about this problem .... changed the way of put the image in the report (Embedded, External), tried an image with only RGB colors, changed the account for unattended execution (rsconfig) .... but nothing worked!!!

Does anybody have any idea about what might be happening?

Thanks a lot!!Make sure cookies are enabled in your browser. Images rely on sessions and sessions rely on cookies.

To better diagnose this you can right click on the missing image icon right after rendering report, go to properties and copy link for the image. Make sure you copy the entire link. Then paste it in the address bar of the same window that displays report. You'll see better error message.|||Yes, cookies are enabled.

Actually, view the properties of the image was the first step I took ...

The image link:
http://server/ReportServer?%2fOpexReports%2fReport1&rs%3aFormat=HTML4.0&rs%3aImageID=6b02dc52-73b7-489e-8dfe-730e6d9bfd6b

when I copy the link in IE, I get this error:

Reporting Services Error

The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. (rsStreamNotFound) Get Online Help|||I SOLVED THE PROBLEM!!

I discovered that images in report rendering rely on session and cookies.
When you have and underscore "_" in the server name, this may cause some session problems.

So I update the field UseSessionCookies to 'False' in the ConfigurationInfo table, in the RS Database. The images are now displayed! Big Smile

Regards!|||

Hi Rodrigo,

I am also facing the problem similar to your problem. I have followed your approach for solution, but unfortunately i am not able to get the solution.

Can you please provide me some approach for solving this problem

Regards,

Vikas Khandpur

|||

Just change the IP address to the computer name and it will work

Images aren't being displayed in deployed Reports

Hi everybody,

When I develop and run (preview) a report in my machine (Vs.net 2003), the report is displayed correctly, including images.

But, when I deploy the report to the server (Win2k Server), the report runs OK, but the images are not displayed! Tongue Tied

I've already tried everything I found in the internet about this problem .... changed the way of put the image in the report (Embedded, External), tried an image with only RGB colors, changed the account for unattended execution (rsconfig) .... but nothing worked!!!

Does anybody have any idea about what might be happening?

Thanks a lot!!Make sure cookies are enabled in your browser. Images rely on sessions and sessions rely on cookies.

To better diagnose this you can right click on the missing image icon right after rendering report, go to properties and copy link for the image. Make sure you copy the entire link. Then paste it in the address bar of the same window that displays report. You'll see better error message.|||Yes, cookies are enabled.

Actually, view the properties of the image was the first step I took ...

The image link:
http://server/ReportServer?%2fOpexReports%2fReport1&rs%3aFormat=HTML4.0&rs%3aImageID=6b02dc52-73b7-489e-8dfe-730e6d9bfd6b

when I copy the link in IE, I get this error:

Reporting Services Error

The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. (rsStreamNotFound) Get Online Help|||I SOLVED THE PROBLEM!!

I discovered that images in report rendering rely on session and cookies.
When you have and underscore "_" in the server name, this may cause some session problems.

So I update the field UseSessionCookies to 'False' in the ConfigurationInfo table, in the RS Database. The images are now displayed! Big Smile

Regards!|||

Hi Rodrigo,

I am also facing the problem similar to your problem. I have followed your approach for solution, but unfortunately i am not able to get the solution.

Can you please provide me some approach for solving this problem

Regards,

Vikas Khandpur

|||

Just change the IP address to the computer name and it will work

Images aren't being displayed in deployed Reports

Hi everybody,

When I develop and run (preview) a report in my machine (Vs.net 2003), the report is displayed correctly, including images.

But, when I deploy the report to the server (Win2k Server), the report runs OK, but the images are not displayed! Tongue Tied

I've already tried everything I found in the internet about this problem .... changed the way of put the image in the report (Embedded, External), tried an image with only RGB colors, changed the account for unattended execution (rsconfig) .... but nothing worked!!!

Does anybody have any idea about what might be happening?

Thanks a lot!!Make sure cookies are enabled in your browser. Images rely on sessions and sessions rely on cookies.

To better diagnose this you can right click on the missing image icon right after rendering report, go to properties and copy link for the image. Make sure you copy the entire link. Then paste it in the address bar of the same window that displays report. You'll see better error message.|||Yes, cookies are enabled.

Actually, view the properties of the image was the first step I took ...

The image link:
http://server/ReportServer?%2fOpexReports%2fReport1&rs%3aFormat=HTML4.0&rs%3aImageID=6b02dc52-73b7-489e-8dfe-730e6d9bfd6b

when I copy the link in IE, I get this error:

Reporting Services Error

The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. (rsStreamNotFound) Get Online Help|||I SOLVED THE PROBLEM!!

I discovered that images in report rendering rely on session and cookies.
When you have and underscore "_" in the server name, this may cause some session problems.

So I update the field UseSessionCookies to 'False' in the ConfigurationInfo table, in the RS Database. The images are now displayed! Big Smile

Regards!|||

Hi Rodrigo,

I am also facing the problem similar to your problem. I have followed your approach for solution, but unfortunately i am not able to get the solution.

Can you please provide me some approach for solving this problem

Regards,

Vikas Khandpur

|||

Just change the IP address to the computer name and it will work

image won't show up

Hey all,
I have an image to put into a report. It's a jpg. I can see it in
layout view, but in preview or when deployed, i get a red "x" - any
idea why or how to fix it? Thanks!!
jenrI have experienced the same problem in 2005 - NEVER in 2000!
I don't know what is happening!
"jenr" wrote:
> Hey all,
> I have an image to put into a report. It's a jpg. I can see it in
> layout view, but in preview or when deployed, i get a red "x" - any
> idea why or how to fix it? Thanks!!
> jenr
>|||Well -
Is the image in your "project" ?
Was the image deployed to your server with the "deploy" of the project?
That is all I have ever done in the past - but I am speculating "here" and I
think there are some weird issues with the GDI of 2005! As I have said in
previous posts a graphical report in RS2000 works perfectly and taking the
same report to 2005 - some graphs are never rendered - a GDI+ error. Maybe
not the same with a *.jpg - but something for sure is funny somewhere.
Warm REgards,
joe
"code_slayer_bkk" wrote:
> I have experienced the same problem in 2005 - NEVER in 2000!
> I don't know what is happening!
> "jenr" wrote:
> > Hey all,
> >
> > I have an image to put into a report. It's a jpg. I can see it in
> > layout view, but in preview or when deployed, i get a red "x" - any
> > idea why or how to fix it? Thanks!!
> >
> > jenr
> >
> >

Wednesday, March 7, 2012

IIS and SQL server securities

Dear all experts,
We have an ASP application previously deployed on machine A, where the web
server (W2K-IIS) and database server (SQLServer 7.0) are installed. When we
try to move the database server to machine B, the ASP application threw an
exception when it tries to connect to the remote database:
Login failed for user 'XXX'. Reason: Not associated with a trusted SQL
server connection.
Both machine A and B do not belong to any domain (but are of the same
workgroup, same subnet.) We googled for it and found some websites suggest
that the SQL Server should be configured to use Windows _AND_ SQL
authentication. However this has no effect since it is already the default
of SQL Server 7.0. Some websites also suggest to use several combinations of
system user account and SQL server user accounts but it didn't solve the
problem either.
Finally, we seem to have found a workable solution. We changed the anonymous
user proxy account (previously IUSR_XXX) in IIS to a sytem user who is in
the local Administrators group and the ASP application works! I know that's
likely not the right way to solve the problem as it would make everyone to
use the Administrators role to execute the ASP application.
So my question is, how should we configure the servers so that the IIS (with
IUSR_XXX role) can talk with the remote SQL Server (with pure
username/password authentication)? How can we completely disable Windows
authentication and access controls?
Thank you very much,
KennethThis article has your solution.
253500 PRB: "Client Unable to Establish Connection" Error Message When
http://support.microsoft.com/?id=253500
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.