Troubleshooting SQL Server 2012 Reporting Services and SharePoint 2010 Integration (Part 2)

This article is part 2 of a troubleshooting series on integrating SQL Server 2012 Reporting Services with SharePoint 2010. It details a common error encountered when creating a new BI Semantic Model Connection in a SharePoint library: 'Cannot connect to the server or database.' The author describes following MSDN instructions and adding the Reporting Services service account to the SSAS Tabular instance as a server administrator, yet the error persisted. The solution was to ensure the Analysis Services service runs under a domain account instead of a default built-in account. Once changed, the BI Semantic Model Connections worked successfully. The article is technical, focused on IT/technology, and provides a practical fix for a specific integration issue.