Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I think you are overthinking this is my guess.</p> <p>There are three parts to SSRS where security is concerned in getting a report to a 'viewer' object in code or on a rest URI with having credentials supplied.</p> <ol> <li>The Server that hosts SSRS. Can you get to that with the CREDENTIALS specified from the machine calling it?</li> <li>The Report runs a 'Data Source' that either needs credentials or has them specfied. If you are wanting to remote execute a report it is my understanding you will be prompted in the viewer object for these if not supplied. The easiest way to fix this is set the connection string for the data source to use supplied credentials when you set up the report. Not when you call it. I cannot remember but I believe that in remote mode the code will generate the report but you still need to authenticate to the report to get the data from it.</li> <li>The report has security access on it's domain it is running to under different levels and those levels inherit above or are explicit. If you can get to the URL than whatever machine you are on has access and you could hard code that into code to get the report.</li> </ol> <p>Would it be easier to just call the report server in a 'ReportViewer' object in ASP.NET instead in your site at address A? Instead of trying a redirect? My guess is the credential account on the server that is redirecting is not authorized to run reports on the SSRS server and/or is not an adminster of that SSRS site either. I would just set up a remote mode in code behind for a report viewer object for what it is worth. This way you are not redirecting sites but merely taking an object reference to another site and implanting it in a first site. This is less parts to mess up IMHO as well as your dependencies are not as tied. I do this in WPF but I have heard it is very similar for ASP.NET. See this thread for more info: <a href="https://stackoverflow.com/questions/18772349/how-to-implement-user-impersonation-in-reporting-services/18773522#18773522">How to implement user impersonation in reporting services?</a></p>
    singulars
    1. This table or related slice is empty.
    1. POURL Rewrite of virtual directory to retrieve SSRS report
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USdjangojazz
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COdjandojazz, Sorry I have not replied back quicker. I had other items come up that I had to deal with. The answers to your questions are: 1. The web server that hosts the URL rewrite in a virtual directory named "ssrs" has access to the server that contains the SSRS instance as well as the SQL Server database instance. If I browse to the URL for the SSRS reports from the web server I am asked for credentials and when supplied, I am able to log into the SSRS reports page and view the report.
      singulars
      1. PO
      1. USJames
    2. COI would call the Reportviewer as an object that is self contained in your ASP.NET app. Do not do a redirect IMHO.
      singulars
      1. PO
      1. USdjangojazz
    3. COIf I browse to the URL for the SSRS reports from the web server I am asked for credentials and when supplied, I am able to log into the SSRS reports page and view the report. The reports datasource uses a particular Windows User created for the reports. The user is a local administrative user. I can get to the URL on the web server because the firewall rules allow access to the DB over 80 and 443, but not outside of the firewall. The web server on the other hand is available outside the firewall. We want to pass through access to the SSRS reports website with the URL rewrite.
      singulars
      1. PO
      1. USJames
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload