I am using Report Builder 3.0 and have been trying to run reports using AdventureWorks 2014 in SQL Server Express 2014. My report Server is http://John-PC/ReportServer_SQLExpress.
When I click Run in Report Builder I get a message saying
The permissions granted to User ‘John-PC\John’ are insufficient for performing this operation.
I have confirmed that there is a login for
John-PC\John and that it is assigned to user
John-PC\John. I have tried to give permissions using, among others:
exec sp_addrolemember 'db_owner', 'John-PC\John' which resulted in
command completed successfully but not in changing the error message.
When I connect to SQL Server my own username is
John-PC\John; I suppose that is related but my own permissions seem fine.
I’ve been fighting this for about 3 weeks.
Can someone give me a different approach or correct the one I’m using so that I can run reports in Report Builder ? Thank you very much. John