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