I have built a report using a stored proc as the data source. The report has been deployed and I can run it from the reporting services site. I have admin rights. But if I logout and login as a general user I get the following error. "An error has occurred during report processing. Cannot create a connection to data source "DataSet2"."

I'm stuck and not sure what to do. Is it something to do with permissions?

Looks as if the general user you used has no access to the database. Check the permissions on the database end.

How is your datasource configured?

In sql server mgmt studio, I have a login called z-DM (my general user). I'm not sure what part of the permissions I need to look at. The default db is master. Do I need to change anything in the Server Roles section? Currently I have public and dbcreator checked. Those should allow me to run a report, right?

My data source has the Use shared data source reference checked.

What is the name of the database that the report accesses?

Does the z-DM login have access to this database?

What is the report running? a stored procedure? a view? a sql script?