Sql 2005 SSRS- users other than me cannot access report

Question

I created a report in SQL BI studio, and in the sql server 2005 Configuration tools made all the setup. In IIS the directory security is Anonymous Access ticked. I can access the website, but no one else can. I changed the setting to Integrate Windows Authentication and then the people could connect but they had the username and password box, but i dont want to give them my username and password.

Does anyone have any ideas on how i could get this website of mine accessible to people?

Answer 1

Hi,

Make sure you have granted any users or groups the "browse" permission in Report Manager.

Hope this helps,

Bill

Answer 2

i don't know if this'll fix your problem or not. the way i set up my reports is i create a sql login and set up the data source on the report to use the sql login, so whenever a user views a report, instead of having to explicitly add that user to the database for rights, they just connect to the database as the login.