CODEWITHSUNDEEP
excelsql-server-2008ssasolapcube
HugoBeto
HugoBeto

Reputation: 13

OLEDB error with OLAP cube offline

I have a server machine with SQL Server 2008 R2 (Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (X64))

On my machine I have Office Professional Plus2013.

I'm able to connect to any of my OLAP cube databases and browse the cubes through a pivot table with Excel 2013. But, for some reason I'm not able to create an offline cube, when I try to do it I get the following error message:

Microsoft OLE DB Provider for SQL Server 2012 Analysis Services: OLE DB Error: OLE DB or ODBC error: The following system error occurred: ; Either a connection cannot be made to the server, or Analysis Services is not running on the computer specified..

The service is up and running; using excel pivot table I'm able to browse the cube.

Any suggestions would be greatly appreciated!

Thanks!

Upvotes: 0

Views: 1179

Answers (1)

Ferdipux
Ferdipux

Reputation: 5256

Check connectivity to Analysis Services as described in this Technet discussion.

Upvotes: 0

Related Questions