Databases
StackOverflow2013
Postsdbo
POReporting Services Authentication advice sought
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POReporting Services Authentication advice sought
    primarykey
    data
    text
    <p>I have been allocated the responsibility at work of revising the current reporting services authentication process. The aim is to maintain the necessary level of security and also simplify the maintenance/configuration of granting access to the individual reports.</p> <p>I do NOT have access to the domain controllers to be able to modify or create new AD groups. I have to work with the groups/users that currently exist.</p> <p>In terms of authentication, it seems that I have the option of using either:</p> <ul> <li>Windows authentication</li> <li>SQL Server authentication.</li> </ul> <p>Both the report server and the report database will reside on the same server. With this in mind, I understand that Windows authentication is probably a better solution as there is no need to maintain a separate SQL Server table of Users (and their passwords). Granting access to a report once it has been deployed on the report server, would simply involve adding the user/group to the report (load the report in a browser and access the Properties\Security option).</p> <p>Using the second option of SQL Server authentication does not seem as appropriate as using Windows authentication for the reason the report server and report database are on the same box.</p> <p>I am using SQL Server 2000 databases. The version of reporting services I have installed is Microsoft SQL Server 2008.</p> <p>Please could someone let me know if my thinking is correct (i.e. I should go for Windows authentication). Cheers.</p> <p>Jimmy</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USJimmy Fishbean
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POReporting Services Authentication advice sought
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POReporting Services Authentication advice sought
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

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