asked on 7/17/2008

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 Tools Microsoft SQL Server 2005 ASP.NET

Last Comment

Aveeightus

7/21/2008

Chris McGuigan

7/17/2008

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?

vinit_21

7/17/2008

ASKER

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?

Chris McGuigan

7/17/2008

You will need to allow anonymous access in IIS against the Report Server web service

vinit_21

7/17/2008

ASKER

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.

Tone' Shelby

7/18/2008

This can happen on an automatic ...need to set IIS .Net App Pool back up in IIS....

ASKER CERTIFIED SOLUTION

Tone' Shelby

7/18/2008

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

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

Aveeightus

7/21/2008

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.