Public SSRS data report

I can do everything but view a data report online:
I am able developed a basic BIDS 2008 SSRS report.  I was able to get BIDS to preview it.  I deployed it and it ran from the IE browser SSRS reports interface.  I can view a report without any data connections using a Public URL.  The problem is when I try to run a report with data from a Public URL.  I appear to get a permissions error going to the sql sever.

----------------------this is error message returned into the report viewer body instead of the SSRS report:
    An error has occurred during report processing. (rsProcessingAborted)
        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 am hoping for a check list of steps to review for setting up a public facing SSRS data report
Michael HoodDeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nico BontenbalCommented:
I think the problem is caused by the properties of the data source used for the report by the report server. So in the 'IE browser SSRS reports interface' not the BIDS part. Check if you are using the option 'Credentials stored securely in the report server' option. And if the user running the report has permissions on the Data Source (that's on the Security part of the Properties).
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Michael HoodDeveloperAuthor Commented:
I really dig the approach.  I put forth some different users and options.  I still get that same error message.  

-------------in addition to report viewer error--This is a message logged in sql server:--
Login failed for user 'IIS APPPOOL\ASP.NET v4.0 Classic'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]
***both of those messages are write on that report viewer
-----------------

Can you recommend a credential path?  
Does the web.config has any options for ssrs?
0
Nico BontenbalCommented:
The first error message says "or enable remote errors". I suggest you try that and see if you get a more useful error message:
http://technet.microsoft.com/en-us/library/aa337165(v=sql.105).aspx

I don't understand why the user 'IIS APPPOOL\ASP.NET v4.0 Classic' is used to get to SQL Server. I suppose you've set up a different user in the data source.

And you could also check these sources for some useful information:
http://msdn.microsoft.com/en-us/library/ms157403(v=sql.105).aspx
0
Michael HoodDeveloperAuthor Commented:
this kinda security problem is so wide in scope that it is hard to narrow down to just one answer.  thanks alot for your input on this issue.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.

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.