Reporting Services locked up
Posted on 2009-02-20
I have a reporting services instance (SQL 2005) and I can log into <localhost>/ReportServer with my user name and password, but when I try to go to <localhost>/ReportManager with my user name and password, it bounces me back to the login page.
I have no access to add another user, I would have to add the Roles to Users in the database directly...
What tables are necessary to do this? I understand that Roles, Users, Policies, PolicyUserRole are needed, but where are the others...
Also where are the passwords stored for the users in the database?