Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Public SSRS data report

Posted on 2014-07-28
4
1,050 Views
Last Modified: 2014-08-07
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
0
Comment
Question by:Michael Hood
  • 2
  • 2
4 Comments
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 500 total points
ID: 40226044
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
 

Author Comment

by:Michael Hood
ID: 40227939
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
 
LVL 22

Assisted Solution

by:Nico Bontenbal
Nico Bontenbal earned 500 total points
ID: 40228552
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
 

Author Closing Comment

by:Michael Hood
ID: 40247445
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

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video teaches viewers how to create their own website using cPanel and Wordpress. Tutorial walks users through how to set up their own domain name from tools like Domain Registrar, Hosting Account, and Wordpress. More specifically, the order in…
Wufoo.com provides powerful tools for surveying targeted groups, and utilizing data from completed surveys to find trends, discover areas of demand or customer expectation, and make business decisions on products or services.

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question