all groups > sql server reporting services > august 2007 >
You're in the

sql server reporting services

group:

Problems with RS Unattended Execution Account


Problems with RS Unattended Execution Account _george
8/29/2007 12:00:00 AM
sql server reporting services:
HI all
I have RS2000 Report Server with a report that contains an image control.
The image control value is a UNC path to an image (ie
\\<server>\images\image.jpg. The <server> is a different server to the
Report Server. I have setup the unattended execution account to be the
domain administrator (for testing purposes). WHen running the report on my
machine in Visual Studio, I can see the images, however when running it off
the server the images do not appear. I setup object access auditing on the
server containing the images and it seems like the report server is not even
attemting to access the images.

Anyone know what I may be missing here.

Thanks in advance

George

Re: Problems with RS Unattended Execution Account _george
8/30/2007 12:00:00 AM
Thanks Enrique
I had swapped the default ASP.Net account used in the Out of process
components for IIS to a Domain Administrator account but still no go. As for
the config files, what exactly should I be looking for?? I was under the
impression that all usernames and pwds in the .config files are encrypted.

Thanks again

George

[quoted text, click to view]

Re: Problems with RS Unattended Execution Account EMartinez
8/30/2007 12:51:34 AM
[quoted text, click to view]


It might be that since you are accessing the image through the Report
Server, which is basically a website, you may be using the default
ASPNET account that has minimal permissions in the system. On
occasion, explicit settings are overridden in ASP.NET and IIS.
Depending on your circumstances, you could try embedding the image in
the report. Also, you might want to check the settings in one of
the .config files in the path: C:\Program Files\Microsoft SQL Server
\MSSQL.x\Reporting Services\ReportManager it may be overriding your
domain admin account. Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant
AddThis Social Bookmark Button