Avoiding the user login prompt for a reporting services report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim - 27 Dec 2005 21:43 GMT

Most of the stuff I have read on this is from 2004. I am wondering if
there is a easier fix to this problem.

Reply to this Message

Jéjé - 27 Dec 2005 22:42 GMT

do you use NT authentication or basic authentication?
using NTLM the users can add the web site to the intranet list then the
current login/password will be used. (IE only) so there is no prompt for the
user.

basic authentication allways ask the user.
anonymous access... its anonymous, so no login but no security.

Enterprise edition of RS allow you to create your own authentication system
(like a form based authentication)

> Most of the stuff I have read on this is from 2004. I am wondering if
> there is a easier fix to this problem.

Reply to this Message

Bruce L-C [MVP] - 27 Dec 2005 23:04 GMT

Also, just in case you have a weird problem. I had a case where the issue
was that the server (it was a test server) was using DHCP (dynamic tcpip
address instead of fixed). When I went to a fixed IP address the probelm
went away. Obscure but thought I would mention it.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> do you use NT authentication or basic authentication?
> using NTLM the users can add the web site to the intranet list then the
[quoted text clipped - 9 lines]
>> Most of the stuff I have read on this is from 2004. I am wondering if
>> there is a easier fix to this problem.

Reply to this Message

Tim - 28 Dec 2005 18:00 GMT

I am new to web programming. I thought I needed to say that.

In my ASP.net app authentication is set to Windows. Is that the
authentication you are talking about? I set it to none and it stills
comes up with the login prompt.

Reply to this Message

Pieter van Maasdam - 29 Dec 2005 13:17 GMT

Could you open the following file:

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\rsreportserver.config

Check the tag <UrlRoot> to see if your servername is entered correctly (e.g.
not set to localhost)

Hth,
Pieter

>I am new to web programming. I thought I needed to say that.
>
> In my ASP.net app authentication is set to Windows. Is that the
> authentication you are talking about? I set it to none and it stills
> comes up with the login prompt.

Reply to this Message

Tim - 29 Dec 2005 15:58 GMT

The <UrlRoot> is entered correctly.

The authentication tag in this file is:
        <Authentication>
            <Extension Name="Windows"
Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication,
Microsoft.ReportingServices.Authorization"/>
        </Authentication>

I still have no idea how to overcome the windows login prompt for
showing the report in my asp.net app.

Reply to this Message

Brennan - 29 Dec 2005 21:42 GMT

Does your url to your reporting server include your server's ip address? If
it does, you'll have to enter the address into the end users local Intranet
security site.

From the end users machine, open IE.
Click on Tools>Internet Options
Click on the Security Tab then Local Intranet
Click on Sites
Click on Advanced
Enter in the url of your reporting server and click add.
Save your changes and try to access the site.

HTH

> The <UrlRoot> is entered correctly.
>
[quoted text clipped - 7 lines]
> I still have no idea how to overcome the windows login prompt for
> showing the report in my asp.net app.

Reply to this Message

Sorcerdon - 30 Dec 2005 16:19 GMT

Where are you running the report off from? Your local Machine? or some
other machine?

Reply to this Message