Avatar of vinit_21

asked on 

Authentication in SQL Reporting Services

Hello Experts !,

               We have developed a Application running on ASP.net (VB), SQL 2005 Express, SQL Reporting Services. Platform is Windows 2008 Server.

              We are using ASP.net Membership function to authenticate our users. In our ASP.net website, we have provide Links (URL ACCESS) which directly calls a Report from SQL Reporting Services in PDF format.

               Everything was running perfectly for 45 days but suddenly 3 days back, everytime user click on the Link, they started getting a Login prompt to enter the Username and Password. If I enter the administrator username and password then I can view the report in PDF format...

            I have no idea what suddenly brought the Login Prompt. We have made no changes to Reporting Server and Now I can't remove it.

         Any suggesstion???
DB Reporting ToolsMicrosoft SQL Server 2005ASP.NET

Avatar of undefined
Last Comment
Avatar of Chris McGuigan
Chris McGuigan
Flag of Canada image

Obviously something has expired!
Are you sure there isn't some policy on the server forcing the expiration of the users passwords as is common with standard Windows User Accounts?

I'm not familiar with this Membership function but do you know where/how the credentials are stored?
Avatar of vinit_21


Hello Chrismc,

     Thanks for the reply. Actually I was so frustrated that I reinstall entire Windows Server 2008 and installed everything again. But still everytime I clicked on the link, it shows Prompt for Username and Password.

   I will put the same question in another way.

    If I want to URL access to Report Server without any login promt (i.e. anonymous access ) how can I do it?
You will need to allow anonymous access in IIS against the Report Server web service
Avatar of vinit_21


I tried that. if I enable anonymous access then Reports are not displayed. Only the header of the page.

I really don't understand why suddenly it started asking for a Login Prompt. it never did it before.
Avatar of Tone' Shelby
Tone' Shelby
Flag of United States of America image

This can happen on an automatic ...need  to set IIS .Net App Pool back up in IIS....
Avatar of Tone' Shelby
Tone' Shelby
Flag of United States of America image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Aveeightus

This might be totally off the mark, but I have had this problem once before.  

Check all your connectons strings in your data sets.  Do any of them have NT Authentication set?  Are you using a proxy or a credential anywhere?  If the query inside your report needs new credentials it gets passed right out into the browser.

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo