I have a report server: DEV05
I have a web/data server: DEV14. It also has a SQL Server Database for
data to be displayed.
I have my pc: DEV01
IIS on the Report Server:
Reports ? anonymous is disabled
ReportServer ? anonymous is disabled
On the web server I have a virtual directory that houses images. From
a browser, on my machine I can see the image using:
http://dev14/images/sketcha.jpg. I can also see the image from the
report server using the same url.
When I'm designing a report in VS.NET on my machine and issue a new
image control and select ?web' as the source,
(http://dev14/images/sketcha.jpg.) the image is resolved.
However, when I deploy the report to the report server DEV05, and view
the report through report manager, the image (located on the web
server) is not displayed, a red X is displayed. The report data is
displayed though, which is stored in a SQL server on the same server
(DEV14).
The report uses a shared data Source. The data source uses stored
credentials to connect to the database on DEV14. The credentials are
SQL Logins, not NT.
Anyone have any suggestions on what permissions I need to change or
set so I can get the images to display?
All help and suggestions are greatly appreciated.
Thanks
Rwiethorn
rwiethorn@.remove-nospam-belcan.comRwiethorn,
How is dev14/images vroot configured?
Please note that when images are fetched by URL, a special unattended
execution Windows account is used.
From SP1 readme file:
"When the report is previewed in Report Designer, preview uses the
credentials of the user to display the image. When the report is run on the
report server, the report server uses the unattended execution account to
retrieve the image. If the unattended execution account is not specified,
the image is retrieved using no credentials (anonymous user account). If
either of these accounts have insufficient rights to access the image, the
image will not be displayed in the report. For more information about
setting the unattended execution account on the report server, see
"Configuring an Account for Unattended Report Processing" in Reporting
Services Books Online."
For more information check this thread: http://tinyurl.com/42738
Ii addition, check the "Configuring an Account for Unattended Report
Processing" topic in BOL.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com : http://tinyurl.com/3l49j
Home page and blog: http://www.prologika.com/
----
"rwiethorn" <rwiethorn2002@.yahoo.com> wrote in message
news:553a0349.0408260649.70d95c7c@.posting.google.com...
> I have a report server: DEV05
> I have a web/data server: DEV14. It also has a SQL Server Database for
> data to be displayed.
> I have my pc: DEV01
> IIS on the Report Server:
> Reports - anonymous is disabled
> ReportServer - anonymous is disabled
>
> On the web server I have a virtual directory that houses images. From
> a browser, on my machine I can see the image using:
> http://dev14/images/sketcha.jpg. I can also see the image from the
> report server using the same url.
> When I'm designing a report in VS.NET on my machine and issue a new
> image control and select 'web' as the source,
> (http://dev14/images/sketcha.jpg.) the image is resolved.
> However, when I deploy the report to the report server DEV05, and view
> the report through report manager, the image (located on the web
> server) is not displayed, a red X is displayed. The report data is
> displayed though, which is stored in a SQL server on the same server
> (DEV14).
> The report uses a shared data Source. The data source uses stored
> credentials to connect to the database on DEV14. The credentials are
> SQL Logins, not NT.
> Anyone have any suggestions on what permissions I need to change or
> set so I can get the images to display?
> All help and suggestions are greatly appreciated.
> Thanks
> Rwiethorn
> rwiethorn@.remove-nospam-belcan.com
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment