Getting Started with Adobe After Effects - Part 6: Motion Blur
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.
Loading

1st Prize - Apple iPad


SQLServer Quiz 2011 - SSIS - advanced services

  • I run SQL Server 2008 express with advanced services and I'm pointing external images in my reports, however when I try to view the report it's not displaying the image, what might the possible reason?

    Posted on 06-21-2011 00:00 |
    Ramireddy
    2 · 41% · 12972

5  Answers  

Subscribe to Notifications
  • Score
    9

    It could be possible that there is no execution account defined to connect to external image source. This execution account has to be domain user account and can be created using reporting services configuration manager and this account should have permission to access those image files.

    Replied on Jun 21 2011 7:28AM  . 
    Nitesh Rai
    135 · 1% · 361
  • Score
    8

    If you are using a "mapped drive" in the path to image files, that mapped path may not exist from the point of view of SQL Server.

    Replied on Jul 7 2011 8:47AM  . 
    Henry Stinson
    670 · 0% · 49
  • Score
    9

    I suggest to check the Path of the images after mapping drive and also permission to the SQL server user and asp.net user should be granted properly. Also change the data source from external to embedded using insert-image wizard from the toolbar. And try if it is working in different browser. I mean if you are using IE6 then try in IE7. and also try in firefox and chrome. Also make sure that you had put your config file settings at proper place As for eg: Reporting Services\ReportServer\rssrvpolicy.config

    Replied on Jul 7 2011 10:44AM  . 
    Nikey Patel
    1982 · 0% · 7
  • Score
    8

    As You are pointing external images into report, please check into IE (assuming default you are using IE) browser by giving external image path. If it is there remap your images into Report and check.

    Insdie your IE check Tools -> Internet Options -> Advance Tab check JRE is selected.

    Thanks Manoj

    Replied on Jul 8 2011 11:12PM  . 
    Manoj Bhadiyadra
    153 · 1% · 315
  • Score
    10

    External images can be specified in different ways, which have different possible causes of not displaying the image.

    If you have the external image as part of the project, it should be deployed to the same Reporting Services folder as the report to be displayed correctly. So check whether the image is contained in the report virtual directory by browsing it with the reporting services web interface. Also make sure the web access permissions on the images folder are set correctly.

    If the external images are database-based, the query to the database should be checked for errors. If this shows no error, processd with the checks below.

    If the external images are web-based (specified by relative URL in the RDL), the problems will nealry always be IIS-related.

    Problems can arise from

    • wrong relative paths
    • missing permissions (the Reporting Services web account cannot access the files)
    • missing web permissions (the user has no rights to access the files, and anonymous access on the virtual directory is not allowed)
    • the images directory not being published to IIS
    • the images format (MIME-type) not being registered to IIS

    Check whether IIS can access the URL by right-clicking on the image location (the "broken image" icon) and select "copy link". Then paste this into a new browser address field and check the error message.

    Replied on Jul 21 2011 6:50AM  . 
    Guenter
    28 · 6% · 1838

Your Answer


Sign Up or Login to post an answer.
Please note that your answer will not be considered as part of the contest because the competition is over. You can still post an answer to share your knowledge with the community.

Copyright © Rivera Informatic Private Ltd.