[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 73
  • 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
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

 
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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