You can visit Part 1 of this troubleshooting series by clicking here.
During our configuration of Reporting Services for SharePoint I ran into another common issue.
I consulted MSDN once again and followed the directions given at this MSDN article. Even after following all these instructions, when I would attempt to create a new BI Semantic Model Connection in the SharePoint library, I would receive the following error:
Even after adding the Reporting Services service account to the SSAS Tabular instance as a server administrator, we still hit this error.
Once again I found little documentation out there as I was troubleshooting, presumably because SQL Server 2012 is still quite new. Here’s what we did to fix our problem:
Once we switched this to run under a domain account, I was able to create BI Semantic Model Connections using this library document type with no issues.