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

This article is the second part of a troubleshooting series on integrating SQL Server 2012 Reporting Services with SharePoint 2010. It details a common issue where creating a new BI Semantic Model Connection in a SharePoint library fails with the error 'Cannot connect to the server or database.' The author explains that the root cause is the Analysis Services (SSAS) service running under a default built-in account instead of a domain account. Switching the SSAS service to a domain account resolves the problem. The article provides practical, step-by-step guidance for IT professionals and developers working with SQL Server and SharePoint integration.