Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 RS not let user access reports?

Author  Topic 

chriskhan2000
Aged Yak Warrior

544 Posts

Posted - 2005-05-04 : 19:06:48
Anyone using the Reporting Security? I was setting up some web applications and I don't know what I click but now Reporting Services doesn't let Domain Users access the report. It ask for user name and password. If this is supply, it still won't let the user view the report.

Domain admins can view it fine. I'm not sure what might've caused this but anyone might know where I would look?

chriskhan2000
Aged Yak Warrior

544 Posts

Posted - 2005-05-05 : 17:22:56
Well....I ended up uninstalling Reporting Services and reinstalling it back. Only took me about 1 hour to do with the deployment of reports so it would be faster than trying to figure out the problems. Hopefully this doesn't happen to someone with a couple hundreds of reports. I only had about 40 so it wasn't too bad. LOL!!!
Go to Top of Page

jhermiz

3564 Posts

Posted - 2005-05-06 : 13:38:35
Man dont tell me you reinstalled all of reporting services. All you had to do was delete and re-add the group, but glad you got it working!


Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection --
[url]http://jhermiz.blogspot.com/[/url]
Go to Top of Page

chriskhan2000
Aged Yak Warrior

544 Posts

Posted - 2005-05-06 : 14:38:13
Jon, only if you responded a little sooner . BTW how would I delete and add the group? I did that under the security setting in Report Manager, but still did not work.
Go to Top of Page

jhermiz

3564 Posts

Posted - 2005-05-06 : 14:41:49
Did you stop and restart the service ? Not sure why it didnt work out for you the first time, I do it all the time when I need to modify / delete groups.

Well as long as you got it working its fine, but that has got to be painful to uninstall and reinstall..especially now that sp2 is out and the integration with sharepoint!


Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection --
[url]http://jhermiz.blogspot.com/[/url]
Go to Top of Page

chriskhan2000
Aged Yak Warrior

544 Posts

Posted - 2005-05-09 : 09:13:57
Yeah, it is a painful process and hopefully I don't have to do it again. I'm not sure why the group from AD did not get applied when I try to delete and then add the group back. Also try restarting the service, but no luck.
Go to Top of Page
   

- Advertisement -