Cannot create a connection to data source

[jbphoenix]

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?

 

[SQL_Hell]

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?

 

[jbphoenix]

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.

 

[SQL_Hell]

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?