Groups | Blog | Home
all groups > sql server reporting services > august 2004 >

sql server reporting services : URL Access> How to stop login prompt for user to enter name and pw


Essa
8/11/2004 1:23:02 PM
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
Dmitry Vasilevsky [MSFT]
8/11/2004 6:09:43 PM
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]

Jas
8/12/2004 9:23:01 PM
Dmitry,
I have the same problem. I have installed the Form Auth. Sample. The
Forms Authentication parts works if I directly go the Report Server and use
the Auth Form provided with the sample. Now, I am trying to integrate RS to
an existing Web App running on different web server, on a different Domain.
In my web app, I authenticate with the RS server, but when I try to access
the report via URL, I get the Login Form from the RS server. Please help.
I am not sure what am I doing wrong. Thanks in advance.
Jas.

[quoted text, click to view]
Dmitry Vasilevsky [MSFT]
8/17/2004 8:29:11 PM
If your application is running on a different computer and different domain,
how do you let Report Server know that user is already authenticated?

--
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]

AddThis Social Bookmark Button