When you run report, there are several credentials involved.
1. Credentials with which user who runs the report authenticates to the
report server. Whether to prompt for these credentials or not is controlled
in the settings of the virtual folder in IIS. If you enable basic
authentication, user will be prompted. If you use integrated windows
authentication, in most cases user won't be prompted.
2. Credentials with which running report authenticate to the data source.
Whether to prompt for these credentials or not is controlled by settings of
report data source. If credentials are set to stored, report
author/administrator provides them and they are used when user runs report,
user is not prompted.
Which credentials and what prompt are you talking about?
--
Dmitry Vasilevsky, SQL Server Reporting Services Developer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
----------------------------------------
[quoted text, click to view] "Essa" <essamughal@hotmail.com> wrote in message
news:43784FC9-956A-4B0F-9D6E-FC9CC1287572@microsoft.com...
> Hi All;
>
> I am trying to call report which is desigened and deployed into SQL
> Reporting Services. I used SQL Server Username and password to created
that
> report in report designer and I deployed that report on report server.
Now, I
> got that URL to access that report in my web application and when I call
that
> report it prompt me to provide username and password for that report
server.
> I don't want it to prompt for username and password b/c that application
will
> be running from different client PC. So, how can I stopped that prompting
or
> what kind of security should I need to invoke that report from web
> application.
>
> Thanks.
>
> --
> Essa, M. Mughal
> Software Developer
> iLogic Inc., Canada