Reporting Services security

[hasanain]

Hello All,

I have the report server on an isolated domain, and I require that
users who have accounts on this domain, be able to access the reports
from outside this domain. I have given groups and users from this
domain access rights/ roles on this server.

I have the report server and IIS set to integrated windows
authentication, in IE I have automatic logon for intranet zone set by
default.

The url that I would I use to access the reports goes something like
this "pcname.domain.com/Reports". At this url it prompts for login
username and pwd. This user has certain access rights and can view x
number of folders and reports. On going to run the report it asks for
username and pwd a second
time.

To connect to the datasource I need to use a database account (This
account does not exist on the domain) which has rights to simply
execute stored procedures associated with the reports. The credentials
for this account being securely stored in the reports server.

The web.config files for reports server and manager have impersonation
set to true.

It does not matter what role the user has been set to as long as they
have minimum 'browser' access.

Can anyone provide some suggestions or possible solutions to prevent
the second logon prompt?

Thanks in Advance

Hasanain