Problems with RS Unattended Execution Account

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
GeorgeOn Aug 29, 2:15 am, "_george" <none@.nojne@.none> wrote:
> 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
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|||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
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1188435094.798326.100950@.22g2000hsm.googlegroups.com...
> On Aug 29, 2:15 am, "_george" <none@.nojne@.none> wrote:
>> 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
>
> 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
>