I can connect to the report server and see the "SQL Server Complianc" report but when my co-worker tries to do the same he gets the following errors:

> An error has occurred during report processing. (rsProcessingAborted)

>   Cannot create a connection to data source 'PolicyDW'. (rsErrorOpeningConnection)

>       For more information about this error navigate to the report server on the local server machine, or enable remote errors

This is the first time I've ever used SSRS and have no idea where to look to fix this.  Does anyone have a suggestion on how to resolve this?

Thanks

Ken

Hi Ken,

   Your coworker may not have adequate SQL Server-level rights to the MDW database, which the reports key off of. Remember, when you deploy the project the reports are using Windows authentication. You're able to see reports because (I'm assuming) you're the DBA and have full rights to that database/instance. Check your coworker's rights to the MDW database and grant permissions as needed. Hope this helps!