• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 74
  • Last Modified:

I am getting permission errors on reports if i don't specifically add users. How would i add everybody in the organization to have permission to see them?

I am getting permission errors on reports if i don't specifically add users. How would i add everybody in the organization to have permission to see them?
0
vbnetcoder
Asked:
vbnetcoder
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Assuming SSRS, I've run into this before, and the root cause was that the new users didn't have privs on the SP or T-SQL that was the data source for the report.  To fix, we had to make sure all T-SQL was removed from the report and written as SP's, then grant privs for everyone on those SP's.
0
 
LIONKINGCommented:
If you want your reports to be visible to "absolutely" everybody, you add "DOMAIN\Authenticated Users" to your security settings. All users who are authenticated in the domain will then be able to access the site + the reports that inherit this security setting.
0
 
vbnetcoderAuthor Commented:
I received an error:

The user or group name 'DOMAIN\Authenticated Users' is not recognized
0
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
LIONKINGCommented:
Did you replace the word "DOMAIN", with the name of your actual domain.
0
 
vbnetcoderAuthor Commented:
yeah and it didn't work
0
 
LIONKINGCommented:
This group should exist in your domain, can you check with your domain admin to make sure you're pointing to the right group?

Here's a link that explains the "Authenticated Users" group.

Link: http://networkadminkb.com/KB/a41/differences-between-authenticated-users-domain-users.aspx
0
 
LIONKINGCommented:
Sorry about that, the group name is actually "NT AUTHORITY\Authenticated Users"

I apologize for the confusion.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
@vbnetcoder:
Do still have issues with this?
0
 
vbnetcoderAuthor Commented:
No sorry i will award the points
0
 
vbnetcoderAuthor Commented:
ty
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now