SSRS Authentication

I have a few SSRS reports that I created with BIDS. I deployed them to the Web, and added a number of users to have access to the reports. Now my question is this, If a user is already logged into their system, and then attempts to access SSRS, it currently prompts for login credentials. Is there a way to have SSRS check if the user is already an authenticated user and not prompt for another login?
LVL 1
Abacus ITAsked:
Who is Participating?
 
Abacus ITConnect With a Mentor Author Commented:
I found the answer. In the Report Manager itself, I had to specify the logon credentials for each report. So apparently, even though I set credentials in the SSRS designer, I had to do the same within the Report Manager also.
0
 
Megan BrooksSQL Server ConsultantCommented:
SSRS by default uses Windows Authentication and does not prompt for a username and password as long as the server and client are properly configured. I am not an expert on all the different configuration issues that can produce an authentication prompt, but there are numerous questions and answers here on EE describing a variety of scenarios. You may be able to find a quick answer by searching.

Is this occurring within a intranet, or by "Web" (capital "W") do you mean that you are deploying reports to the Internet and trying to use Windows Authentication there? Is there a firewall between client and server?
0
 
Abacus ITAuthor Commented:
I figured out the issue with the Authentication. Here is the new issue, I deployed my reports from a new machine running WS2k8 with SQL 2008 SSRS. I supply credentials for the data sources for each report so the user doesn't have to log in again, if they are in the assigned roles I gave them on the Report Manager. What I am seeing now is this, when I open the browser and navigate to the report manager, one of the reports is still asking for logon credentials for the data source, the other 2, when I open them, allow me to see the parameter screen. Then after entering the parameters I want, I get the following error message.

    * An error has occurred during report processing. (rsProcessingAborted)
          o Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection)
                + For more information about this error navigate to the report server on the local server machine, or enable remote errors

I see the same thing whether I am using Firefox or IE8. Is there some permissions setting I am missing either in the Reporting Services Configuration Manager on the back-end, or some permissions with the browsers themselves?
0
 
Abacus ITAuthor Commented:
Found the answer to my own posted question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.