Hi all After installing integrating SSRS 2008 R2 with Sharepoint 2007 we are trying to implement the click once functionality for Report Builder 3.0 so that clients can download Reportbuilder. However I keep getting the following error: -
The remote server returned an error: (401) Unauthorized.
Reading through various articles most notably: http://msdn.microsoft.com/en-us/library/ms365173(v=SQL.105).aspx and http://msdn.microsoft.com/en-us/library/cc281309.aspx It seems the problem lies in the fact that the computers lie in different domains and
the account being passed is that of the local client machine.
I have tried to implement the anonymous access as per the second article but this still fails with the same error, and the article is really only for native mode installs. Does anyone know a way around this when using Sharepoint Integration?
My clients will be accessing from the web so having then in the same domain is not an option and neither is anonymous access for the entire site as it is required that they authenticate. This used to work with SQL 2005 SSRS and Reportbuilder but not
for SQL 2008 R2 it seems.
Thanks for any help
View Complete Post