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?
vbnetcoderAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
LIONKINGConnect With a Mentor Commented:
Sorry about that, the group name is actually "NT AUTHORITY\Authenticated Users"

I apologize for the confusion.
0
 
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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
vbnetcoderAuthor Commented:
I received an error:

The user or group name 'DOMAIN\Authenticated Users' is not recognized
0
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.