Hi there, This issue may have been discussion thousand time already but i could not find the solution yet.:( We have our data source using sql server account for authentication and that account is admin on the sql server. The reports are working for few users and it is giving windown authentication error for others. I have no idea what is different and how does it even matter because we are using SQL Server authentication. Any suggestions? Thanks!

Do those other users have access to the shared datasource-------------------------------------------------------- Surender Singh Bhadauria

Yes, the user is already added to the sercurity of Shared Data source as "Brower" and "content manager" roles.

Hi LearnQuick, Thanks for your confirmation. But could you please come up with more information about window authentication error you mentioned? As for how to release the reporting service accessing right to your users. Please refer to the steps below: 1. Type http://<servername>/reports in the URL , go to the home page of the Report Manager. 2. Click the Properties tab in the upper-left corner. 3. Click New Role Assignment. 4. Type in Domain\Account in the textbox. 5. Select one or more roles to assign the relevant rights to user. 6. Click Ok. More information about How to: Grant User Access to a Report Server (Report Manager), please refer to the link below: http://msdn.microsoft.com/en-us/library/ms156034(v=SQL.100).aspx If you have anything unclear, please feel free to let me know. Thanks, Bill Lu

This what i did to fix the issue. 1. Go to SSRS report manager and add the user “Domain\User” to Browser role for a. Reports folder b. Data source folder 2. Open IIS and right click on the Default Webservice a. Uncheck the windows authentication b. Check anonymous and set the account to be “Domain\User” . c. Provide the password 3. Reset IIS Point is, the IIS website for SSRS should run under the account which have admin permissions on the box.