SQL 2008 R2 Reporting Services with SQL 2012 Analysis Services data source

  • I'm trying to create a data source on our SQL Server 2008 R2 Reporting Services instance that points to a SQL Server 2012 Analysis Services instance. It's not working. I am getting the error "The connection either timed out or was lost."

    I have verified the TCP port used by Analysis Services is available from the Report Services server.

    I have installed SQL 2012 SP2 ADOMD.NET, OLEDB, AMO packages on the 2008 R2 server and the server has been restarted since. Server OS is Windows 2003 (yes, we are in the process of migrating off).

    Any ideas?



    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare


Viewing 0 posts

You must be logged in to reply to this topic. Login to reply