Authentication - Allowing Anyone to View Report
-
Hi,
I have a report I want everything to see. We have a Windows domain environment but the SQL Server is in mixed mode.I'm a developer not administrator, but since there is no administrator I am it!
My thought was to create an SQL loging with read only access and then store those credentials in an SSRS shared datasource and us this. Makes sense right? I want a shared connection wich allows me to create as many 'public' reports as I need.
But this does not work. Any seasoned admins know what I'm doing wrong?
SQL 2012 Standard VPS Windows 2012 Server Standard
-
It's not real clear what "does not work" means.
If it's access to the report, It looks like the biggest problems may be understanding that data source credentials is separate from permissions to access a report.
SSRS uses the data source credentials to connect to the source of the data and obtain the data for the report.
Permission in Report Manager is what is used for access to the report. For everyone to have access, you can grant access to the authenticated users group. Everyone group would include authenticated users, guest, built-in accounts such as service, local service, network service, etc. How you do that depends upon how you are setting up security in general for the reports, folders, etc.
If it's something with the shared data source, what is the error message, what is not working?
If it's something else, we would really need more details.Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply