Welcome to

SqlServer-QA.net

Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.
Reporting Services: Images are not showing properly when deployed on the live server?

Normally I wouldn't do much development using Reporting Services, but lately I was trying to play with it to get a flashy type of report for a monitoring information on set of SQL Servers we manage. In this scenario I have developed a report that works absolutely fine with images display when i deploy it in the development environment, but when I'm trying todeploy the same report on the production server pointing to the same data source as the development environment; the images doesn't show up. I do see broken image X on all the images.

At first I thought it could be a data source path issue or even a permission issue, to rule out I have used the same user with similar privileges between the 2 environments with no luck. Nothing has come up with fruitful response, but lately found that production Reporting Services instances hasn't been upgraded with Service Pack2. After applying the SP2 the report has been working as expected. Happy anyway but somehow I missed to identify the root cause.

FYI, if you have used emmbadded, it is with report so you don't have to worry if not you have to transer your images as well when the server or environment is changed. If the images are a web source then ensure the specified user has relevant privileges to access the web source.

Posted: Monday, July 30, 2007 4:10 AM by SQL Master

Comments

SSQA.net - SqlServer-QA.net said:

Normally I wouldn't do much development using Reporting Services, but lately I was trying to play

# July 30, 2007 11:24 AM

Other SQL Server Blogs around the Web said:

Normally I wouldn't do much development using Reporting Services, but lately I was trying to play

# August 6, 2007 9:53 PM
Anonymous comments are disabled