Hi , I am getting the error "The request failed with HTTP status 401: Unauthorized." sometimes when I try to run from the SQL Agent job. Basically I have one SSIS Package which calls SSRS server to generate scheduled reports and after generating the reports uploaded into Sharepoint library. Now, the errror is not consistent.I have tried couple of times from my local machine that time i did not get the error. when I execute the Job suppose if I ran 5 times I will get 1 time success other time the same error I will get. Please let me know what could be the reason behind that. It looks to me the error is coming when trying to connect SSRS server. Below is the screenshot of the report datasource from SSRS server. Thanks, Saikat

Hi Saikat_1983, Sorry for the delay. From your description, the error sometimes occurs when executing the SQL Server Agent job to run a report. The issue may occur if the credentials are not passed to the report server properly. At this time, I suggest that you check the "User as Windows credentials when connecting to the data source" and make sure the user name is using the "Domain\username" format if it is a domain user. Additionally, since your report server runs in SharePoint Integration mode, the Internet Iinformation Services (IIS) should be enabled. Then, I suggest that you refer to the following link: http://forums.asp.net/t/1606942.aspx/1 If you are using SQL Server 2005, you can also refer to the link below: http://support.microsoft.com/kb/956381 Hope this helps. Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.