Rendering reports through MOSS accessing SSAS 2007

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Rendering reports through MOSS accessing SSAS 2007

Author

Topic

Andrewra
Starting Member

17 Posts

Posted - 2009-11-19 : 16:24:34

I have come across a particular problem and I can't seem to find anything on it. Here is the situation.

Server 1
Windows server 2008
SQL 2007 SSAS/SSRS/SSIS

Server 2
MOSS 2007

The issue is when running a report from moss that is accessing the OLAP cube on server 1. I receive this error
"
An error occurred during client rendering. An error has occurred during report processing. Cannot create a connection to data source 'CubeOLAP'. The connection either timed out or was lost.
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
An existing connection was forcibly closed by the remote host "

I think it has to do with Kerberos or AES authentication but I am completly stuck on how to resolve this. Any suggestions?

Thanks

Andrew Alexander

shijobaby500
Starting Member

5 Posts

Posted - 2009-12-13 : 09:50:13

http://crystalrepterrinfo.blogspot.com/2009/12/error-occurred-during-client.html

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources