August 9, 2010 at 9:20 am
Greetings Report Wizards,
I need an urgent help.
For the past 2 years, our users have been able to just open reports and access their reports without entering username/password.
This morning, the users are being asked to provide username/password.
Can you please tell me how to fix this in such that the users would not asked to provide username/password.
We *don't* want to select the radio button that says, Credentials are not required.
In fact, the one we have been using so far is that one that says, "Credentials Stored Securely in the Server".
Whhat could have gone wrong?
Thanks a lot in advance.
August 9, 2010 at 11:05 am
I guess one of the biggest things you need to determine is which set of credentials is it asking for? Is it asking for their windows credentials so that it can authenticate them into the appropriate security group, or is it asking for credentials to the database?
If it's their windows credentials, probably someone changed something in the IE security settings. Since this is affecting everyone, most likely this happened because a) a GPO was changed, or b) the report server is no longer in the zone it used to be. In IE the intranet zone allows for the automatic passing of login information be default. Someone may have changed the GPO that affects this or someone may have moved the report server to a new network segment that may affect this.
If it's asking for the database credentials, find out if the stored credentials are still correct? Did someone change the password that the Login/user/certificate was using? did some other setting in your shared datasource get changed?
Hopefully this gets you pointed in the right direction.
-Luke.
August 9, 2010 at 11:39 am
Thanks a lot Luke for your kind response.
This is asking for Windows authentication.
As stated, everything was fine before.
What's funny is that I can see view the reports when I fire up the browser and pull it up.
Someone else is able to do so as well.
No one else can view the reports.
BTW: What is GPO?
August 9, 2010 at 12:19 pm
GPO = Group Policy Object.
IF it's asking for windows credentials, then there could be 2 issues going on here. 1) someone changed the security settings on your SSRS server. Make certain the appropriate users/groups have the appropriate permissions. Make certain that the correct users are in the correct groups.
2) someone changed the IE settings that allow automatic login to your SSRS server. Is your server in your local intranet, or someone else? In other words would it be part of the Intranet Settings or the Trusted Sites or Internet ?
In the IE settings, security tab , how are your settings configured? For the automatic login to work, and if your SSRS server is located in your local network, click the intranet settings and click the custom settings button towards the bottom. A dialog box will open, the last setting is User Authentication. How is that set for a computer that is working, how is it set for one that is not working?
-Luke.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply