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

Sat, 30 Jun 2012 19:44:36 +0000

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:

Cannot connect to the server or database.

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:

The Analysis Services service must be running under a domain account. When I installed SSAS, I took all the defaults for the server installation. The SSAS service was running under some default built-in account which ended up being the 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.

SSAS on Andrew Bancroft

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