Avoiding the user login prompt for a reporting services report -- sql server reporting services

sql server reporting services : Avoiding the user login prompt for a reporting services report

Tim
12/27/2005 1:43:51 PM

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

Bruce L-C [MVP]
12/27/2005 5:04:31 PM

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.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Jéjé
12/27/2005 5:42:59 PM

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)

[quoted text, click to view]

Tim
12/28/2005 10:00:05 AM

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.

Tim
12/29/2005 7:58:12 AM

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.

Brennan
12/29/2005 1:42:02 PM

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

[quoted text, click to view]

Pieter van Maasdam
12/29/2005 2:17:18 PM

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

[quoted text, click to view]

Sorcerdon
12/30/2005 8:19:36 AM

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

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn