Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...I train people in ACCESS. I make sure they know about these forums, give them some training on how to use the site, and have a shortcut to it on their PC's..."

Geography

Where in the world do Tek-Tips members come from?
katekis (MIS)
23 Apr 12 10:46
I am having some issues with securing my SQL Server Reporting Services.  I are using SQL Server 2008 R2 and Report Builder 3.0.  I are using the Native Mode.  In the rsreportserver.config I am using <RSWindowsNTLM/>.

The SSRS Service runs as Domain\mssql123.  

I am the DBA and my login is Domain\xxk but when I create a folder the modified by says 'Domain\mssql123?  When I click on My Reports it does not show my Domain\xxk reports.  In order to get to my reports I need to click on User Folders and find my folder.

When I create reports using Report Builder the reports say they created by Domain\xxk.  I am able to save reports in My Reports (Domain\xxk ) using report Builder.  The problem is not just me, when anyone creates a folder it says Domain\mssql123.  Everyone has to all the reports on SSRS.  The roles created in Site Settings do not restrict anyone from going into SSRS.  Everyone seems to have access to everything even though their domain login in the Site Settings says they do not have access.  

For example Domain\xxy is setup in Site Settings as System User, the System User is setup to only task "Execute Report Definitions".  Under the Home Folder Settings, Domain\xxy is setup in only the Browser Role.   The Browser role only has access to....
- View Reports
- View folders
- View models
- View Resources
- Manage Individual Subscriptions

But still the Domain\xxy can use do anything just like the System Administrator?

This problem started when I moved my Reporting Services Database from SQL Server 2005 SP4 to SQL Server 2008 R2 SP1.  Any help or suggestions is greatly appreciated.   

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close