Publishing a report to the web error

Does anyone know how to fix this error?

-I've tried allowing anonymous access to the site.

-I've added it to my trusted sites.

Error: The request failed with HTTP status 401: Unauthorized.

Thanks.

I've got pass that error and now I am getting this error. I've added my windows account to the server but still keep getting this error. Any ideas?

An error has occurred during report processing.

Cannot create a connection to data source 'ODSTables'.

Login failed for user ''. The user is not associated with a trusted SQL Server connection.|||

The report you are using does not have the correct credentials to execute the query against your underlying data source. Check what credentials you have specified through the report properties tab in report manager or in management studio.

My guess is that the report is set to run with windows integrated credentials. This would be the credentials passed to the report server from IIS. For example, if you set anoynomous credentials on the virtual directory this would be the user the report server is using to connect to the data source. A quick fix would be to store the credentials for the report in the reportserver.

-JonHP

|||I can view this just fine on my local report server. Why can't I view it through the website that I embedded it into? Doesn't make sense. I have my defalut.aspx page authenticated to windows, I have my windows account with permission on the reporting server and my local virtual directory to authenticate with windows integrated security. I also have my web browser to use current log in and password when visiting the site. Why is this so confusing to do?|||

Hi mr4100

Maybe try this. I believe that integrated security only allows 1 hop to pass credentials. You might want to try one of the following.

1) set the data sources property or the report to "Credentials stored securely in the report server" or "Credentials supplied by the user running the report"

or

2) set up a shared use a shared data source with "Credentials stored securely in the report server" or "Credentials supplied by the user running the report"

|||

Hi Mike-

This sort of error can be due to several things. I would start by checking your IIS settings on your Reports and ReportServer virtual directories. More information on setting virtual directory security settings can be found here:

http://msdn2.microsoft.com/en-us/library/zwk103ab.aspx

-JonHP