Last post Jun 27, 2011 04:20 PM by MSBoston
Apr 07, 2011 10:35 AM|MSBoston|LINK
Hey. I'm somewhat new to SSRS 2008 and I've built two datasources connecting to "HumanResources" and "HumanResourcesDev5" databases on a single server. Both of those datasources have been changed from a Windows NT login clone to a preset login for a temp
account that we have for testing called "Test2". I have opened my created datasets and verified that when they open they ask for the password for the new credentials that I have set for the datasources. After verifying this and the connection I re-opened
the reports that I made within Report Builder (not Report Designer a VS extension) and verified all of the dataset and datasource information. These reports and report parts get saved to the
http://localhost/Reports folder within the server. I have published the report parts to the /Report Parts folder within the localhost.
This is where I begin to have issues...
When someone uses the reports that I have generated through report builder and link to them on our sharepoint site when a person without an actual account on the SQL server tries to view them they cannot because they do not have sufficient permissions.
And what I noticed is that it still tries to use their Windows NT credentials rather than the temp account (Test2) that we have created which is why they are not able to see the reports.
I do not know if I need to publish these reports a different way, or use the report parts that I have published instead of the actual .rds file. But what we're trying to do is have these reports accessible to everyone without the need to give everyone a
SQL Server account. I thought this would get fixed if I set the login to a static temp account.
Jun 27, 2011 04:20 PM|MSBoston|LINK
I figured out my own problem for this one.
You have to change the settings on the report manager site and the individual folders that contain the reports. Report manager is usually located at
1) Go to Site Settings > Security (Tab) and then click
New Role Assignment.
2) Enter the users NT account in Group or user name: and then select
System User for them. Click Ok. Click
Home at the top to go to your reports folder.
3) Go to Folder Settings > Security (Only tab in folder settings) and then click
New Role Assignment.
4) Enter the users NT account in Group or user name: and then I chose
Browser so that the person would be able to see the folders and reports and subscribe to the reports. Then click
That was pretty much it. I allowed the person to be able to be a user of the reports and then I allowed them to see the folder and reports within report manager and anywhere else where I link them on Sharepoint.