Using account which is the primary parent site administrator, can upload RDS and RDL files to the document library (however, cannot open report). User is also a domain admin with SA on the database instances.
Cannot add Report Data Source with "New Document" icon.
The permissions granted to user '[domain]\[user]' are insufficient for performing this operation.
Under "Site Settings", "Managed Shared Schedules" fails with same error.
Attempting to deploy from BIDS results in the same permissions error.
Sharepoint Server 2010, Report Server 2008 R2. RS and SP databases hosted on remote server (SQL Server 2008 R2). All connections (SharePoint services, RS services, users) except SQLAgent authenticating to remote SQL Server with Kerberos (all SPNs look
correct). Single site, site collection "/". Document directory called "Reports". Windows Integrated Security (Negotiate).
How would I troubleshoot/solve problem?
View Complete Post