Main file updating failed operation canceled 3ds max shawn bolz dating

When I try to go into any report part I am getting this message: An error has occurred during report processing.(rs Processing Aborted) Query execution failed for dataset 'dataset1'.Once I added the permissions to SQL database role with EXECUTE, all was fine!The error message encountered by the user was "An error occurred during client rendering.

I had made changes in both the Data Source and Data object names and query fields in Visual Studio and the query worked in visual Studio.Have just deployed my Project on to my reporting Server.I have multiple datasets which are referencing views which exist on the db on that server.In our case, we have mirrored databases and the connection string did not specify the Failover Partner.So when the database couldn't connect, it never went to the mirror and was throwing this error.